DP-900 試験問題と解答 - 模擬練習 - 練習問題・模擬試験

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.

正解:

Question No : 13
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.

正解:

Question No : 14
Which scenario is an example of a streaming workload?

A.sending transactions that are older than a month to an archive
B.sending transactions daily from point of sale (POS) devices
C.sending telemetry data from edge devices
D.sending cloud infrastructure metadata every 30 minutes

正解:

Question No : 15
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.

正解:

Explanation:
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/create-graph-gremlin-console

Microsoft DP-900 問題練習