DP-203 practice questions 361–370

1. Question 361 · 370 in bank

   HOTSPOT - You need to design the partitions for the product sales transactions. The solution must meet the sales transaction dataset requirements. What should you include in the solution? To answer, select the appropriate options in the answer area. 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: Sales date - Scenario: Contoso requirements for data integration include: ✑ Partition data that contains sales transaction records. Partitions must be designed to provide efficient loads by month. Boundary values must belong to the partition on the right. Box 2: An Azure Synapse Analytics Dedicated SQL pool Scenario: Contoso requirements for data integration include: ✑ Ensure that data storage costs and performance are predictable. The size of a dedicated SQL pool (formerly SQL DW) is determined by Data Warehousing Units (DWU). Dedicated SQL pool (formerly SQL DW) stores data in relational tables with columnar storage. This format significantly reduces the data storage costs, and improves query performance. Synapse analytics dedicated sql pool Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-what-is

   Source: Adapted from community discussion — Jerrie86

   

   Next question

2. Question 362 · 370 in bank

   You need to implement the surrogate key for the retail store table. The solution must meet the sales transaction dataset requirements. What should you create?

   • Aa table that has an IDENTITY property
   • Ba system-versioned temporal table
   • Ca user-defined SEQUENCE object
   • Da table that has a FOREIGN KEY constraint

   Show answer

   Answer: A

   Explanation

   A surrogate key is a system-generated unique identifier that is used as a substitute for a natural key. In this case, the surrogate key will be used to account for changes to the retail store addresses. By creating a table with an IDENTITY property, you can ensure that a unique surrogate key is automatically generated for each row inserted into the table. The IDENTITY property assigns a unique value to the column automatically, incrementing by one for each new row. Using an IDENTITY column as the surrogate key will provide an efficient way to join and filter sales transaction records based on product ID, as required by the sales transaction dataset requirements.

   Source: Adapted from community discussion — vctrhugo

   Next question

3. Question 363 · 370 in bank

   HOTSPOT - You need to design an analytical storage solution for the transactional data. The solution must meet the sales transaction dataset requirements. What should you include in the solution? To answer, select the appropriate options in the answer area. 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: Round-robin - Round-robin tables are useful for improving loading speed. Scenario: Partition data that contains sales transaction records. Partitions must be designed to provide efficient loads by month. Box 2: Hash - Hash-distributed tables improve query performance on large fact tables. Scenario: ✑ You plan to create a promotional table that will contain a promotion ID. The promotion ID will be associated to a specific product. The product will be identified by a product ID. The table will be approximately 5 GB. ✑ Ensure that queries joining and filtering sales transaction records based on product ID complete as quickly as possible. Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-distribute

   Source: Adapted from community discussion — Jerrie86

   References

   • Microsoft Learn

   

   Next question

4. Question 364 · 370 in bank

   HOTSPOT - You need to implement an Azure Synapse Analytics database object for storing the sales transactions data. The solution must meet the sales transaction dataset requirements. What should you do? To answer, select the appropriate options in the answer area. 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: Create table - Scenario: Load the sales transaction dataset to Azure Synapse Analytics Box 2: RANGE RIGHT FOR VALUES - Scenario: Partition data that contains sales transaction records. Partitions must be designed to provide efficient loads by month. Boundary values must belong to the partition on the right. RANGE RIGHT: Specifies the boundary value belongs to the partition on the right (higher values). FOR VALUES ( boundary_value [,...n] ): Specifies the boundary values for the partition. Scenario: Load the sales transaction dataset to Azure Synapse Analytics. Contoso identifies the following requirements for the sales transaction dataset: ✑ Partition data that contains sales transaction records. Partitions must be designed to provide efficient loads by month. Boundary values must belong to the partition on the right. ✑ Ensure that queries joining and filtering sales transaction records based on product ID complete as quickly as possible. ✑ Implement a surrogate key to account for changes to the retail store addresses. ✑ Ensure that data storage costs and performance are predictable. ✑ Minimize how long it takes to remove old records. Reference: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-table-azure-sql-data-warehouse

   Source: Adapted from community discussion — Azurre

   References

   • Microsoft Learn

   

   Next question

5. Question 365 · 370 in bank

   You need to design a data retention solution for the Twitter feed data records. The solution must meet the customer sentiment analytics requirements. Which Azure Storage functionality should you include in the solution?

   • Achange feed
   • Bsoft delete
   • Ctime-based retention
   • Dlifecycle management

   Show answer

   Answer: D

   Explanation

   Given answer is correct. Time bases retention is to retain data for a specific time. it wont delete the data. The requirement is to deleted the data after 2 Years. Which can be accomplished by Data life cycle management. A time-based retention policy stores blob data in a Write-Once, Read-Many (WORM) format for a specified interval. When a time-based retention policy is set, clients can create and read blobs, but can't modify or delete them. After the retention interval has expired, blobs can be deleted but not overwritten. https://learn.microsoft.com/en-us/azure/storage/blobs/immutable-time-based-retention-policy-overview

   Source: Adapted from community discussion — yogiazaad

   References

   • Microsoft Learn

   Next question

