The latest Microsoft DP-900 Azure Data Fundamentals certification actual real practice exam question and answer (Q&A) dumps are available free, which are helpful for you to pass the Microsoft DP-900 Azure Data Fundamentals exam and earn Microsoft DP-900 Azure Data Fundamentals certification.
Table of Contents
- DP-900 Question 51
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 52
- Exam Question
- Correct Answer
- Explanation
- DP-900 Question 53
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 54
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 55
- Exam Question
- Correct Answer
- Reference
- DP-900 Question 56
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 57
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 58
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 59
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 60
- Exam Question
- Correct Answer
- Explanation
- Reference
DP-900 Question 51
Exam Question
To complete the sentence, select the appropriate option in the answer area.
To configure an Azure Storage account to support access control lists that have object-level permissions, __________.
Answer Area:
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
A key mechanism that allows Azure Data Lake Storage Gen2 to provide file system performance at object storage scale and prices is the addition of a hierarchical namespace. This allows the collection of objects/files within an account to be organized into a hierarchy of directories and nested subdirectories in the same way that the file system on your computer is organized. With a hierarchical namespace enabled, a storage account becomes capable of providing the scalability and cost-effectiveness of object storage, with file system semantics that are familiar to 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, select Yes if the statement is true. Otherwise, select No.
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: Azure Table storage within a single Azure Storage account supports multiple concurrent reads in different Azure regions: Yes
Statement 2: Azure Table storage within a single Azure Storage account supports multiple concurrent writes in different Azure regions: No
Statement 3: An Azure Cosmos DB account that uses the Table API supports multiple concurrent reads in different Azure regions: Yes
Statement 4: An Azure Cosmos DB account that uses the Table API supports multiple concurrent writes in different Azure regions: Yes
Explanation
Statement 1: Azure Table storage within a single Azure Storage account supports multiple concurrent reads in different Azure regions: Yes
For read access to the secondary region, configure your storage account to use read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS).
Statement 2: Azure Table storage within a single Azure Storage account supports multiple concurrent writes in different Azure regions: No
Statement 3: An Azure Cosmos DB account that uses the Table API supports multiple concurrent reads in different Azure regions: Yes
Statement 4: An Azure Cosmos DB account that uses the Table API supports multiple concurrent writes in different Azure regions: Yes
Azure Cosmos DB supports multi-region writes.
DP-900 Question 53
Exam Question
You need to recommend a data store service that meets the following requirements:
- Native SQL API access
- Configurable indexes
What should you recommend?
A. Azure Files
B. Azure Blob storage
C. Azure Table storage
D. Azure Cosmos DB
Correct Answer
D. Azure Cosmos DB
Explanation
Azure Cosmos DB comes with native Core (SQL) API support.
In Azure Cosmos DB, data is indexed following indexing policies that are defined for each container. The default indexing policy for newly created containers enforces range indexes for any string or number. This policy can be overridden with your own custom indexing policy.
Reference
Microsoft Learn > Azure > Azure Cosmos DB > NoSQL > Manage indexing policies in Azure Cosmos DB
DP-900 Question 54
Exam Question
You need to store data by using Azure Table storage.
What should you create first?
A. an Azure Cosmos DB instance
B. a storage account
C. a blob container
D. a table
Correct Answer
B. a storage account
Explanation
First create an Azure storage account, then use Table service in the Azure portal to create a table.
Note: An Azure storage account contains all of your Azure Storage data objects: 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 complete the sentence, select the appropriate option in the answer area.
When provisioning an Azure Cosmos DB __________, you need to specify which type of API you will use.
Answer Area:
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 the datastore services to the appropriate descriptions. Each service may be used once, more than once, or not at all.
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 by 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 by using the Server Message Block (SMB) version 3 protocol.
Explanation
Azure Cosmos DB: Enables the use of SQL queries against data stored in JSON documents.
In Azure Cosmos DB’s SQL (Core) API, items are stored as JSON. The type system and expressions are restricted to deal only with JSON types.
Azure Files: Enables users to access data by using the Server Message Block (SMB) version 3 protocol.
Azure Files offers native cloud file sharing services based on the SMB 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, select Yes if the statement is true. Otherwise, select No.
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: Azure Databricks can consume data from Azure SQL Database: Yes
Statement 2: Azure Databricks can consume data from Azure Event Hubs: Yes
Statement 3: Azure Databricks can consume data from Azure Cosmos DB: Yes
Explanation
Statement 1: Azure Databricks can consume data from Azure SQL Database: Yes
Azure Databricks can consume data from SQL Databases using JDBC and from SQL Databases using the Apache Spark connector.
The Apache Spark connector for Azure SQL Database and SQL Server enables these databases to act as input data sources and output data sinks for Apache Spark jobs.
Statement 2: Azure Databricks can consume data from Azure Event Hubs: Yes
You can stream data into Azure Databricks using Event Hubs.
Statement 3: Azure Databricks can consume data from Azure Cosmos DB: Yes
You can run Spark jobs with data stored in Azure Cosmos DB using the Cosmos DB Spark connector.
Cosmos can be used for batch and stream processing, and as a serving layer for low latency access.
You can use the connector with Azure Databricks or Azure HDInsight, which provide managed Spark clusters on Azure.
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 of the network.
Which type of data store should you use?
A. graph
B. key/value
C. document
D. columnar
Correct Answer
A. graph
Explanation
Data as it appears in the real world is naturally connected. Traditional data modeling focuses on defining entities separately and computing their relationships at runtime. While this model has its advantages, highly connected data can be challenging to manage under its constraints.
A graph database approach relies on persisting relationships in the storage layer instead, which leads to highly efficient graph retrieval operations. Azure Cosmos DB’s Gremlin API supports the property graph model.
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 as compared to Azure Table storage?
A. provides resiliency if an Azure region fails
B. supports partitioning
C. provides a higher storage capacity
D. supports a multi-master model
Correct Answer
D. supports a multi-master model
Explanation
Multi-master support for Azure Cosmos DB is now available in all public regions.
Azure CosmosDB table API is a key-value storage hosted in the cloud. It’s a part of Azure Cosmos DB, that is Microsoft’s multi-model database.
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?
A. multi-master replication
B. Availability Zones
C. the strong consistency level
D. automatic failover
Correct Answer
B. Availability Zones
Explanation
With Availability Zone (AZ) support, Azure Cosmos DB will ensure replicas are placed across multiple zones within a given region to provide high availability and resiliency to zonal failures.
Note: Azure Cosmos DB provides high availability in two primary ways. First, Azure Cosmos DB replicates data across regions configured within a Cosmos account. Second, Azure Cosmos DB maintains 4 replicas of data within a region.
Reference
Microsoft Learn > Azure > Azure Cosmos DB > Achieve high availability with Azure Cosmos DB