microsoft dp-900 practice test
Microsoft Azure Data Fundamentals
Last exam update: Nov 30 ,2023
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
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
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
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
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:
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:
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
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
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
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
Question 11 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:
Box 1: Yes
Compute is separate from storage, which enables you to scale compute independently of the data in your system.
Box 2: Yes
You can use the Azure portal to pause and resume the dedicated SQL pool compute resources.
Pausing the data warehouse pauses compute. If your data warehouse was paused for the entire hour, you will not be
charged compute during that hour.
Box 3: No
Storage is sold in 1 TB allocations. If you grow beyond 1 TB of storage, your storage account will automatically grow to 2
TBs.
Reference:
https://azure.microsoft.com/en-us/pricing/details/synapse-analytics/
Question 12 Topic 4, Describe an analytics workload on Azure
DRAG DROP
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.
Select and Place:
Answer:
Explanation:
Box 1: Azure Data Factory
Box 2: Azure Data Lake Storage
Azure Data Lake Storage (ADLA) now natively supports Parquet files. ADLA adds a public preview of the native extractor
and outputter for the popular Parquet file format
Box 3: Azure Synapse Analytics
Use Azure Synapse Analytics Workspaces.
Reference:
https://docs.microsoft.com/en-us/azure/data-factory/supported-file-formats-and-compression-codecs
Question 13 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:
Box 1: No
A pipeline is a logical grouping of activities that together perform a task.
Box 2: Yes
You can construct pipeline hierarchies with data factory.
Box 3: Yes
A pipeline is a logical grouping of activities that together perform a task.
Reference: https://mrpaulandrew.com/2019/09/25/azure-data-factory-pipeline-hierarchies-generation-control/
Question 14 Topic 4, Describe an analytics workload on Azure
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Answer:
Explanation:
Note: The data warehouse workload encompasses: The entire process of loading data into the warehouse
Performing data warehouse analysis and reporting
Managing data in the data warehouse
Exporting data from the data warehouse
Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-
management
Question 15 Topic 4, Describe an analytics workload on Azure
DRAG DROP
Match the types of workloads to the appropriate scenarios.
To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type
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: Batch
The batch processing model requires a set of data that is collected over time while the stream processing model requires
data to be fed into an analytics tool, often in micro-batches, and in real-time.
The batch Processing model handles a large batch of data while the Stream processing model handles individual records or
micro-batches of few records. In Batch Processing, it processes over all or most of the data but in Stream Processing, it
processes over data on a rolling window or most recent record.
Box 2: Batch
Box 3: Streaming Reference:
https://k21academy.com/microsoft-azure/dp-200/batch-processing-vs-stream-processing