6. Question 366 · 370 in bank

   HOTSPOT - Which Azure Data Factory components should you recommend using together to import the daily inventory data from the SQL server to Azure Data Lake Storage? To answer, select the appropriate options in the answer area. 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: Self-hosted integration runtime A self-hosted IR is capable of running copy activity between a cloud data stores and a data store in private network. Box 2: Schedule trigger - Schedule every 8 hours - Box 3: Copy activity - Scenario: ✑ Customer data, including name, contact information, and loyalty number, comes from Salesforce and can be imported into Azure once every eight hours. Row modified dates are not trusted in the source table. ✑ Product data, including product ID, name, and category, comes from Salesforce and can be imported into Azure once every eight hours. Row modified dates are not trusted in the source table.

   Source: Adapted from community discussion — AzureJobsTillRetire

   References

   • Microsoft Learn

   

   Next question

7. Question 367 · 370 in bank

   DRAG DROP - You need to implement versioned changes to the integration pipelines. The solution must meet the data integration requirements. In which order should you perform the actions? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. 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

   Scenario: Identify a process to ensure that changes to the ingestion and transformation activities can be version-controlled and developed independently by multiple data engineers. Step 1: Create a repository and a main branch You need a Git repository in Azure Pipelines, TFS, or GitHub with your app. Step 2: Create a feature branch - Step 3: Create a pull request - Step 4: Merge changes - Merge feature branches into the main branch using pull requests. Step 5: Publish changes - Reference: https://docs.microsoft.com/en-us/azure/devops/pipelines/repos/pipeline-options-for-git

   Source: Adapted from community discussion — NaiCob

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

8. Question 368 · 370 in bank

   HOTSPOT - You need to design a data ingestion and storage solution for the Twitter feeds. The solution must meet the customer sentiment analytics requirements. What should you include in the solution? To answer, select the appropriate options in the answer area. 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: Configure Evegent Hubs partitions Scenario: Maximize the throughput of ingesting Twitter feeds from Event Hubs to Azure Storage without purchasing additional throughput or capacity units. Event Hubs is designed to help with processing of large volumes of events. Event Hubs throughput is scaled by using partitions and throughput-unit allocations. Incorrect Answers: ✑ Event Hubs Dedicated: Event Hubs clusters offer single-tenant deployments for customers with the most demanding streaming needs. This single-tenant offering has a guaranteed 99.99% SLA and is available only on our Dedicated pricing tier. ✑ Auto-Inflate: The Auto-inflate feature of Event Hubs automatically scales up by increasing the number of TUs, to meet usage needs. Event Hubs traffic is controlled by TUs (standard tier). Auto-inflate enables you to start small with the minimum required TUs you choose. The feature then scales automatically to the maximum limit of TUs you need, depending on the increase in your traffic. Box 2: An Azure Data Lake Storage Gen2 account Scenario: Ensure that the data store supports Azure AD-based access control down to the object level. Azure Data Lake Storage Gen2 implements an access control model that supports both Azure role-based access control (Azure RBAC) and POSIX-like access control lists (ACLs). Incorrect Answers: ✑ Azure Databricks: An Azure administrator with the proper permissions can configure Azure Active Directory conditional access to control where and when users are permitted to sign in to Azure Databricks. ✑ Azure Storage supports using Azure Active Directory (Azure AD) to authorize requests to blob data. You can scope access to Azure blob resources at the following levels, beginning with the narrowest scope: - An individual container. At this scope, a role assignment applies to all of the blobs in the container, as well as container properties and metadata. - The storage account. At this scope, a role assignment applies to all containers and their blobs. - The resource group. At this scope, a role assignment applies to all of the containers in all of the storage accounts in the resource group. - The subscription. At this scope, a role assignment applies to all of the containers in all of the storage accounts in all of the resource groups in the subscription. - A management group. Reference: https://docs.microsoft.com/en-us/azure/event-hubs/event-hubs-features https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control

   Source: Adapted from community discussion — noobprogrammer

   References

   • Microsoft Learn

   

   Next question

9. Question 369 · 370 in bank

   What should you recommend to prevent users outside the Litware on-premises network from accessing the analytical data store?

   • Aa server-level virtual network rule
   • Ba database-level virtual network rule
   • Ca server-level firewall IP rule
   • Da database-level firewall IP rule

   Show answer

   Answer: C

   Explanation

   I think it should be C. The company doesn't want any virtual network stuff and server-level is more comprehensive, thus safer than just database-level rule.

   Source: Adapted from community discussion — Kyle1

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Next question

10. Question 370 · 370 in bank

    What should you recommend using to secure sensitive customer contact information?

    • ATransparent Data Encryption (TDE)
    • Brow-level security
    • Ccolumn-level security
    • Ddata sensitivity labels

    Show answer

    Answer: C

    Explanation

    Answer is C https://azure.microsoft.com/en-ca/updates/column-level-security-is-now-supported-in-azure-sql-data-warehouse/ You can use CLS to manage user access to specific columns in your tables in a simpler manner, without having to redesign your data warehouse. CLS eliminates the need to maintain access restriction logic away from the data in another application or introduce views for filtering out sensitive columns for a subset of users.

    Source: Adapted from community discussion — echerish

    References

    • azure.microsoft.com documentation

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

DP-203 practice, question 361. 370 questions available.