Free preview mode
Enjoy the free questions and consider upgrading to gain full access!
DP-900
Free trial
Verified
Question 51
DRAG DROP -
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.
Select and Place:
Question 52
What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution.
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
Question 53
Which two activities can be performed entirely by using the Microsoft Power BI service without relying on Power BI Desktop? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A: report and dashboard creation
- B: report sharing and distribution
- C: data modeling
- D: data acquisition and preparation
Question 54
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Question 55
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: a view
- B: a report
- C: a dataflow
- D: Microsoft Power Apps
Question 56
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:
Question 57
Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A: Azure Time Series Insights
- B: Azure HDInsight
- C: Azure Databricks
- D: Azure Log Analytics
Question 58
You have a quality assurance application that reads data from a data warehouse.
Which type of processing does the application use?
- A: Online Transaction Processing (OLTP)
- B: batch processing
- C: Online Analytical Processing (OLAP)
- D: stream processing
Question 59
Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A: a report page
- B: a Microsoft PowerPoint slide
- C: a visualization from a report
- D: a dataflow
- E: a text box
Question 60
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:
Question 61
Which Azure Data Factory component provides the compute environment for activities?
- A: SSIS packages
- B: an integration runtime
- C: a control flow
- D: a pipeline
That’s the end of your free questions
You’ve reached the preview limit for DP-900Consider upgrading to gain full access!
Free preview mode
Enjoy the free questions and consider upgrading to gain full access!