ExamGecko
Home Home / Microsoft / DP-900

Microsoft DP-900 Practice Test - Questions Answers, Page 18

Question list
Search
Search

List of questions

Search

Related questions











Which Azure Data Factory component initiates the execution of a pipeline?

A.
a control flow
A.
a control flow
Answers
B.
a trigger
B.
a trigger
Answers
C.
a parameter
C.
a parameter
Answers
D.
an activity
D.
an activity
Answers
Suggested answer: B

Explanation:

Section: Describe an analytics workload on Azure

Reference: https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipeline-execution-triggers#trigger-execution

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.
stream processing
A.
stream processing
Answers
B.
batch processing
B.
batch processing
Answers
C.
Online Analytical Processing (OLAP)
C.
Online Analytical Processing (OLAP)
Answers
D.
Online Transaction Processing (OLTP)
D.
Online Transaction Processing (OLTP)
Answers
Suggested answer: C

Explanation:

Section: Describe an analytics workload on Azure

Reference:

https://datawarehouseinfo.com/how-does-oltp-differ-from-olap-database/

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
A.
denormalized data
Answers
B.
heavy writes and moderate reads
B.
heavy writes and moderate reads
Answers
C.
light writes and heavy reads
C.
light writes and heavy reads
Answers
D.
schema on write
D.
schema on write
Answers
E.
schema on read
E.
schema on read
Answers
F.
normalized data
F.
normalized data
Answers
Suggested answer: B, D, F

Explanation:

B: Transactional data tends to be heavy writes, moderate reads.

D: Typical traits of transactional data include: schema on write, strongly enforced

F: Transactional data tends to be highly normalized.

Reference:

https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction-processing

Which two activities can be performed entirely by using the Microsoft Power BI service? Each correct answer presents a complete solution. (Choose two.) NOTE: Each correct selection is worth one point.

A.
report and dashboard creation
A.
report and dashboard creation
Answers
B.
report sharing and distribution
B.
report sharing and distribution
Answers
C.
data modeling
C.
data modeling
Answers
D.
data acquisition and preparation
D.
data acquisition and preparation
Answers
Suggested answer: A, D

Explanation:

Section: Describe an analytics workload on Azure

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
A.
a dashboard
Answers
B.
a report
B.
a report
Answers
C.
a dataflow
C.
a dataflow
Answers
D.
Microsoft Power Apps
D.
Microsoft Power Apps
Answers
Suggested answer: B

Explanation:

Section: Describe an analytics workload on Azure

Reference: https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboards https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill

Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a complete solution. (Choose two.)

NOTE: Each correct selection is worth one point.

A.
Azure Time Series Insights
A.
Azure Time Series Insights
Answers
B.
Azure HDInsight
B.
Azure HDInsight
Answers
C.
Azure Databricks
C.
Azure Databricks
Answers
D.
Azure Log Analytics
D.
Azure Log Analytics
Answers
Suggested answer: B, C

Explanation:

Section: Describe an analytics workload on Azure

Reference: https://www.sqlshack.com/a-beginners-guide-to-azure-databricks/

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)
A.
Online Transaction Processing (OLTP)
Answers
B.
batch processing
B.
batch processing
Answers
C.
Online Analytical Processing (OLAP)
C.
Online Analytical Processing (OLAP)
Answers
D.
stream processing
D.
stream processing
Answers
Suggested answer: A

Explanation:

Section: Describe an analytics workload on Azure

Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction-processing

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.

A.
a report page
A.
a report page
Answers
B.
a Microsoft PowerPoint slide
B.
a Microsoft PowerPoint slide
Answers
C.
a visualization from a report
C.
a visualization from a report
Answers
D.
a dataflow
D.
a dataflow
Answers
E.
a text box
E.
a text box
Answers
Suggested answer: A, C, E

Explanation:

Section: Describe an analytics workload on Azure

Reference: 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

Which Azure Data Factory component provides the compute environment for activities?

A.
a linked service
A.
a linked service
Answers
B.
an integration runtime
B.
an integration runtime
Answers
C.
a control flow
C.
a control flow
Answers
D.
a pipeline
D.
a pipeline
Answers
Suggested answer: B

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:

https://docs.microsoft.com/en-us/azure/data-factory/concepts-integration-runtime

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

What should you use to query the files?

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

Explanation:

Section: Describe an analytics workload on Azure

Reference: https://docs.databricks.com/data/data-sources/azure/synapse-analytics.html

Total 285 questions
Go to page: of 29