Skip to Content

DP-900 Microsoft Azure Data Fundamentals Exam Questions and Answers – Page 1 Part 1

By: Author Alex Lim

Posted on  - Last updated:

Categories Exam, Microsoft

The latest Microsoft DP-900 Azure Data Fundamentals certification actual real practice exam question and answer (Q&A) dumps are available free, which are helpful for you to pass the Microsoft DP-900 Azure Data Fundamentals exam and earn Microsoft DP-900 Azure Data Fundamentals certification.

DP-900 Question 21

Exam Question

You need to use Transact-SQL to query files in Azure Data Lake Storage Gen 2 from an Azure Synapse Analytics data warehouse.

What should you use to query the files?

A. Azure Functions
B. Microsoft SQL Server Integration Services (SSIS)
C. PolyBase
D. Azure Data Factory

Correct Answer

C. PolyBase

Reference

Query data in Azure Synapse Analytics

DP-900 Question 22

Exam Question

What are two uses of data visualization?

A. Represent trends and patterns over time
B. Implement machine learning to predict future values
C. Communicate the significance of data
D. Enforce business logic across reports

Correct Answer

A. Represent trends and patterns over time
C. Communicate the significance of data

Explanation

Data visualization is a key component in being able to gain insight into your data. It helps make big and small data easier for humans to understand. It also makes it easier to detect patterns, trends, and outliers in groups of data.

Data visualization brings data to help you find key business insights quickly and effectively.

Reference

Microsoft Learn > Azure > Synapse Analytics > Visualize data

DP-900 Question 23

Exam Question

To complete the sentence, select the appropriate option in the answer area.

A Microsoft Power BI __________ enables users to create highly formatted, fixed-layout documents optimized for printing and archiving.

Answer Area:
A. dashboard
B. interactive report
C. paginated report
D. subscription

Correct Answer

C. paginated report

Explanation

Paginated Reports in Power BI now allows users to generate these fixed-layout documents optimized for printing and archiving, such as PDF and Word files.

These document-style reports with visualizations that provide additional control, like which tables expand horizontally and vertically to display all their data and continue from page to page as needed.

Reference

Announcing Paginated Reports in Power BI general availability

DP-900 Question 24

Exam Question

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

Correct Answer

B. an integration runtime

Explanation

The Integration Runtime (IR) is the compute infrastructure used by Azure Data Factory to provide the following data integration capabilities across different network environments:

  • Data Flow
  • Data movement
  • Activity dispatch
  • SSIS package execution

Reference

Microsoft Learn > Azure > Data Factory > Integration runtime in Azure Data Factory

DP-900 Question 25

Exam Question

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Statement 1: A Microsoft Power BI dashboard is associated with a single workspace.
Statement 2: A Microsoft Power BI dashboard can only display visualizations from a single dataset.
Statement 3: A Microsoft Power BI dashboard can display visualizations from a Microsoft Excel workbook.

Correct Answer

Statement 1: A Microsoft Power BI dashboard is associated with a single workspace: No
Statement 2: A Microsoft Power BI dashboard can only display visualizations from a single dataset: No
Statement 3: A Microsoft Power BI dashboard can display visualizations from a Microsoft Excel workbook: Yes

Reference

DP-900 Question 26

Exam Question

Which three objects can be added to a Microsoft Power BI dashboard?

A. a report page
B. a Microsoft PowerPoint slide
C. a visualization from a report
D. a dataflow
E. a text box

Correct Answer

A. a report page
C. a visualization from a report
E. a text box

Reference

DP-900 Question 27

Exam Question

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

Correct Answer

A. Online Transaction Processing (OLTP)

Reference

Microsoft Learn > Azure > Architecture > Data Architecture Guide > Online transaction processing (OLTP)

DP-900 Question 28

Exam Question

Which two Azure services can be used to provision Apache Spark clusters?

A. Azure Time Series Insights
B. Azure HDInsight
C. Azure Databricks
D. Azure Log Analytics

Correct Answer

B. Azure HDInsight
C. Azure Databricks

DP-900 Question 29

Exam Question

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 dashboard
B. a report
C. a dataflow
D. Microsoft Power Apps

Correct Answer

B. a report

Explanation

DP-900 Question 30

Exam Question

To complete the sentence, select the appropriate option in the answer area.

In Azure Data Factory, you can use __________ to orchestrate pipeline activities that depend on the output of other pipeline activities.

Answer Area:
A. a control flow
B. a dataset
C. a linked service
D. an integration runtime

Correct Answer

A. a control flow

Reference

Microsoft Learn > Azure > Data Factory > Azure Data Factory FAQ