Describe core data concepts Questions
Practice questions for Describe core data concepts topic in Microsoft Certified: Azure Data Fundamentals. 61 questions covering this domain.
If a transaction fails partway through in an OLTP system, what should happen to the work that already started?
Why can heavily normalized transactional databases be difficult for business users to query directly for reporting?
A manufacturer wants to analyze five years of sales to find seasonal trends and compare regional performance. Which workload type fits this goal?
A finance team exports daily sales data as comma-delimited text files with one row per transaction. Which file format are they using?
A team stores device events as JSON documents where fields can vary between records. How should this data be classified?
A business unit already has prepared data and wants someone to build reports, dashboards, and visual summaries. Which role is the best fit?
A retail system must capture customer orders and payments immediately and keep each update consistent. Which workload type does this describe?
A finance team runs large aggregate queries directly on a busy OLTP database during business hours. What is the main risk?
A company needs to ingest data from multiple sources, transform it, and load it into a reporting store. Which role is primarily responsible for that w...
Which description best matches structured data?
Which responsibility most closely matches the role of a database administrator?
A media company is archiving product photos and training videos. Which type of data is it primarily storing?
An OLTP system stores customer addresses in many different order rows, and updates are becoming error-prone. What should the team do first?
A new order management application requires joins, strong consistency, and a fixed schema. Which type of database is the best fit?
A company wants analytics that recommends specific actions based on data and predictions (e.g., "offer this discount to retain this customer"). Which ...
Which statement best describes a data warehouse compared to an operational database?
Which role primarily defines data classifications, governance rules, and stewardship policies across an organization's data estate?
Which term describes data that has tags or markers separating elements but doesn't fit a strict relational schema (e.g., JSON or XML)?
An organization wants to load raw data into a destination first and then transform it inside the analytics platform. Which integration pattern matches...
An e-commerce site needs to read its product catalog frequently and insert new orders rapidly with strong consistency. Which workload type does this d...
Sign in to see all 61 questions
Create a free account to browse all questions — completely free during our launch phase.