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: 8 / 10
Total 316 questions

A team of developers has computers Thai run Windows 10 and Ubuntu Desktop.

The developers need to connect to and query an Azure SQL database from the computers. The developers require code assistance features such as intellSense.

What should the developers use ?

A.

Azure Data Studio

B.

sq1cmd

C.

Microsoft SQL Server Management Studio (SSMS)

D.

Azure Data Explorer

Your company is designing a data store that will contain student data. The data has the following format.

Which type of data store should you use?

A.

graph

B.

key/value

C.

object

D.

columnar

Select the answer that correctly completes the sentence.

A data engineer is responsible for which task?

A.

Design and build analytical models.

B.

Design and implement data stores for analytical workloads.

C.

Explore data to identify trends.

D.

Implement policies, tools. and processes for backup and recovery plans.

Match the Azure Cosmos DB APIs to the appropriate data structures.

To answer, drag the appropriate API from the column on the left to its data structure on the right. Each API may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

Select the answer that correctly completes the sentence.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Match the ACID terms to the Appropriate descriptions.

To answer, drag the appropriate term from the column on the left to its description on the right Each term may be used once, more than once, or not at aft.

NOTE: Each correct match is worth one point.

Match the Azure services to the appropriate locations in the architecture.

To an swer, 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.

Which database transaction property ensures that individual transactions are executed only once and either succeed in their entirety or roll back?

A.

isolation

B.

durability

C.

atomicity

D.

consistency