Exam Code: DP-900 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Microsoft Azure Data Fundamentals
Certification Provider: Microsoft
Free Today! Guaranteed Training- Pass DP-900 Exam.
Free demo questions for Microsoft DP-900 Exam Dumps Below:
NEW QUESTION 1
Select the answer that correctly completes the sentence.For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
Solution:

Does this meet the goal?
- A. Yes
- B. Not Mastered
Answer: A
NEW QUESTION 2
Match the Azure services to the appropriate locations in the architecture.
To answer, drag the appropriate service from the column on the left to its location on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Solution:
Box Ingest: Azure Data Factory
You can build a data ingestion pipeline with Azure Data Factory (ADF). Box Preprocess & model: Azure Synapse Analytics
Use Azure Synapse Analytics to preprocess data and deploy machine learning models.
Does this meet the goal?
- A. Yes
- B. Not Mastered
Answer: A
NEW QUESTION 3
Match the types of workloads the appropriate scenario.
To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once or not at all.
NOTE: Each correct match is worth one point.
Solution:

Does this meet the goal?
- A. Yes
- B. Not Mastered
Answer: A
NEW QUESTION 4
You have an Azure SQL database that you access directly from the internet. You recently changed your external IP address.
After changing the IP address, you can no longer access the database. You can connect to other resources in Azure
What is a possible cause of the issue?
- A. a database-level firewall
- B. role-based access control (RSAC)
- C. Dynamic Host Configuration Protocol (DHCP)
- D. Domain Name Service (DNS)
Answer: A
Explanation:
The Azure SQL Database firewall lets you decide which IP addresses may or may not have access to either your Azure SQL Server or your Azure SQL database.
When creating an Azure SQL Database, the firewall needs to be configured before anyone will be able to access the database. By default, no external access to your SQL Database will be allowed until you explicitly assign permission by creating a firewall rule.
NEW QUESTION 5
Which storage solution supports access control lists (ACLs) at the file and folder level?
- A. Azure Data Lake Storage
- B. Azure Cosmos DB
- C. Azure Queue storage
- D. Azure Blob storage
Answer: A
Explanation:
Azure Data Lake Storage Gen2 implements an access control model that supports both Azure role-based access control (Azure RBAC) and POSIX-like access control lists (ACLs).
NEW QUESTION 6
Match the types of data stores to the appropriate scenarios.
To answer, drag the appropriate data store type from the column on the left to its scenario on the right. Each data store type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Solution:

Does this meet the goal?
- A. Yes
- B. Not Mastered
Answer: A
NEW QUESTION 7
Match the types of data to the appropriate Azure data services.
To answer, drag the appropriate data types from the column on the left to its service on the right. Each data type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Solution:
Box 1: Image files
Azure Blob storage is suitable for image files. Box 2:Key/value pairs
Azure CosmosDB table API is a key-value storage hosted in the cloud. Box 3: Relationship between employees
One-to-many relationships between business domain objects occur frequently: for example, one department has many employees. There are several ways to implement one-to-many relationships in the Azure Table service.
Does this meet the goal?
- A. Yes
- B. Not Mastered
Answer: A
NEW QUESTION 8
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Solution:

Does this meet the goal?
- A. Yes
- B. Not Mastered
Answer: A
NEW QUESTION 9
What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?
- A. supports partitioning
- B. provides resiliency if art Azure region fads
- C. provides a higher storage capacity
- D. supports a multi-master model
Answer: D
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.
NEW QUESTION 10
You need to create a visualization of running sales totals per quarter as shown in the following exhibit.
What should you create in Power BI Desktop?
- A. a waterfall chart
- B. a ribbon chart
- C. a bar chart
- D. a decomposition tree
Answer: A
NEW QUESTION 11
To complete the sentence, select the appropriate option in the answer area.
Solution:
Text Description automatically generated with low confidence
Descriptive, to answer the question: What’s happening? Company name Description automatically generated

Note: Azure Media Indexer enables you to make content of your media files searchable and to generate a
full-text transcript for closed captioning and keywords. You can process one media file or multiple media files in a batch.
Does this meet the goal?
- A. Yes
- B. Not Mastered
Answer: A
NEW QUESTION 12
Match the types of workloads to the appropriate scenarios.
To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Solution:
Box 1: Batch
Batch processing refers to the processing of blocks of data that have already been stored over a period of time. Box 2: Streaming
Stream processing is a big data technology that allows us to process data in real-time as they arrive and detect conditions within a small period of time from the point of receiving the data. It allows us to feed data into analytics tools as soon as they get generated and get instant analytics results. Box 3: Batch
Does this meet the goal?
- A. Yes
- B. Not Mastered
Answer: A
NEW QUESTION 13
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
Answer: A
NEW QUESTION 14
Select the answer that correctly completes the sentence.
Solution:

Does this meet the goal?
- A. Yes
- B. Not Mastered
Answer: A
NEW QUESTION 15
Select the answer that correctly completes the sentence.
Solution:

Does this meet the goal?
- A. Yes
- B. Not Mastered
Answer: A
NEW QUESTION 16
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
Answer: A
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.
NEW QUESTION 17
......
100% Valid and Newest Version DP-900 Questions & Answers shared by Dumpscollection.com, Get Full Dumps HERE: https://www.dumpscollection.net/dumps/DP-900/ (New 306 Q&As)