Search Header Logo

DP 900 - pt 8

Authored by Katheryne Pierce

Computers

University

Used 6+ times

DP 900 - pt 8
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

24 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

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

2.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

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

3.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

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

control flow

trigger

parameter

activity

4.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

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)

5.

LABELLING QUESTION

3 mins • 1 pt

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

a
b
c

Data movement

Data transformation

Control

6.

MULTIPLE SELECT QUESTION

3 mins • 1 pt

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

7.

MULTIPLE SELECT QUESTION

3 mins • 1 pt

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

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?