[May 25, 2023] Pass DP-900 Review Guide, Reliable DP-900 Test Engine [Q155-Q169]

4/5 - (2 votes)

[May 25, 2023] Pass DP-900 Review Guide, Reliable DP-900 Test Engine

DP-900 Test Engine Practice Test Questions, Exam Dumps

NO.155 To complete the sentence, select the appropriate option in the answer area.

Explanation

Generally speaking, data analytics comes in four types (Figure 1):
Descriptive, to answer the question: What’s happening?
Diagnostic, to answer the question: Why’s happening?
Predictive, to answer the question: What will happen?
Prescriptive, to answer the question: What actions should we take?

NO.156 You have an application that runs on Windows and requires access to a mapped drive.
Which Azure service should you use?

Azure Files

Azure Blob storage

Azure Cosmos DB

Azure Table storage

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

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

NO.158 HOTSPOT
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Section: Describe how to work with non-relational data on Azure
Explanation/Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/high-availability

NO.159 To complete the sentence, select the appropriate option in the answer area.

Reference:
https://towardsdatascience.com/choosing-the-right-database-c45cd3a28f77

NO.160 To complete the sentence, select the appropriate option in the answer area.

NO.161 Select the answer that correctly completes the sentence.

Answer below as:

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

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

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

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/high-availability

NO.164 To complete the sentence, select the appropriate option in the answer area.

NO.165 To complete the sentence, select the appropriate option in the answer area.

Reference:
https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-namespace

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

Reference:
https://azure.microsoft.com/en-us/pricing/details/synapse-analytics/

NO.167 Which language is used to define queries in Azure Synapse Data Explorer?

Bash

PowerShell

KQL

SQL

NO.168 In Azure Table storage, each row in a table must be uniquely identified by which two components?
Each correct answer presents pan of the solution. NOTE: Each correct selection is worth one point.

a timestamp

a range

a row key

a partition key

NO.169 To complete the sentence, select the appropriate option in the answer area.