Introduction
Welcome to our comprehensive guide on the DP-900 Microsoft Azure Data Fundamentals exam! In this article, we’ll present a selection of practice questions and their detailed answers to help you prepare for the exam. So, let’s get started!
DP-900 Question 51
Exam Question
To ensure that an Azure Storage account supports access control lists with object-level permissions, which of the following options should you select?
Answer Choices:
A. Enable the hierarchical namespace.
B. Set Account kind to BlobStorage.
C. Set Performance to Premium.
D. Set Replication to Read-access geo-redundant storage (RA-GRS).
Correct Answer:
A. Enable the hierarchical namespace.
Explanation:
Enabling the hierarchical namespace is a critical step in configuring an Azure Storage account to support access control lists that have object-level permissions. The hierarchical namespace allows you to organize objects/files within an account into a directory and subdirectory hierarchy, mirroring the file system structure on your computer. By enabling the hierarchical namespace, you ensure that the storage account delivers the scalability and cost-effectiveness of object storage while retaining the familiar file system semantics required by analytics engines and frameworks.
Reference:
Microsoft Learn > Azure > Storage > Blobs > Azure Data Lake Storage Gen2 hierarchical namespace
DP-900 Question 52
Exam Question
For each of the following statements, indicate whether the statement is true or false:
Statement 1: Azure Table storage within a single Azure Storage account supports multiple concurrent reads in different Azure regions.
Statement 2: Azure Table storage within a single Azure Storage account supports multiple concurrent writes in different Azure regions.
Statement 3: An Azure Cosmos DB account that uses the Table API supports multiple concurrent reads in different Azure regions.
Statement 4: An Azure Cosmos DB account that uses the Table API supports multiple concurrent writes in different Azure regions.
Correct Answer:
Statement 1: True
Statement 2: False
Statement 3: True
Statement 4: True
Explanation:
- Statement 1: Azure Table storage within a single Azure Storage account supports multiple concurrent reads in different Azure regions.
- Statement 2: Azure Table storage within a single Azure Storage account DOES NOT support multiple concurrent writes in different Azure regions.
- Statement 3: An Azure Cosmos DB account that uses the Table API supports multiple concurrent reads in different Azure regions.
- Statement 4: An Azure Cosmos DB account that uses the Table API supports multiple concurrent writes in different Azure regions.
Reference:
None
DP-900 Question 53
Exam Question
You need to recommend a data store service that satisfies the following requirements:
- Native SQL API access
- Configurable indexes
Which service should you recommend?
Correct Answer:
D. Azure Cosmos DB
Explanation:
Azure Cosmos DB provides native Core (SQL) API support, allowing you to access data using SQL queries. It also offers configurable indexes, which allow you to define indexing policies for each container. By default, range indexes are enforced for strings and numbers, but you can override this with a custom indexing policy.
Reference:
Microsoft Learn > Azure > Azure Cosmos DB > NoSQL > Manage indexing policies in Azure Cosmos DB
DP-900 Question 54
Exam Question
To store data using Azure Table storage, what should you create first?
Correct Answer:
B. A storage account
Explanation:
Before you can begin using Azure Table storage, you need to create a storage account. Once the storage account is set up, you can then create a table using the Table service in the Azure portal. Remember, an Azure storage account is the container for all your Azure Storage objects, including blobs, files, queues, and tables.
Reference:
- Microsoft Learn > Azure > Storage > Tables > Quickstart: Create a table in the Azure portal
- Microsoft Learn > Azure > Storage > Create a storage account
DP-900 Question 55
Exam Question
To provision an Azure Cosmos DB __, you must specify the type of API you will use.
Answer Choices:
A. Account
B. Container
C. Database
D. Item
Correct Answer:
A. Account
Reference:
Microsoft Learn > Azure > Azure Cosmos DB > NoSQL > Quickstart: Create an Azure Cosmos DB account, database, container, and items from the Azure portal
DP-900 Question 56
Exam Question
Match each data store service with its appropriate description.
Services:
- Azure Blob storage
- Azure Cosmos DB
- Azure Files
- Azure Table storage
Descriptions:
- Enables the use of SQL queries against data stored in JSON documents.
- Enables users to access data using the Server Message Block (SMB) version 3 protocol.
Correct Answer:
Azure Cosmos DB: Enables the use of SQL queries against data stored in JSON documents.
Azure Files: Enables users to access data using the Server Message Block (SMB) version 3 protocol.
Explanation:
Azure Cosmos DB allows you to query data stored in JSON documents using SQL queries. On the other hand, Azure Files enables users to access data using the Server Message Block (SMB) version 3 protocol.
Reference:
- Microsoft Learn > Azure > Azure Cosmos DB > NoSQL > Working with JSON in Azure Cosmos DB
- Azure SMB: Accessing File Shares in the Cloud
DP-900 Question 57
Exam Question
For each of the following statements, indicate whether the statement is true or false:
Statement 1: Azure Databricks can consume data from Azure SQL Database.
Statement 2: Azure Databricks can consume data from Azure Event Hubs.
Statement 3: Azure Databricks can consume data from Azure Cosmos DB.
Correct Answer:
Statement 1: True
Statement 2: True
Statement 3: True
Explanation:
- Statement 1: Azure Databricks can consume data from Azure SQL Database. It can do so using JDBC or the Apache Spark connector.
- Statement 2: Azure Databricks can consume data from Azure Event Hubs.
- Statement 3: Azure Databricks can consume data from Azure Cosmos DB. You can run Spark jobs with data stored in Azure Cosmos DB using the Cosmos DB Spark connector, which supports both batch and stream processing.
Reference:
- Microsoft Learn > Azure > Azure Databricks > SQL Databases using the Apache Spark connector
- Microsoft Learn > Azure > Azure Databricks > Azure Event Hubs
DP-900 Question 58
Exam Question
Your company needs to design a database that shows how changes in network traffic in one area of a network affect network traffic in other areas. Which type of data store should you use?
Correct Answer:
A. Graph
Explanation:
To represent the relationship between network traffic in different areas, a graph database is the most appropriate choice. Traditional data modeling focuses on defining separate entities and computing their relationships at runtime, but this approach can be challenging for highly connected data. Graph databases, on the other hand, persist relationships in the storage layer, enabling efficient graph retrieval operations. Azure Cosmos DB’s Gremlin API supports the property graph model and is well-suited for this scenario.
Reference:
Microsoft Learn > Azure > Azure Cosmos DB > Apache Gremlin > Introduction to Azure Cosmos DB for Apache Gremlin > Introduction to graph databases
DP-900 Question 59
Exam Question
What is a benefit of the Azure Cosmos DB Table API compared to Azure Table storage?
Correct Answer:
D. Supports a multi-master model
Explanation:
The Azure Cosmos DB Table API offers a distinct advantage over Azure Table storage by supporting a multi-master model. This means that Cosmos DB allows multiple regions to host writable replicas of your data, ensuring high availability and resiliency even in the case of failovers. In contrast, Azure Table storage does not provide this level of multi-master support.
Reference:
Microsoft Learn > Azure > Azure Cosmos DB > Table > Developing with Azure Cosmos DB for Table and Azure Table storage
DP-900 Question 60
Exam Question
When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?
Correct Answer:
B. Availability Zones
Explanation:
For redundancy within an Azure region, you should leverage Availability Zones when provisioning an Azure Cosmos DB account. When enabled, Azure Cosmos DB ensures that replicas are distributed across multiple zones within a given region, providing high availability and resiliency in the event of zonal failures.
Reference:
Microsoft Learn > Azure > Azure Cosmos DB > Achieve high availability with Azure Cosmos DB
In this article, we covered a variety of questions to help you prepare for the DP-900 Microsoft Azure Data Fundamentals exam. We hope you found this resource valuable and wish you the best of luck in your exam preparation!
