Pre-Summer Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmas50

Microsoft DP-900 - Microsoft Azure Data Fundamentals

Page: 1 / 10
Total 316 questions

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

You need to analyze data by using Azure Databricks.

Which are two ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

A.

Create a Microsoft Power Bl report.

B.

Create an Azure Data Factory pipeline.

C.

Use an Apache Spark job to process data stored in an Azure Cosmos DB database.

D.

Create a data flow in Azure Data Factory.

E.

Create an Apache Spark job that will run in a Spark cluster.

Select the answer that correctly completes the sentence.

Y ou need to perform hybrid transactional and analytical processing (HTAP) queries against Azure Cosmos DB data sources by using Azure Synapse Analytics.

What should you use?

A.

Synapse pipelines

B.

a Synapse SQL pool

C.

Synapse Link

D.

Synapse Studio

You have a transactional application that stem data in an Azure SQL managed instance. When should you implement a read-only database replica?

A.

You need to generate reports without affecting the transactional workload.

B.

You need to audit the transactional application.

C.

You need to implement high availability in the event of a regional outage

D.

You need to improve the recovery point objective (RPO).

You have structured data in tabular format.

What represents an individual instance of a data entity?

A.

a column

B.

a cell

C.

a row

D.

a table

Which file format has defined names and data types for each column and uses compressed columnar storage?

A.

JSON

B.

CSV

C.

Apache Parquet

D.

HTML

Select the answer the correctly completes the sentence.

At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A.

container

B.

item

C.

database

D.

partition

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

A.

Bash

B.

PowerShell

C.

KQL

D.

SQL