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

Microsoft DP-900 - Microsoft Azure Data Fundamentals

Microsoft DP-900 Premium Access     Download Demo    
Page: 4 / 10
Total 332 questions

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

Which Azure Cosmos DB API stores data in the BSON format and uses MQL to query the data?

A.

MongoDB

B.

PostgreSQL

C.

Apache Gremlin

D.

Table

Select the answer that correctly completes the sentence.

Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?

A.

an Azure SQL Database elastic pool

B.

Azure SQL Managed Instance

C.

Azure Database for MySQL

D.

Azure SQL Database

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

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

You are reviewing the data model shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point

You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP).

Which Azure service should you use to support the application?

A.

Azure Cosmos DB

B.

Azure Synapse Analytics

C.

Azure HDInsight

D.

Azure SQL Database

What is the primary purpose of a data warehouse?

A.

to provide answers to complex queries that rely on data from multiple sources

B.

to provide transformation services between source and target data stores

C.

to provide read-only storage of relational and non-relational historical data

D.

to provide storage for transactional line-of-business (LOB) applications