DP-900 시험 - Microsoft실제시험문제와 답 - 66문항

Question No : 1

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

A.a linked service
B.an integration runtime
C.a control flow
D.a pipeline

정답:
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

Question No : 2

HOTSPOT
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

정답:

Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-across-workspaces
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboardshttps://powerbi.microsoft.com/en-us/excel-and-power-bi/

Question No : 3

Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. (Choose three.)

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

정답:
Explanation:
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

Question No : 4

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

정답:
Explanation:
OLTP is designed to serve as a persistent data store for business or front-end applications. OLTP administers day to day transaction of an organization.
Reference: https://sqlwizard.blog/2020/03/15/sql-server-oltp-vs-olap/

Question No : 5

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

정답:

Explanation:
Reference: https://docs.microsoft.com/en-us/azure/data-factory/frequently-asked-questions

Question No : 6

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

A.report and dashboard creation
B.report sharing and distribution
C.data modeling
D.data acquisition and preparation

정답:

Question No : 7

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. (Choose three.)

A.denormalized data
B.heavy writes and moderate reads
C.light writes and heavy reads
D.schema on write
E.schema on read
F.normalized data

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

Question No : 8

DRAG DROP
Match the types of activities to the appropriate Azure Data Factory activities.
To answer, drag the appropriate activity type from the column on the left to its Data Factory activity on the right. Each activity type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.

정답:

Explanation:
Reference: https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities#data-transformation-activities

Question No : 9

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

A.a control flow
B.a trigger
C.a parameter
D.an activity

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

Question No : 10

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

A.Scale down the data warehouse units (DWUs).
B.Pause the pool.
C.Create a user-defined restore point.
D.Delete the pool

정답:
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-managecompute-overview

Question No : 11

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

A.Online Transaction Processing (OLTP)
B.batch
C.massively parallel processing (MPP)
D.streaming

정답:
Explanation:
Reference: https://docs.microsoft.com/en-in/azure/azure-monitor/overview

Question No : 12

HOTSPOT
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.