Microsoft Microsoft Certifications DP-900 Questions & Answers

• Question 161:

  What is the primary purpose of a data warehouse?

  A. to provide answers to complex queries that rely on data from multiple sources

  B. to provide transformation services between source and target data stores

  C. to provide read-only storage of relational and non-relational historical data

  D. to provide storage for transactional line-of-business (LOB) applications

  Correct Answer: A

  The ans should be A.

  In the textbook DP-900T00-A-Microsoft Azure Data Fundamentals Module 4 Describe modern data warehousing:

  ''A data warehouse gathers data from many different sources within an organization...The focus of a data warehouse is to provide answers to complex queries...''

• Question 162:

  You need to modify a view in a relational database by adding a new column.

  Which of following statement should you use?

  A. MERGE

  B. ALTER

  C. INSERT

  D. UPDATE

  Correct Answer: B

• Question 163:

  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?

  A. Azure Functions

  B. Microsoft SQL Server Integration Services (SSIS)

  C. PolyBase

  D. Azure Data Factory

  Correct Answer: C

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

• Question 164:

  You have an application that runs on Windows and requires access to a mapped drive. Which Azure service should you use?

  A. Azure Files

  B. Azure Blob storage

  C. Azure Cosmos DB

  D. Azure Table storage

  Correct Answer: A

  Azure Files is Microsoft's easy-to-use cloud file system. Azure file shares can be seamlessly used in Windows and Windows Server. To use an Azure file share with Windows, you must either mount it, which means assigning it a drive letter or mount point path, or access it via its UNC path.

  Reference: https://docs.microsoft.com/en-us/azure/storage/files/storage-how-to-use-files-windows

• Question 165:

  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

  Correct Answer: B

  The Integration Runtime (IR) is the compute infrastructure used by Azure Data Factory to provide the following data integration capabilities across different network environments:

  1.

  Data Flow

  2.

  Data movement

  3.

  Activity dispatch

  4.

  SSIS package execution

  Reference: https://docs.microsoft.com/en-us/azure/data-factory/concepts-integration-runtime

• Question 166:

  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.

  A. report and dashboard creation

  B. report sharing and distribution

  C. data modeling

  D. data acquisition and preparation

  Correct Answer: AD

• Question 167:

  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. a report page

  B. a Microsoft PowerPoint slide

  C. a visualization from a report

  D. a dataflow

  E. a text box

  Correct Answer: ACE

  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 168:

  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

  Correct Answer: D

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

• Question 169:

  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 dedicated SQL pool as much as possible 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

  Correct Answer: B

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

• Question 170:

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

  A. a control flow

  B. a trigger

  C. a parameter

  D. an activity

  Correct Answer: B

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