ExamGecko
Login
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
Open VPLUS File
Convert VPLUS to PDF

Related questions

You have an application that runs on Windows and requires access to a mapped drive. Which Azure service should you use?
DRAG DROP Match the data processing languages to the appropriate real-time analytics services. To answer, drag the appropriate language from the column on the left to its service on the right. Each language may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
DRAG DROP Match the Azure SQL services to the appropriate use cases. To answer, drag the appropriate service from the column on the left to its use case on the right. Each service may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
DRAG DROP Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process. Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.
DRAG DROP You have a table named Sales that contains the following data. You need to query the table to return the average sales amount per day. The output must produce the following results. How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.
Your company recently reported sales from the third quarter. You have the chart shown in the following exhibit. Which type of analysis is shown in the fourth quarter?
DRAG DROP Match the database normalization terms to the appropriate descriptions. To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
DRAG DROP Match the Azure Data Lake Storage terms to the appropriate levels in the hierarchy. To answer, drag the appropriate term from the column on the left to its level on the right. Each term may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
HOTSPOT Select the answer that correctly completes the sentence.
You have a banking application that transfers money in to and out of accounts. Of which type of solution is this is an example?