Overview of Azure Data Fundamentals
The DP-900 certification is an essential milestone in your Azure journey. Our practice tests simulate the real exam format, helping you build confidence and identify knowledge gaps. Review the detailed explanations provided after each question to deeply understand the underlying cloud concepts.
Sample DP-900 Practice Questions
Question 1
Contoso Ltd is migrating its data storage from on-premises to Azure. They have a large dataset that includes structured data in CSV format, semi-structured data in JSON format, and unstructured images and videos. Which Azure service would you recommend for storing and querying the structured CSV data while ensuring it meets the ACID properties for transactional integrity?
- Azure Cosmos DB
- Azure SQL Database
- Azure Blob Storage
- Azure Table Storage
The correct answer is B: Azure SQL Database. Azure SQL Database provides a relational database service that supports ACID transactions, which is essential for maintaining data integrity during transactions. It can efficiently store and query structured data like CSV files. Option A (Azure Cosmos DB) is not suitable for transactional workloads with ACID properties; it is more suited for NoSQL and document-based data models. Option C (Azure Blob Storage) is used for storing unstructured data but does not support transactional ACID properties. Option D (Azure Table Storage) is also not appropriate as it is designed for NoSQL key-value pairs and does not support ACID transactions.
Question 2
During a performance review, you notice that the semi-structured JSON data stored in Azure Blob Storage is not being queried efficiently due to the lack of schema enforcement. What Azure service should you recommend to improve query performance by enforcing a schema and allowing for more efficient querying of semi-structured data?
- Azure SQL Database
- Azure Cosmos DB
- Azure Blob Storage
- Azure Table Storage
The correct answer is B: Azure Cosmos DB. Azure Cosmos DB allows you to define a schema for your semi-structured JSON data, which improves query performance and enables more efficient querying. Option A (Azure SQL Database) is not suitable for semi-structured data as it requires a fixed schema. Option C (Azure Blob Storage) does not provide any schema enforcement or advanced querying capabilities. Option D (Azure Table Storage) is designed for NoSQL key-value pairs and does not support semi-structured data or schema enforcement.
Question 3
Contoso Ltd has a hybrid configuration where some of their unstructured video data is stored in Azure Blob Storage and some in on-premises storage. They want to ensure that all video data is accessible and can be queried efficiently. What Azure service should you recommend to centralize and manage this unstructured video data while providing efficient querying capabilities?
- Azure Blob Storage
- Azure Media Services
- Azure Data Lake Storage
- Azure File Storage
The correct answer is B: Azure Media Services. Azure Media Services can be used to centralize and manage unstructured video data, providing efficient querying and access capabilities through its media processing and analytics features. Option A (Azure Blob Storage) is not sufficient for querying video data efficiently. Option C (Azure Data Lake Storage) is more suited for big data analytics and does not provide media processing capabilities. Option D (Azure File Storage) is not designed for unstructured data and does not offer media processing features.
Use the interactive quiz engine above to answer these questions and hundreds more.