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

Microsoft DP-900 - Microsoft Azure Data Fundamentals

Page: 3 / 10
Total 313 questions

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. (Choose three.)

NOTE: Each correct selection is worth one point.

A.

denormalized data

B.

schema defined when reading unstructured data from a database

C.

light writes and heavy reads

D.

normalized data

E.

schema defined in a database

F.

heavy writes and moderate reads

You need to design and model a database by using a graphical tool that supports project-oriented offline

database development.

What should you use?

A.

Microsoft SQL Server Data Tools (SSDT)

B.

Microsoft SQL Server Management Studio (SSMS)

C.

Azure Databricks

D.

Azure Data Studio

Select the answer that correctly completes the sentence.

Match the Azure services to the appropriate requirements.

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

NOTE: Each correct match is worth one point.

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).

Select the answer that correctly completes the sentence.

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

Which type of database contains nodes and edges?

A.

graph

B.

columnar

C.

key/value

D.

time series

Match the processes to the appropriate scenarios.

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

NOTE: Each correct match is worth one point.

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

NOTE: Each correct selection is worth one point.