[Sep-2023] Pass Microsoft DP-900 Exam in First Attempt Guaranteed! [Q60-Q81]

4/5 - (3 votes)

[Sep-2023] Pass Microsoft DP-900 Exam in First Attempt Guaranteed!

Full DP-900 Practice Test and 260 unique questions with explanations waiting just for you, get it now!

NO.60 Which two Azure services can be used to provision Spark clusters? Each correct answer presents a complete
solution.
NOTE: Each correct selection is worth one point.

Azure Databricks

Azure Log Analytics

Azure Time Series Insights

Azure HDinsight

NO.61 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.

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

Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described?view=sql-server-ver15

NO.63 You have the following SQL query.

NOTE: Each correct selection is worth one point.

NO.64 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.65 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.

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

NO.66 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/azure-sql/database/sql-database-paas-overview

NO.67 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: 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.

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

Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described?view=sql-server-ver15

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

NO.70 Which storage solution supports access control lists (ACLs) at the file and folder level?

Azure Data Lake Storage

Azure Cosmos DB

Azure Queue storage

Azure Blob storage

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).

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

NO.72 Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?

WHERE

SELECT

JOIN

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

Answer below as:

NO.74 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
Compute is separate from storage, which enables you to scale compute independently of the data in your system.
Box 2: Yes
You can use the Azure portal to pause and resume the dedicated SQL pool compute resources.
Pausing the data warehouse pauses compute. If your data warehouse was paused for the entire hour, you will not be charged compute during that hour.
Box 3: No
Storage is sold in 1 TB allocations. If you grow beyond 1 TB of storage, your storage account will automatically grow to 2 TBs.

NO.75 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.76 Select the answer that correctly completes the sentence.

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

Reference:
https://www.bmc.com/blogs/what-is-batch-processing-batch-processing-explained/

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

Reference:
https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/

NO.79 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/power-bi/connect-data/service-datasets-across-workspaces
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboardshttps://powerbi.microsoft.com/en-us/excel-and-power-bi/

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

NO.81 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?

document

columnar

graph

time series

Loading …

Get Latest DP-900 Dumps Exam Questions in here: https://www.dumpleader.com/DP-900_exam.html

Leave a Reply Cancel reply