Microsoft Microsoft Certifications DP-900 Questions & Answers

• Question 31:

  HOTSPOT

  To complete the sentence, select the appropriate option in the answer area.

  Hot Area:

  

  Correct Answer:

  

  With ELT, the data store used to perform the transformation is the same data store where the data is ultimately consumed.

  Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl

• Question 32:

  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.

  Hot Area:

  

  Correct Answer:

  

  Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl

• Question 33:

  HOTSPOT

  To complete the sentence, select the appropriate option in the answer area.

  Hot Area:

  

  Correct Answer:

  

• Question 34:

  HOTSPOT

  You plan to deploy a PostgreSQL database to Azure.

  Which hosting model corresponds to the available deployment options? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

• Question 35:

  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.

  Hot Area:

  

  Correct Answer:

  

  Reference: https://docs.microsoft.com/en-us/azure/data-lake-store/data-lake-store-get-started-portal https://docs.microsoft.com/en-us/azure/storage/common/storage-account-overview https://azure.microsoft.com/en-us/pricing/details/bandwidth/

• Question 36:

  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.

  Hot Area:

  

  Correct Answer:

  

  Box 1: No

  You can duplicate a dashboard. The duplicate ends up in the same Power BI workspace.

  There is no current functionality that allows you to move reports from one workspace to another.

  Box 2: No Box 3: Yes 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 37:

  HOTSPOT

  To complete the sentence, select the appropriate option in the answer area.

  Hot Area:

  

  Correct Answer:

  

  Paginated Reports in Power BI now allows users to generate these fixed-layout documents optimized for printing and archiving, such as PDF and Word files.

  These document-style reports with visualizations that provide additional control, like which tables expand horizontally and vertically to display all their data and continue from page to page as needed.

  Reference:

  https://powerbi.microsoft.com/en-us/blog/announcing-paginated-reports-in-power-bi-general-availability/

• Question 38:

  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.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Yes

  Azure Databricks can consume data from SQL Databases using JDBC and from SQL Databases using the Apache Spark connector.

  The Apache Spark connector for Azure SQL Database and SQL Server enables these databases to act as input data sources and output data sinks for Apache Spark jobs.

  Box 2: Yes

  You can stream data into Azure Databricks using Event Hubs.

  Box 3: Yes

  You can run Spark jobs with data stored in Azure Cosmos DB using the Cosmos DB Spark connector.

  Cosmos can be used for batch and stream processing, and as a serving layer for low latency access.

  You can use the connector with Azure Databricks or Azure HDInsight, which provide managed Spark clusters on Azure.

  Reference:

  https://docs.microsoft.com/en-us/azure/databricks/data/data-sources/sql-databases-azure

  https://docs.microsoft.com/en-us/azure/databricks/scenarios/databricks-stream-from-eventhubs

• Question 39:

  HOTSPOT

  To complete the sentence, select the appropriate option in the answer area.

  Hot Area:

  

  Correct Answer:

  

  Note: The data warehouse workload encompasses:

  1.

  The entire process of loading data into the warehouse

  2.

  Performing data warehouse analysis and reporting

  3.

  Managing data in the data warehouse

  4.

  Exporting data from the data warehouse

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

• Question 40:

  HOTSPOT

  For each of the following statements, select Yes if the statement is true. Otherwise, select No.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Yes

  Azure Data Studio is a cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.

  You can use Azure Data Studio to connect to an Azure SQL Database server. You'll then run Transact-SQL (T-SQL) statements to create and query Azure SQL databases.

  Box 2: No

  SQL Server Management Studio is for configuring, managing, and administering all components within Microsoft SQL Server, not to create SQL notebooks.

  Instead use Azure Data Studio to create SQL notebook.

  Box 3: Yes

  You can use the Azure Data Studio to restore databases.

  Reference:https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is-azure-data-studio