[Aug 03, 2022] Today Updated DP-900 Exam Dumps Actual Questions [Q50-Q75]

[Aug 03, 2022] Today Updated DP-900 Exam Dumps Actual Questions

DP-900 exam dumps with real Microsoft questions and answers

Skills measured

Describe how to work with non-relational data on Azure (25-30%)
The content of this exam was updated on April 23, 2021. Please download the exam skills outline below to see what changed.
Describe core data concepts (15-20%)
Describe how to work with relational data on Azure (25-30%)
Describe an analytics workload on Azure (25-30%)

NEW QUESTION 50
To complete the sentence, select the appropriate option in the answer area.

Answer:

Explanation:

Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

NEW QUESTION 51
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Reference:
https://azure.microsoft.com/en-gb/blog/hot-patching-sql-server-engine-in-azure-sql-database/
https://azure.microsoft.com/en-us/services/sql-database/#product-overview

NEW QUESTION 52
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

NEW QUESTION 53
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Explanation

Box 1: Yes
Big data solutions often use long-running batch jobs to filter, aggregate, and otherwise prepare the data for analysis. Usually these jobs involve reading source files from scalable storage (like HDFS, Azure Data Lake Store, and Azure Storage), processing them, and writing the output to new files in scalable storage.
Box 2: No
Box 3: No

NEW QUESTION 54
What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. access to the latest features
B. in-database machine learning services
C. reduced administrative effort for managing the server infrastructure
D. complete control over backup and restore processes

Answer: A,C

Explanation:
Section: Describe how to work with relational data on Azure
Explanation:
A: Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement.
D: SQL Database delivers predictable performance with multiple resource types, service tiers, and compute sizes. It provides dynamic scalability with no downtime, built-in intelligent optimization, global scalability and availability, and advanced security options. These capabilities allow you to focus on rapid app development and accelerating your time-to-market, rather than on managing virtual machines and infrastructure.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview

NEW QUESTION 55
Select the answer that correctly completes the sentence.

Answer:

Explanation:
Explanation
Graphical user interface, text, application, email Description automatically generated

A treemap chart divides the chart area into rectangles that represent the different levels and relative sizes of the data hierarchy.

NEW QUESTION 56
Select the answer that correctly completes the sentence.

Answer:

Explanation:

Reference:
https://docs.microsoft.com/en-us/sql/reporting-services/report-design/tree-map-and-sunburst-charts-in-reporting-services?view=sql-server-ver15

NEW QUESTION 57
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Explanation

Box 1: 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.
Box 2: 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.
Box 3: No
Logical partitions are formed based on the value of a partition key that is associated with each item in a container.

NEW QUESTION 58
To complete the sentence, select the appropriate option in the answer area.

Answer:

Explanation:

Explanation

Disadvantages of non-relational databases include: Data Consistency - non-relational databases do not perform ACID transactions.
Note: Relational databases are optimized for writes. They are optimized for consistency and availability.
Advantages of relational databases include simplicity, ease of data retrieval, data integrity, and flexibility.

NEW QUESTION 59
For each of the following statements, select yes if he statement is true, Otherwise select No.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

NEW QUESTION 60
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Reference:
https://docs.microsoft.com/en-us/azure/data-lake-store/data-lake-store-get-started-portal
https://docs.microsoft.com/en-us/azure/storage/common/storage-account-overview
https://azure.microsoft.com/en-us/pricing/details/bandwidth/

NEW QUESTION 61
For each of the following statements. select Yes if the statement is true. Otherwise, select No. NOTE Each correct selection is worth one point.

Answer:

Explanation:

NEW QUESTION 62
To complete the sentence, select the appropriate option in the answer area.

Answer:

Explanation:

Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/massively-parallel-processing-mpp-architecture

NEW QUESTION 63
To complete the sentence, select the appropriate option in the answer area.

Answer:

Explanation:

NEW QUESTION 64
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 Cosmos DB
C. Azure Table storage
D. Azure Blob storage

Answer: A

Explanation:
Section: Describe how to work with non-relational data on Azure
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:
https://docs.microsoft.com/en-us/azure/storage/files/storage-how-to-use-files-windows

NEW QUESTION 65
To complete the sentence, select the appropriate option in the answer area.

Answer:

Explanation:

NEW QUESTION 66
Match the Azure Data Lake Storage terms to the appropriate levels in the hierarchy.
To answer, drag the appropriate term from the column on the left to its level on the right. Each term may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

Answer:

Explanation:

Reference:
https://docs.microsoft.com/en-us/azure/storage/files/storage-how-to-create-file-share

NEW QUESTION 67
For each of the following statements, select yes if he statement is true, Otherwise select No.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

NEW QUESTION 68
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/partitioning-overview

NEW QUESTION 69
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/batch-processing

NEW QUESTION 70
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

NEW QUESTION 71
What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. (Choose three.) NOTE: Each correct selection is worth one point.

A. light writes and heavy reads
B. heavy writes and moderate reads
C. schema on read
D. denormalized data
E. schema on write
F. normalized data

Answer: B,C,E

Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction-processing

NEW QUESTION 72
Match the tools to the appropriate descriptions.
To answer, drag the appropriate tool from the column on the left to its description on the right. Each tool may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

Answer:

Explanation:

NEW QUESTION 73
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.