Summer Sale Limited Time 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple75

Pass the Microsoft Certified: Azure Data Fundamentals DP-900 Questions and answers with Dumpstech

Exam DP-900 Premium Access

View all detail and faqs for the DP-900 exam

Practice at least 50% of the questions to maximize your chances of passing.
Viewing page 2 out of 10 pages
Viewing questions 11-20 out of questions
Questions # 11:

You have data saved in the following format.

Question # 11

Which format was used?

Options:

A.

HTML

B.

CSV

C.

JSON

D.

YAML

Questions # 12:

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

Question # 12

Options:

Questions # 13:

Match the data processing languages to the appropriate real-time analytics services.

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

NOTE: Each correct match is worth one point.

Question # 13

Options:

Questions # 14:

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

Options:

A.

JSON

B.

CSV

C.

Apache Parquet

D.

HTML

Questions # 15:

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.

Question # 15

Options:

Questions # 16:

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

Question # 16

Options:

Questions # 17:

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

Note: Each correct selection is worth one point.

Question # 17

Options:

Questions # 18:

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Options:

A.

complete control over backup and restore processes

B.

access to the latest features

C.

in-database machine learning services

D.

reduced administrative effort for managing the server infrastructure

Questions # 19:

Which three actions are used when performing diagnostic analytics?

Options:

A.

• Identify data anomalies

• Collect anomaly-related data

• Discover relationships and trends that explain anomalies.

B.

• Identify data anomalies

• Predict when anomalies are likely to recur

• Use analytical tools such as decision trees and regression.

C.

• Apply serf-learning loops to draw inferences from anomalies.

• Predict when anomalies are likely to recur

• Use analytical tools such as decision trees and regression.

D.

• Identify data anomalies

• Use machine learning to find patterns in large datasets.

• Discover relationships and trends that explain anomalies.

Questions # 20:

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

Options:

A.

an Azure SQL Database elastic pool

B.

Azure SQL Managed Instance

C.

Azure Database for MySQL

D.

Azure SQL Database

Viewing page 2 out of 10 pages
Viewing questions 11-20 out of questions