DP 900 - pt 8

You need to gather real-time telemetry data from a mobile application. Which type of workload describes this scenario?

• Online Transaction Processing (OLTP)

• batch

• massively parallel processing (MPP)

• streaming

You have a dedicated SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours. You need to minimize the cost of the dedicated SQL pool as much as possible during idle times. The solution must ensure that the data remains intact. What should you do on the dedicated SQL pool?

• Scale down the data warehouse units (DWUs).

• Pause the pool.

• Create a user-defined restore point.

• Delete the pool

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

• control flow

• trigger

• parameter

• activity

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?

• stream processing

• batch processing

• Online Analytical Processing (OLAP)

• Online Transaction Processing (OLTP)

Match the types of activities to the appropriate Azure Data Factory activities

a

b

c

Control

Data transformation

Data movement

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution.

• denormalized data

• heavy writes and moderate reads

• schema on write

• normalized data

• light writes and heavy reads

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.

• report and dashboard creation

• . report sharing and distribution

• data modeling

• data acquisition and preparation

In Azure Data Factory, you can use ​ (a)   to orchestrate pipeline activities that depend on the output of other pipeline activities

• control flow
• dataset
• linked service
• integration runtime

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?

• view

• report

• dataflow

• Microsoft Power Apps

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.

• Azure Time Series Insights

• Azure HDInsight

• Azure Databricks

• Azure Log Analytics