ExamGecko
Home / Microsoft / DP-900 / List of questions
Ask Question

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

List of questions

Question 171

Report
Export
Collapse

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

a control flow
a control flow
a trigger
a trigger
a parameter
a parameter
an activity
an activity
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

asked 02/10/2024
Michael Marzotto
36 questions

Question 172

Report
Export
Collapse

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

Explanation:

Section: Describe an analytics workload on Azure

Reference:

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

asked 02/10/2024
stefano atzei
33 questions

Question 173

Report
Export
Collapse

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.

denormalized data
denormalized data
heavy writes and moderate reads
heavy writes and moderate reads
light writes and heavy reads
light writes and heavy reads
schema on write
schema on write
schema on read
schema on read
normalized data
normalized data
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

asked 02/10/2024
Muhammad Gul
41 questions

Question 174

Report
Export
Collapse

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.

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

Explanation:

Section: Describe an analytics workload on Azure

asked 02/10/2024
None None
40 questions

Question 175

Report
Export
Collapse

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 dashboard
a dashboard
a report
a report
a dataflow
a dataflow
Microsoft Power Apps
Microsoft Power Apps
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

asked 02/10/2024
Jumar Antonia
34 questions

Question 176

Report
Export
Collapse

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.

Azure Time Series Insights
Azure Time Series Insights
Azure HDInsight
Azure HDInsight
Azure Databricks
Azure Databricks
Azure Log Analytics
Azure Log Analytics
Suggested answer: B, C

Explanation:

Section: Describe an analytics workload on Azure

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

asked 02/10/2024
Christian Andrew TANAP
41 questions

Question 177

Report
Export
Collapse

You have a quality assurance application that reads data from a data warehouse.

Which type of processing does the application use?

Online Transaction Processing (OLTP)
Online Transaction Processing (OLTP)
batch processing
batch processing
Online Analytical Processing (OLAP)
Online Analytical Processing (OLAP)
stream processing
stream processing
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

asked 02/10/2024
Arnab Gupta
39 questions

Question 178

Report
Export
Collapse

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 report page
a report page
a Microsoft PowerPoint slide
a Microsoft PowerPoint slide
a visualization from a report
a visualization from a report
a dataflow
a dataflow
a text box
a text box
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

asked 02/10/2024
Piotr Jakubowski
41 questions

Question 179

Report
Export
Collapse

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

a linked service
a linked service
an integration runtime
an integration runtime
a control flow
a control flow
a pipeline
a pipeline
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

asked 02/10/2024
Marco Santoro
31 questions

Question 180

Report
Export
Collapse

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?

Azure Functions
Azure Functions
Microsoft SQL Server Integration Services (SSIS)
Microsoft SQL Server Integration Services (SSIS)
PolyBase
PolyBase
Azure Data Factory
Azure Data Factory
Suggested answer: C

Explanation:

Section: Describe an analytics workload on Azure

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

asked 02/10/2024
Mohammad Musa
39 questions
Total 285 questions
Go to page: of 29
Search

Related questions