Microsoft DP-900 Practice Test - Questions Answers, Page 18
List of questions
Question 171
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Which Azure Data Factory component initiates the execution of a pipeline?
Explanation:
Section: Describe an analytics workload on Azure
Reference: https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipeline-execution-triggers#trigger-execution
Question 172
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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?
Explanation:
Section: Describe an analytics workload on Azure
Reference:
https://datawarehouseinfo.com/how-does-oltp-differ-from-olap-database/
Question 173
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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.
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
Question 174
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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.
Explanation:
Section: Describe an analytics workload on Azure
Question 175
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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?
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
Question 176
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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.
Explanation:
Section: Describe an analytics workload on Azure
Reference: https://www.sqlshack.com/a-beginners-guide-to-azure-databricks/
Question 177
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
You have a quality assurance application that reads data from a data warehouse.
Which type of processing does the application use?
Explanation:
Section: Describe an analytics workload on Azure
Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction-processing
Question 178
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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.
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
Question 179
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Which Azure Data Factory component provides the compute environment for activities?
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 180
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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?
Explanation:
Section: Describe an analytics workload on Azure
Reference: https://docs.databricks.com/data/data-sources/azure/synapse-analytics.html
Question