Microsoft DP-900 Exam Questions Instant Access

Question 1

What can you use to create data ingestion pipelines?

AAzure HDInsight

BAzure SQL Database

CAzure Data Factory

DAzure Cosmos DB

Answer : C

Question 2

What Is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

Anative support for cross-database queries and transactions

Bbuilt-in high availability

Csystem-Initiated automatic backups

Dsupport for encryption at rest

Answer : A

https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison

Question 3

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?

Aa waterfall chart

Ba ribbon chart

Ca bar chart

Da decomposition tree

Answer : A

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a

Question 4

Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a

complete solution. (Choose three.)

NOTE: Each correct selection is worth one point.

Aa report page

Ba Microsoft PowerPoint slide

Ca visualization from a report

Da dataflow

Ea text box

Answer : A, C, E

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboards

https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-add-widget

Question 5

What are two uses of data visualization? Each correct answer present a complete solution.

NOTE: Each correct selection is worth one point.

ARepresent trends and patterns over time.

BCommunicate the significance of data.

Cimplement machine learning to predict future values.

DConsistently implement business logic across reports

Answer : A, B

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.

https://docs.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-data-visualization

Question 6

Which clause should you use in a select statement to combine rows in one table with rows in another table?

AJOIN

BVALUES

Cset

DKEY

Answer : A

https://www.tutorialspoint.com/sql/sql-using-joins.htm

Question 7

You have a data store that has the structure shown in the following exhibit.

Which type of data store is this?

Aobject data

Bgraph

Ckey/value

Dtime series

Answer : B

Microsoft Azure Data Fundamentals DP-900 Exam Questions