DP-900 Exam Dumps - Microsoft Certified: Azure Data Fundamentals Questions and Answers

Question # 24

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 ?

Options:

Azure Data Studio

sq1cmd

Microsoft SQL Server Management Studio (SSMS)

Azure Data Explorer

Buy Now

Question # 25

Which three actions are used when performing diagnostic analytics?

Options:

• Identify data anomalies

• Collect anomaly-related data

• Discover relationships and trends that explain anomalies.

• Identify data anomalies

• Predict when anomalies are likely to recur

• Use analytical tools such as decision trees and regression.

• Apply serf-learning lo ops to draw inferences from anomalies.

• Predict when anomalies are likely to recur

• Use analytical tools such as decision trees and regression.

• Identify data anomalies

• Use machine learning to find patterns in large datasets.

• Discover relationships and trends that explain anomalies.

Buy Now

Question # 26

Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?

Options:

isolation

durability

consistency

atomicity

Buy Now

Question # 27

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

NOTE: Each correct selection is worth one point.

Options:

Buy Now

Question # 28

Match the 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 all.

NOTE: Each correct match is worth one point.