microsoft dp-900 practice test

Microsoft Azure Data Fundamentals


Question 1 Topic 4, Describe an analytics workload on Azure

You need to create a visualization of running sales totals per quarter as shown in the following exhibit.

What should you create in Power BI Desktop?

  • A. a waterfall chart
  • B. a ribbon chart
  • C. a bar chart
  • D. a decomposition tree
Answer:

A

Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a

Discussions
0 / 600

Question 2 Topic 4, Describe an analytics workload on Azure

You need to perform hybrid transactional and analytical processing (HTAP) queries against Azure Cosmos DB data sources
by using Azure Synapse Analytics.
What should you use?

  • A. Synapse pipelines
  • B. a Synapse SQL pool
  • C. Synapse Link
  • D. Synapse Studio
Answer:

C

Explanation:
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/synapse-link

Discussions
0 / 600

Question 3 Topic 4, Describe an analytics workload on Azure

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

Answer:

Explanation:
Reference:
https://www.precisely.com/blog/big-data/big-data-101-batch-stream-processing

Discussions
0 / 600

Question 4 Topic 4, Describe an analytics workload on Azure

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

  • A. predictive
  • B. prescriptive
  • C. descriptive
  • D. diagnostic
Answer:

D

Discussions
0 / 600

Question 5 Topic 4, Describe an analytics workload on Azure

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

Answer:

Discussions
0 / 600

Question 6 Topic 4, Describe an analytics workload on Azure

HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

Answer:

Discussions
0 / 600

Question 7 Topic 4, Describe an analytics workload on Azure

Which scenario is an example of a streaming workload?

  • A. sending transactions that are older than a month to an archive
  • B. sending transactions daily from point of sale (POS) devices
  • C. sending telemetry data from edge devices
  • D. sending cloud infrastructure metadata every 30 minutes
Answer:

C

Discussions
0 / 600

Question 8 Topic 4, Describe an analytics workload on Azure

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

Answer:

Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/databricks/scenarios/what-is-azure-databricks https://docs.microsoft.com/en-
us/azure/analysis-services/analysis-services-overview https://docs.microsoft.com/en-us/azure/data-factory/introduction

Discussions
0 / 600

Question 9 Topic 4, Describe an analytics workload on Azure

DRAG DROP
Match the Azure services to the appropriate locations in the architecture.
To answer, 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.
Select and Place:

Answer:

Explanation:
Box 1: Azure Data factory
Relevant Azure service for the three ETL phases are Azure Data Factory and SQL Server Integration Services (SSIS).
Box 2: Azure Synapse Analytics
You can copy and transform data in Azure Synapse Analytics by using Azure Data Factory
Note: Azure Synapse Analytics connector is supported for the following activities:
Copy activity with supported source/sink matrix table

Mapping data flow

Lookup activity

GetMetadata activity

Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl https://docs.microsoft.com/en-
us/azure/data-factory/connector-azure-sql-data-warehouse

Discussions
0 / 600

Question 10 Topic 4, Describe an analytics workload on Azure

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

  • A. Charticulator
  • B. Power BI Desktop
  • C. the Power BI service
  • D. Power BI Report Builder
Answer:

D

Explanation:
Power BI Report Builder is the standalone tool for authoring paginated reports for the Power BI service.
Reference:
https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-bi

Discussions
0 / 600
To page 2