Free preview mode

Enjoy the free questions and consider upgrading to gain full access!

DP-900Free trialFree trial

By microsoft
Aug, 2025

Verified

25Q per page

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:

Image 1

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:

Image 1

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:

Image 1

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:

Image 1

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-900

Consider upgrading to gain full access!

Page 3 of 13 • Questions 51-75 of 303

Free preview mode

Enjoy the free questions and consider upgrading to gain full access!