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 41
- Exam Question
- Correct Answer
- Reference
- DP-900 Question 42
- Exam Question
- Correct Answer
- Reference
- DP-900 Question 43
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 44
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 45
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 46
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 47
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 48
- Exam Question
- Correct Answer
- Reference
- DP-900 Question 49
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 50
- Exam Question
- Correct Answer
- Explanation
- Reference
DP-900 Question 41
Exam Question
To complete the sentence, select the appropriate option in the answer area.
When using the Azure Cosmos DB Gremlin API, the container resource type is projected as a __________.
Answer Area:
A. graph.
B. table.
C. partition key.
D. document.
Correct Answer
A. graph.
Reference
Microsoft Learn >Azure > Azure Cosmos DB > Apache Gremlin > Quickstart: Create, query, and traverse an Azure Cosmos DB graph database using the Gremlin console
DP-900 Question 42
Exam Question
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Statement 1: Copying data to Azure Data Lake Storage from another Azure region results in extra cost.
Statement 2: You can use blob, table, and file storage in the same Azure Storage account.
Statement 3: You implement Azure Data Lake Storage by creating an Azure Storage account.
Correct Answer
Statement 1: Copying data to Azure Data Lake Storage from another Azure region results in extra cost: Yes
Statement 2: You can use blob, table, and file storage in the same Azure Storage account: Yes
Statement 3: You implement Azure Data Lake Storage by creating an Azure Storage account: Yes
Reference
Microsoft Learn > Azure > Data Lake Storage Gen1 > Get started with Azure Data Lake Storage Gen1 using the Azure portal
Microsoft Learn > Azure > Storage > Storage account overview
DP-900 Question 43
Exam Question
Your company is designing a data store for internet-connected temperature sensors.
The collected data will be used to analyze temperature trends.
Which type of data store should you use?
A. relational
B. time series
C. graph
D. columnar
Correct Answer
B. time series
Explanation
Time series data is a set of values organized by time. Time series databases typically collect large amounts of data in real time from a large number of sources. Updates are rare, and deletes are often done as bulk operations. Although the records written to a time-series database are generally small, there are often a large number of records, and total data size can grow rapidly.
Reference
Microsoft Learn > Azure > Architecture > Application Architecture Guide > Understand data store models
DP-900 Question 44
Exam Question
You need to recommend a non-relational data store that is optimized for storing and retrieving text files, videos, audio streams, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file.
Which type of data store should you recommend?
A. key/value
B. columnar
C. object
D. document
Correct Answer
C. object
Explanation
Object storage is optimized for storing and retrieving large binary objects (images, files, video and audio streams, large application data objects and documents, virtual machine disk images). Large data files are also popularly used in this model, for example, delimiter file (CSV), parquet, and ORC. Object stores can manage extremely large amounts of unstructured data.
Reference
Microsoft Learn > Azure > Architecture > Application Architecture Guide > Understand data store models
DP-900 Question 45
Exam Question
Your company is designing an application that will write a high volume of JSON data and will have an application-defined schema.
Which type of data store should you use?
A. columnar
B. key/value
C. document
D. graph
Correct Answer
B. key/value
Explanation
A key/value store associates each data value with a unique key.
An application can store arbitrary data as a set of values. Any schema information must be provided by the application. The key/value store simply retrieves or stores the value by key.
Reference
Microsoft Learn > Azure > Architecture > Application Architecture Guide > Understand data store models
DP-900 Question 46
Exam Question
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Statement 1: The Azure Cosmos DB API is configured separately for each database in an Azure Cosmos DB account.
Statement 2: Partition keys are used in Azure Cosmos DB to optimize queries.
Statement 3: Items contained in the same Azure Cosmos DB logical partition can have different partition keys.
Correct Answer
Statement 1: The Azure Cosmos DB API is configured separately for each database in an Azure Cosmos DB account: No
Statement 2: Partition keys are used in Azure Cosmos DB to optimize queries: Yes
Statement 3: Items contained in the same Azure Cosmos DB logical partition can have different partition keys: No
Explanation
Statement 1: The Azure Cosmos DB API is configured separately for each database in an Azure Cosmos DB account: No
The API determines the type of account to create. Azure Cosmos DB provides five APIs: Core (SQL) and MongoDB for document data, Gremlin for graph data, Azure Table, and Cassandra. Currently, you must create a separate account for each API.
Statement 2: Partition keys are used in Azure Cosmos DB to optimize queries: Yes
Azure Cosmos DB uses partitioning to scale individual containers in a database to meet the performance needs of your application. In partitioning, the items in a container are divided into distinct subsets called logical partitions. Logical partitions are formed based on the value of a partition key that is associated with each item in a container.
Statement 3: Items contained in the same Azure Cosmos DB logical partition can have different partition keys: No
Logical partitions are formed based on the value of a partition key that is associated with each item in a container.
Reference
Microsoft Learn > Azure > Azure Cosmos DB > Partitioning and horizontal scaling in Azure Cosmos DB
DP-900 Question 47
Exam Question
You have an application that runs on Windows and requires access to a mapped drive.
Which Azure service should you use?
A. Azure Files
B. Azure Blob storage
C. Azure Cosmos DB
D. Azure Table storage
Correct Answer
A. Azure Files
Explanation
Azure Files is Microsoft’s easy-to-use cloud file system. Azure file shares can be seamlessly used in Windows and Windows Server.
To use an Azure file share with Windows, you must either mount it, which means assigning it a drive letter or mount point path, or access it via its UNC path.
Reference
Microsoft Learn > Azure > Storage > Files > Mount SMB Azure file share on Windows
DP-900 Question 48
Exam Question
Your company is designing a database that will contain session data for a website. The data will include notifications, personalization attributes, and products that are added to a shopping cart.
Which type of data store will provide the lowest latency to retrieve the data?
A. key/value
B. graph
C. columnar
D. document
Correct Answer
C. columnar
Reference
Microsoft Learn > Azure > Architecture > Data Architecture Guide > Choose an analytical data store in Azure
DP-900 Question 49
Exam Question
You manage an application that stores data in a shared folder on a Windows server.
You need to move the shared folder to Azure Storage.
Which type of Azure Storage should you use?
A. queue
B. blob
C. file
D. table
Correct Answer
C. file
Explanation
Azure file shares can be mounted concurrently by cloud or on-premises deployments of Windows, Linux, and macOS. Azure file shares can also be cached on Windows Servers with Azure File Sync for fast access near where the data is being used.
Reference
DP-900 Question 50
Exam Question
Your company needs to design a database that illustrates the relationships between utilization levels of individual network devices across a local area 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