Microsoft DP-900 Exam Practice Test Instant Access

Question 1

What is the responsibility of a database administrator?

Aapplying data cleaning routines

Bcreating data visualizations

Cmanaging data integration processes

Dstoring backup copies of data

Answer : C

Question 2

What is a characteristic of non-relational data?

Aa well-defined schema

Bno indexes

Cself-describing entities

Dno unique key values

Answer : D

Question 3

What is required to provision Azure Data Lake Storage in an Azure Storage account?

AVersioning must be enabled.

BHierarchical namespace must be enabled.

CHierarchical namespace must be disabled.

DVersioning must be disabled.

Answer : B

Question 4

Which type of Azure resource supports the serverless configuration of an Azure SQL database?

AAzure SQL Managed Instance

BSQL Server on Azure Virtual Machines

Ca single database in Azure SQL Database

Dan Azure SQL Database elastic pool

Answer : B

Question 5

What is used to define a query in a stream processing jobs in Azure Stream Analytics?

AXML

BKQL

CYAML

DSQL

Answer : D

Question 6

What should you use to automatically delete blobs from Azure Blob Storage?

Asoft delete

Barchive storage

Cthe change feed

Da lifecycle management policy

Answer : D

Question 7

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?

Aa waterfall chart

Ba ribbon chart

Ca bar chart

Da decomposition tree

Answer : A

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a

Microsoft DP-900 Microsoft Azure Data Fundamentals Exam Practice Test