Microsoft DP-900 Exam Practice Test Instant Access

Question 1

Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts?

Aconsistency

Bdurability

Cisolation

Datomicity

Answer : B

Question 2

Which three services support Apache Spark? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.

AAzure Data Explorer

BAzure Synapse Analytics

CAzure Databricks

DAzure Stream Analytics

EAzure HDInsight

Answer : A, B, C

Question 3

Which statement is an example of Data Manipulation Language (DML)?

AREVOKE

BDISABLE

CCREATE

DUPDATE

Answer : D

Data Manipulation Language (DML) affect the information stored in the database. Use these statements to insert, update, and change the rows in the database.

BULK INSERT

DELETE

INSERT

SELECT

UPDATE

MERGE

https://docs.microsoft.com/en-us/sql/t-sql/statements/statements

Question 4

Your company recently reported sales from the third quarter.

You have the chart shown in the following exhibit.

Which type of analysis is shown for the fourth quarter?

Apredictive

Bprescription

Cdescriptive

Ddiagnostic

Answer : A

https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/

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

Question 5

Which three actions are used when performing diagnostic analytics?

A* Identify data anomalies
* Collect anomaly-related data
* Discover relationships and trends that explain anomalies.

B* Identify data anomalies
* Predict when anomalies are likely to recur
* Use analytical tools such as decision trees and regression.

C* Apply serf-learning loops to draw inferences from anomalies.
* Predict when anomalies are likely to recur
* Use analytical tools such as decision trees and regression.

D* Identify data anomalies
* Use machine learning to find patterns in large datasets.
* Discover relationships and trends that explain anomalies.

Answer : A

Question 6

Which two activities can be performed entirely by using the Microsoft Power BI service? Each correct answer presents a complete solution. (Choose two.)

NOTE: Each correct selection is worth one point.

Areport and dashboard creation

Breport sharing and distribution

Cdata modeling

Ddata acquisition and preparation

Answer : A, D

Question 7

You have a SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours.

You need to minimize the cost of the SQL pool during idle times. The solution must ensure that the data

remains intact.

What should you do on the SQL pool?

AScale down the data warehouse units (DWUs).

BPause the pool.

CCreate a user-defined restore point.

DDelete the pool

Answer : B

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-managecompute-overview

Microsoft Azure Data Fundamentals DP-900 Exam Practice Test