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 61
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 62
- Exam Question
- Correct Answer
- DP-900 Question 63
- Exam Question
- Correct Answer
- Reference
- DP-900 Question 64
- Exam Question
- Correct Answer
- Reference
- DP-900 Question 65
- Exam Question
- Correct Answer
- DP-900 Question 66
- Exam Question
- Correct Answer
- DP-900 Question 67
- Exam Question
- Correct Answer
- Explanation
- DP-900 Question 68
- Exam Question
- Correct Answer
- DP-900 Question 69
- Exam Question
- Correct Answer
- DP-900 Question 70
- Exam Question
- Correct Answer
- Reference
DP-900 Question 61
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
DP-900 Question 62
Exam Question
To complete the sentence, select the appropriate option in the answer area.
You can query a graph database in Azure Cosmos DB __________
Answer Area:
A. as a JSON document by using a SQL-like language.
B. as a partitioned row store by using Cassandra Query Language (CQL).
C. as a partitioned row store by using Language-Integrated Query (LINQ).
D. as nodes and edges by using the Gremlin language.
Correct Answer
A. as a JSON document by using a SQL-like language.
DP-900 Question 63
Exam Question
To complete the sentence, select the appropriate option in the answer area.
To configure an Azure Storage account to support both security at the folder level and atomic directory manipulation, ___________
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.
Reference
Microsoft Learn > Azure > Storage > Blobs > Azure Data Lake Storage Gen2 hierarchical namespace
DP-900 Question 64
Exam Question
Match the Azure Cosmos DB APIs to the appropriate data structures. Each API may be used once, more than once, or not at all.
APIs:
- Cassandra API
- Gremlin API
- MongoDB API
- Table API
Data Structures:
- Graph data
- JSON documents
- Key/value data
Correct Answer
Gremlin API: Graph data
MongoDB API: JSON documents
Table API: Key/value data
Reference
Microsoft Learn > Azure > Azure Cosmos DB > Frequently asked questions about different APIs in Azure Cosmos DB
DP-900 Question 65
Exam Question
Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document?
A. document
B. columnar
C. graph
D. time series
Correct Answer
A. document
DP-900 Question 66
Exam Question
You need to store data in Azure Blob storage for seven years to meet your company’s compliance requirements. The retrieval time of the data is unimportant. The solution must minimize storage costs.
Which storage tier should you use?
A. Archive
B. Hot
C. Cool
Correct Answer
A. Archive
DP-900 Question 67
Exam Question
Which storage solution supports role-based access control (RBAC) at the file and folder level?
A. Azure Disk Storage
B. Azure Data Lake Storage
C. Azure Blob storage
D. Azure Queue storage
Correct Answer
B. Azure Data Lake Storage
Explanation
Microsoft Learn > Azure > Storage > Blobs > Access control lists (ACLs) in Azure Data Lake Storage Gen2
DP-900 Question 68
Exam Question
Your company is designing a data store that will contain student data. The data has the following format.
| StudentNumber | StudentInformation |
|---|---|
| 7634634 | First name: Ben Last: Smith Preferred Name: Benjamin |
| 7634634 | First Name: Dominik Last Name: Paiha Email Address: [email protected] MCP ID: 931817 |
| 7634636 | First Name: Reshma Last Nama: Patel Phone number: 514-555-1101 |
| 7634637 | First Name: Yun-Feng Last Name: Peng |
Which type of data store should you use?
A. graph
B. key/value
C. object
D. columnar
Correct Answer
D. columnar
DP-900 Question 69
Exam Question
You have an Azure Cosmos DB account that uses the Core (SQL) API.
Which two settings can you configure at the container level?
A. the throughput
B. the read region
C. the partition key
D. the API
Correct Answer
A. the throughput
C. the partition key
DP-900 Question 70
Exam Question
Match the types of data stores to the appropriate scenarios. Each data store type may be used once, more than once, or not at all.
Data Store Types:
- Graph
- Object
- Key/value
Scenarios:
- Application users and their default language
- Medical images and their associated metadata
- Employee data that shows the relationships between employees
Correct Answer
Key/value: Application users and their default language
Object: Medical images and their associated metadata
Graph: Employee data that shows the relationships between employees
Reference
Microsoft Learn > Azure > Architecture > Application Architecture Guide > Understand data store models