Microsoft Microsoft Certifications DP-203 Questions & Answers

• Question 71:

  HOTSPOT

  You are designing an application that will use an Azure Data Lake Storage Gen 2 account to store petabytes of license plate photos from toll booths. The account will use zone- redundant storage (ZRS).

  You identify the following usage patterns:

  1.

  The data will be accessed several times a day during the first 30 days after the data is created.

  2.

  The data must meet an availability SU of 99.9%.

  3.

  After 90 days, the data will be accessed infrequently but must be available within 30 seconds.

  4.

  After 365 days, the data will be accessed infrequently but must be available within five minutes.

  Hot Area:

  

  Correct Answer:

  

• Question 72:

  HOTSPOT

  You are designing an Azure Data Lake Storage Gen2 container to store data for the human resources (HR) department and the operations department at your company. You have the following data access requirements:

  1.

  After initial processing, the HR department data will be retained for seven years.

  2.

  The operations department data will be accessed frequently for the first six months, and then accessed once per month. You need to design a data retention solution to meet the access requirements. The solution must minimize storage costs.

  Hot Area:

  

  Correct Answer:

  

• Question 73:

  HOTSPOT

  You store files in an Azure Data Lake Storage Gen2 container. The container has the storage policy shown in the following exhibit.

  

  Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection Is worth one point.

  Hot Area:

  

  Correct Answer:

  

• Question 74:

  HOTSPOT

  You have an Azure Storage account that generates 200.000 new files daily. The file names have a format of (YYY)/(MM)/(DD)/|HH])/(CustornerID).csv.

  You need to design an Azure Data Factory solution that will toad new data from the storage account to an Azure Data lake once hourly. The solution must minimize load times and costs.

  How should you configure the solution? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

• Question 75:

  HOTSPOT

  You plan to create an Azure Data Lake Storage Gen2 account

  You need to recommend a storage solution that meets the following requirements:

  1.

  Provides the highest degree of data resiliency

  2.

  Ensures that content remains available for writes if a primary data center fails

  What should you include in the recommendation? To answer, select the appropriate options in the answer area.

  Hot Area:

  

  Correct Answer:

  

• Question 76:

  HOTSPOT

  You have an Azure subscription.

  You need to deploy an Azure Data Lake Storage Gen2 Premium account. The solution must meet the following requirements:

  1.

  Blobs that are older than 365 days must be deleted.

  2.

  Administrator efforts must be minimized.

  3.

  Costs must be minimized

  What should you use? To answer, select the appropriate options in the answer area. NOTE Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

• Question 77:

  HOTSPOT

  You are designing an enterprise data warehouse in Azure Synapse Analytics that will store website traffic analytics in a star schema.

  You plan to have a fact table for website visits. The table will be approximately 5 GB. You need to recommend which distribution type and index type to use for the table. The solution must provide the fastest query performance.

  What should you recommend? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Hash

  Consider using a hash-distributed table when:

  The table size on disk is more than 2 GB.

  The table has frequent insert, update, and delete operations.

  Box 2: Clustered columnstore

  Clustered columnstore tables offer both the highest level of data compression and the best overall query performance.

• Question 78:

  HOTSPOT

  You are building an Azure Stream Analytics job that queries reference data from a product catalog file. The file is updated daily.

  The reference data input details for the file are shown in the Input exhibit. (Click the Input tab.)

  

  The storage account container view is shown in the Refdata exhibit. (Click the Refdata tab.)

  

  You need to configure the Stream Analytics job to pick up the new reference data.

  What should you configure? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: {date}/product.csv In the 2nd exhibit we see: Location: refdata / 2020-03-20 Note: Path Pattern: This is a required property that is used to locate your blobs within the specified container. Within the path, you may choose to specify one or more instances of the following 2 variables: {date}, {time} Example 1: products/{date}/{time}/product-list.csv Example 2: products/{date}/product-list.csv Example 3: product-list.csv

  Box 2: YYYY-MM-DD

  Note: Date Format [optional]: If you have used {date} within the Path Pattern that you specified, then you can select the date format in which your blobs are organized from the drop-down of supported formats. Example: YYYY/MM/DD, MM/DD/YYYY, etc.

• Question 79:

  HOTSPOT

  The storage account container view is shown in the Refdata exhibit. (Click the Refdata tab.) You need to configure the Stream Analytics job to pick up the new reference data. What should you configure? To answer, select the appropriate

  options in the answer area NOTE:

  Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

• Question 80:

  HOTSPOT

  You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and an Azure Data Lake Storage Gen2 account named Account 1.

  You plan to access the files in Accoun1l by using an external table.

  You need to create a data source in Pool1 that you can reference when you create the external table.

  How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.

  NOTE Each coned selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: blob The following example creates an external data source for Azure Data Lake Gen2 CREATE EXTERNAL DATA SOURCE YellowTaxi WITH ( LOCATION = 'https://azureopendatastorage.blob.core.windows.net/nyctlc/yellow/', TYPE = HADOOP)

  Box 2: HADOOP