Free DP-900 Exam Practice Questions
Practice for DP-900: Microsoft Azure Data Fundamentals exam - disclaimer
-
Exam Code: DP-900
Exam Title: Microsoft Azure Data Fundamentals - Exam Provider: Microsoft
- Total Exam Questions: 123
- Last Updated On: 27 May 2024
Exercise : Exam DP 900 Microsoft Azure Data Fundamentals MCQ Questions and Answers
Question 1
You need to develop a solution to provide data to executives. The solution must provide an interactive graphical interface, depict
various key performance indicators, and support data exploration by using drill down.
What should you use in Microsoft Power BI?
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. a report
Description :
Reference:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboards https://docs.microsoft.com/en-us/powerbi/
visuals/power-bi-visualization-kpi https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill
View Answer
50/50
Workspace
Report
Discuss
Question 2
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. enable the hierarchical namespace.
Description :
Reference:
https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-namespace
Question 3
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:
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. Azure Data Factory, Azure Synapse Analytics
Description :
Box Ingest: Azure Data Factory -
You can build a data ingestion pipeline with Azure Data Factory (ADF).
Box Preprocess & model: Azure Synapse Analytics
Use Azure Synapse Analytics to preprocess data and deploy machine learning models.
Reference:
https://docs.microsoft.com/en-us/azure/machine-learning/how-to-data-ingest-adf
https://docs.microsoft.com/en-us/azure/machinelearning/team-data-science-process/sqldw-walkthrough
Question 4
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. |
| B. |
| C. |
| D. |
Correct Answer : A. Online Analytical Processing (OLAP)
Description :
Reference:
https://datawarehouseinfo.com/how-does-oltp-differ-from-olap-database/
Question 5
DRAG DROP -
Match the types of visualizations to the appropriate descriptions.
To answer, drag the appropriate visualization type from the column on the left to its description on the right. Each visualization type
may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. Tree map, Key influencer, Scatter
Description :
Answer:
Box 1: Tree map -
Treemaps are charts of colored rectangles, with size representing value. They can be hierarchical, with rectangles nested within the
main rectangles.
Box 2: Key influencer -
A key influencer chart displays the major contributors to a selected result or value.
Box 3: Scatter -
Scatter and Bubble charts display relationships between 2 (scatter) or 3 (bubble) quantitative measures -- whether or not, in which
order, etc.
Question 6
You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing
(OLTP).
Which Azure service should you use to support the application?
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. Azure SQL Database
Description :
Azure SQL Database is relational database and a managed service.
A, B: Cosmos DB, HDInsight are non-relational databases.
D: Azure Synapse Analytics is for data warehousing, not for Online Transaction Processing
Reference:
https://cloud.netapp.com/blog/azure-cvo-blg-azure-database-review-your-guide-for-database-assessment
Question 7
Which scenario is an example of a streaming workload?
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. sending telemetry data from edge devices
Description :
No answer description available for this question. Let us discuss.
Question 8
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:
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. No, No, Yes
Description :
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-across-workspaces
https://docs.microsoft.com/enus/power-bi/consumer/end-user-dashboards
https://powerbi.microsoft.com/en-us/excel-and-power-bi/
Question 9
What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents
a complete solution. (Choose three.)
NOTE: Each correct selection is worth one point.
A. denormalized data
B. heavy writes and moderate reads
C. light writes and heavy reads
D. schema on write
E. schema on read
F. normalized data
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. DBE
Description :
No answer description available for this question. Let us discuss.
Question 10
Match the types of activities to the appropriate Azure Data Factory activities.
To answer, drag the appropriate activity type from the column on the left to its Data Factory
activity on the right. Each activity type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. Data movement, Data transformation, Control
Description :
