Exit demo DP-900 Microsoft Azure Data Fundamentals PDF format · free preview

Microsoft DP-900 - Questions & Answers

Free preview · every answer includes a full explanation

Product page: https://prepkeys.com/dp-900.html

Question 1
Single choice

A bar chart showing year-to date sales by region is an example of which type of analytics?

A.

descriptive

B.

diagnostic

C.

predictive

D.

prescriptive

Question 2
Single choice

Your company recently reported sales from the third quarter.

You have the chart shown in the following exhibit.

Which type of analysis is shown for the fourth quarter?

A.

predictive

B.

prescription

C.

descriptive

D.

diagnostic

Question 3
Multiple choice

What are two uses of data visualization? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A.

Represent trends and patterns over time.

B.

Communicate the significance of data.

C.

implement machine learning to predict future values.

D.

Consistently implement business logic across reports

Question 4
Single choice

You have an e-commerce application that reads and writes data to an Azure SQL database.

Which type of processing does the application use?

A.

stream processing

B.

batch processing

C.

Online Analytical Processing (OLTP)

D.

Online Transaction Processing (OLTP)

Question 5
Multiple choice

What are two characteristics of real-time data processing? Each correct answer present a complete solution.
NOTE: Each correct selection is worth one point.

A.

Data is processed as it is created.

B.

Low latency is expected

C.

High latency acceptable

D.

Data is processed periodically

Question 6
Multiple choice

Which two Azure services can be used to provision Spark clusters? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A.

Azure Databricks

B.

Azure Log Analytics

C.

Azure Time Series Insights

D.

Azure HDinsight

Question 7
Single choice

You need to develop a solution to provide data to executives. the solution must provide an interactive graphic interface, depict various key performance indications, and support data exploration by using drill down.

What should you use in Microsoft Power BI?

A.

a dashboard

B.

Microsoft Power Apps

C.

a dataflow

D.

a report

Question 8
Single choice

What should you use to build a Microsoft Power BI paginated report?

A.

Power BI report Builder

B.

Power BI Desktop

C.

Charticulator

D.

the Power BI service

Question 9
Single choice

Your company has a reporting solution that has paginated reports. The reports query a dimensional model in a data warehouse.

Which type of processing does the reporting solution use?

A.

stream processing

B.

Online Transaction Processing (OLTP)

C.

batch processing

D.

Online Analytical Processing (OLAP)

Question 10
Single choice

Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?

A.

Azure Queue storage

B.

Azure Data Lake Storage

C.

Azure table storage

D.

Azure Files

Showing 10 of 334 questions · Unlock the full set