Question 36
You are designing a big data storage solution. The solution must meet the following requirements:
* Provide unlimited account sizes.
* Support a hierarchical file system.
* Be optimized for parallel analytics workloads.
Which storage solution should you use?
* Provide unlimited account sizes.
* Support a hierarchical file system.
* Be optimized for parallel analytics workloads.
Which storage solution should you use?
Question 37
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
A company is developing a solution to manage inventory data for a group of automotive repair shops. The solution will use Azure SQL Data Warehouse as the data store.
Shops will upload data every 10 days.
Data corruption checks must run each time data is uploaded. If corruption is detected, the corrupted data must be removed.
You need to ensure that upload processes and data corruption checks do not impact reporting and analytics processes that use the data warehouse.
Proposed solution: Insert data from shops and perform the data corruption check in a transaction. Rollback transfer if corruption is detected.
Does the solution meet the goal?
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
A company is developing a solution to manage inventory data for a group of automotive repair shops. The solution will use Azure SQL Data Warehouse as the data store.
Shops will upload data every 10 days.
Data corruption checks must run each time data is uploaded. If corruption is detected, the corrupted data must be removed.
You need to ensure that upload processes and data corruption checks do not impact reporting and analytics processes that use the data warehouse.
Proposed solution: Insert data from shops and perform the data corruption check in a transaction. Rollback transfer if corruption is detected.
Does the solution meet the goal?
Question 38
You are designing an Azure Data Factory solution that will download up to 5 TB of data from several REST APIs.
The solution must meet the following staging requirements:
* Ensure that the data can be landed quickly and in parallel to a staging area.
* Minimize the need to return to the API sources to retrieve the data again should a later activity in the pipeline fail.
The solution must meet the following analysis requirements:
* Ensure that the data can be loaded in parallel.
* Ensure that users and applications can query the data without requiring an additional compute engine.
What should you include in the solution to meet the requirements? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
The solution must meet the following staging requirements:
* Ensure that the data can be landed quickly and in parallel to a staging area.
* Minimize the need to return to the API sources to retrieve the data again should a later activity in the pipeline fail.
The solution must meet the following analysis requirements:
* Ensure that the data can be loaded in parallel.
* Ensure that users and applications can query the data without requiring an additional compute engine.
What should you include in the solution to meet the requirements? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Question 39
You are evaluating the use of an Azure Cosmos DB account for a new database.
The proposed account will be configured as 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.
The proposed account will be configured as 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.
Question 40
You have an Azure Storage account that generates 200,000 new files daily. The file names have a format of
{YYYY}/{MM}/{DD}/{HH}/{CustomerID}.csv.
You need to design an Azure Data Factory solution that will load 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
{YYYY}/{MM}/{DD}/{HH}/{CustomerID}.csv.
You need to design an Azure Data Factory solution that will load 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
