DP-900 practice questions 61–70

1. Question 61 · 291 in bank

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

   • ASSIS packages
   • Ban integration runtime
   • Ca control flow
   • Da pipeline

   Show answer

   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

   Source: Adapted from community discussion — Azurre

   Next question

2. Question 62 · 291 in bank

   HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   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/

   

   Next question

3. Question 63 · 291 in bank

   Select 2

   What are two uses of data visualization? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   • ARepresent trends and patterns over time
   • BImplement machine learning to predict future values
   • CCommunicate the significance of data
   • DEnforce business logic across reports

   Show answer

   Answer: AC

   Explanation

   Data visualization is a key component in being able to gain insight into your data. It helps make big and small data easier for humans to understand. It also makes it easier to detect patterns, trends, and outliers in groups of data. Data visualization brings data to help you find key business insights quickly and effectively. Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-data-visualization

   Next question

4. Question 64 · 291 in bank

   You need to use Transact-SQL to query files in Azure Data Lake Storage Gen 2 from an Azure Synapse Analytics data warehouse. What should you use to query the files?

   • AAzure Functions
   • BMicrosoft SQL Server Integration Services (SSIS)
   • CPolyBase
   • DAzure Data Factory

   Show answer

   Answer: C

   Explanation

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

   Source: Adapted from community discussion — faust0

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

5. Question 65 · 291 in bank

   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:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   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-dashboards https://powerbi.microsoft.com/en-us/excel-and-power-bi/

   Source: Adapted from community discussion — Joanna0

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

6. Question 66 · 291 in bank

   Select 2

   You need to create an Azure Storage account. Data in the account must replicate outside the Azure region automatically. Which two types of replication can you use for the storage account? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   • Azone-redundant storage (ZRS)
   • Bread-access geo-redundant storage (RA-GRS)
   • Clocally-redundant storage (LRS)
   • Dgeo-redundant storage (GRS)

   Show answer

   Answer: BD

   Explanation

   Careful with this one. If we are talking about "outside replication", the options will be GRS and RA-GRS (particular case that gives active-active between regions with reading accessible in the second one). However, GRS does NOT allow to read in the secondary region in an active-active way. It only happens when the first region fails. Bear this in mind. The option is correct given the requirements in the question.

   Source: Adapted from community discussion — AlfuryDB

   References

   • Microsoft Learn

   Next question

7. Question 67 · 291 in bank

   What is the primary purpose of a data warehouse?

   • Ato provide answers to complex queries that rely on data from multiple sources
   • Bto provide transformation services between source and target data stores
   • Cto provide read-only storage of relational and non-relational historical data
   • Dto provide storage for transactional line-of-business (LOB) applications

   Show answer

   Answer: A

   Explanation

   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...''

   Source: Adapted from community discussion — xavier41

   References

   • azure.microsoft.com documentation
   • Microsoft Learn
   • azure.microsoft.com documentation
   • Microsoft Learn

   Next question

8. Question 68 · 291 in bank

   DRAG DROP - Match the Azure services to the appropriate locations in the architecture. To answer, drag the appropriate service from the column on the left to its location on the right. Each service may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Box Ingest: Azure Data Factory - You can build a data ingestion pipeline with Azure Data Factory (ADF). Box Preprocess & model: Azure Synapse Analytics Use Azure Synapse Analytics to preprocess data and deploy machine learning models. Reference: https://docs.microsoft.com/en-us/azure/machine-learning/how-to-data-ingest-adf https://docs.microsoft.com/en-us/azure/machine-learning/team-data-science-process/sqldw-walkthrough

   

   Next question

9. Question 69 · 291 in bank

   DRAG DROP - Match the types of workloads to the appropriate scenarios. To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Box 1: Batch - The batch processing model requires a set of data that is collected over time while the stream processing model requires data to be fed into an analytics tool, often in micro-batches, and in real-time. The batch Processing model handles a large batch of data while the Stream processing model handles individual records or micro-batches of few records. In Batch Processing, it processes over all or most of the data but in Stream Processing, it processes over data on a rolling window or most recent record. Box 2: Batch - Box 3: Streaming - Reference: https://k21academy.com/microsoft-azure/dp-200/batch-processing-vs-stream-processing

   

   Next question

10. Question 70 · 291 in bank

    HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area:

    

    This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

    Show the answer figure

    Answer: See figure below

    Explanation

    Note: The data warehouse workload encompasses: ✑ The entire process of loading data into the warehouse ✑ Performing data warehouse analysis and reporting ✑ Managing data in the data warehouse ✑ Exporting data from the data warehouse Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-management

    Source: Adapted from community discussion — j888

    

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

DP-900 practice, question 61. 291 questions available.