Azure Data Fundamentals (DP-900) - Full Practice Exam 1

1. A bank transfers money between two accounts. Both balance changes must succeed together or neither should take effect. Which transaction property is required?
2. A business analyst aggregates five years of sales by product and region. Which workload category best fits?
3. A business needs to store PDFs, photographs, and exported backups using object names and HTTP APIs. Which Azure data service is the most direct fit?
4. A business wants to examine a measure over successive monthly periods. Which visualization is generally suitable for showing this trend?
5. A checkout system must record many small purchases quickly while preserving the correctness of each order. Which workload category best fits?
6. A company needs a managed service to orchestrate copying data from several sources and running transformation activities on a schedule. Which Azure service is designed for this?
7. A company needs someone to maintain database availability, backups, and permissions. Which data role is the closest match?
8. A data archive can tolerate delayed retrieval and is accessed very rarely. Which Blob Storage tier should be considered when its minimum retention and rehydration conditions fit?
9. A data platform uses replication and must also recover from accidental logical deletion. Which TWO statements are correct? Select TWO.
10. A database commits a transaction successfully. Its changes must survive a subsequent process restart. Which ACID property describes this requirement?
11. A developer chooses a partition key for a large Cosmos DB container. What is the main purpose of logical partitioning?
12. A developer must create a new table with typed columns. Which SQL statement is the direct fit?
13. A developer needs to add a new order record to a relational table. Which SQL statement category includes the required INSERT operation?
14. A developer wants reusable database-side logic that accepts parameters and performs several SQL operations. Which object is most appropriate?
15. A document database stores each product as a JSON document. Which two characteristics commonly support this model? Select TWO.
16. A globally used application needs a managed NoSQL database with configurable consistency and regional distribution. Which service is designed for this combination?
17. A legacy application requires a shared folder mounted over SMB by several Windows machines. Which service best matches its file-system interface?
18. A media company stores raw video recordings for later analysis. Which classification best describes the recording content?
19. A migration requires broad SQL Server instance compatibility, including SQL Server Agent, while reducing VM operating system administration. Which Azure SQL deployment option should be evaluated first?
20. A monitoring system evaluates sensor readings as they arrive and detects unusual temperatures within seconds. Which processing pattern is the best fit?
21. A nightly job processes all sales files received during the day after stores close. Which processing pattern is this?
22. A pipeline extracts source records, transforms them on a separate processing system, and then loads curated data into a warehouse. Which pattern does this describe?
23. A project needs someone to create ingestion pipelines and transform source data into analytics-ready datasets. Which data role best fits?
24. A report needs to compare sales totals across product categories. Which visualization is generally the clearest starting point?
25. A reporting platform stores cleansed historical facts and dimensions optimized for repeatable business analysis. Which component best matches?
26. A sales model has a central Sales fact table linked to Product, Date, and Store dimension tables. Which modeling pattern is this?
27. A service needs a simple schemaless NoSQL entity store accessed efficiently by PartitionKey and RowKey. Which Azure Storage offering matches?
28. A social application primarily queries connections between users and their friends. Which non-relational data model most directly represents these relationships?
29. A store records each order in tables with predefined columns, data types, and relationships. Which data classification best describes these order records?
30. A team needs someone to model business metrics, build dashboards, and explain trends to decision makers. Which role is the closest match?
31. A team says a NoSQL database cannot have any structure because it does not require a relational schema. Which explanation is most accurate?
32. A team splits repeated customer details out of orders into a separate Customer table and references the customer key. What design technique is being applied?
33. A team wants a managed Azure SQL database for one application without operating the underlying database server OS. Which option is the most direct fit?
34. A team wants an analytics service that brings together SQL analytics, Spark, and data integration capabilities. Which Azure service should it evaluate?
35. A team wants users to query a reusable logical projection of selected columns from several tables without copying the data into a separate base table. Which object should it consider?
36. A telemetry system needs managed continuous processing over incoming events using a SQL-like query language. Which Azure service is a direct fit?
37. A warehouse ingests raw data first and uses its own compute engine to transform that data afterward. Which pattern is being used?
38. A web front end must place work requests in a simple queue for background workers to process asynchronously. Which Azure Storage service directly supports this pattern?
39. An analyst needs a query that combines orders with customer names using their related customer identifiers. Which SQL operation is most appropriate?
40. An analytics platform stores large amounts of raw structured, semi-structured, and unstructured data for different future processing needs. Which architectural component best fits?
41. An application requires a specific SQL Server version and full control of the guest operating system. Which Azure SQL option best fits?
42. An application stores JSON customer profiles whose optional fields differ between documents. Which data classification is the best fit?
43. An existing application uses PostgreSQL features and must retain its PostgreSQL engine while moving to a managed Azure service. Which offering is the closest fit?
44. An order table has one unique identifier for each order. Which relational construct enforces the identity of each row?
45. Analysts need descriptive attributes such as product category and brand for grouping sales measures. Where do these attributes typically belong in a star schema?
46. Business users need interactive dashboards and reports based on an analytical semantic model. Which Microsoft product is designed for this?
47. Data engineers want collaborative notebooks and distributed Spark processing on Azure. Which service best matches this requirement?
48. Every OrderItem must reference an existing Order. Which database construct is designed to enforce this relationship?
49. In a retail analytical model, which item is most naturally a measure in the sales fact table?
50. Two transactions execute concurrently. Each must be protected from inappropriate interference by the other's uncommitted changes. Which ACID property addresses this?

Comments — 0