Explanation/Reference:
Explanation:
Azure resource costs must be minimized where possible.
Data used for Planning Assistance must be stored in a sharded Azure SQL Database.
The SLA for Planning Assistance is 70 percent, and multiday outages are permitted.
Testlet 2
Case study
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other question on this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next sections of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question on this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Requirements
Business
The company identifies the following business requirements:
You must transfer all images and customer data to cloud storage and remove on-premises servers.

You must develop an analytical processing solution for transforming customer data.

You must develop an image object and color tagging solution.

Capital expenditures must be minimized.

Cloud resource costs must be minimized.

Technical
The solution has the following technical requirements:
Tagging data must be uploaded to the cloud from the New York office location.

Tagging data must be replicated to regions that are geographically close to company office locations.

Image data must be stored in a single data store at minimum cost.

Customer data must be analyzed using managed Spark clusters.

Power BI must be used to visualize transformed customer data.

All data must be backed up in case disaster recovery is required.

Security and optimization
All cloud data must be encrypted at rest and in transit. The solution must support:
parallel processing of customer data

hyper-scale storage of images

global region data replication of processed image data

DP-201

DP-201
Testlet 1
Case study
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other question on this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next sections of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question on this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Background
Trey Research is a technology innovator. The company partners with regional transportation department office to build solutions that improve traffic flow and safety.
The company is developing the following solutions:

Regional transportation departments installed traffic sensor systems on major highways across North America. Sensors record the following information each time a vehicle passes in front of a sensor:
Time

Location in latitude and longitude

Speed in kilometers per second (kmps)

License plate number

Length of vehicle in meters

Sensors provide data by using the following structure:

Traffic sensors will occasionally capture an image of a vehicle for debugging purposes.
You must optimize performance of saving/storing vehicle images.
Traffic sensor data
Sensors must have permission only to add items to the SensorData collection.

Traffic data insertion rate must be maximized.

Once every three months all traffic sensor data must be analyzed to look for data patterns that indicate

sensor malfunctions.
Sensor data must be stored in a Cosmos DB named treydata in a collection named SensorData

The impact of vehicle images on sensor data throughout must be minimized.

Backtrack
This solution reports on all data related to a specific vehicle license plate. The report must use data from the SensorData collection. Users must be able to filter vehicle data in the following ways:
vehicles on a specific road

vehicles driving above the speed limit

Planning Assistance
Data used for Planning Assistance must be stored in a sharded Azure SQL Database.
Data from the Sensor Data collection will automatically be loaded into the Planning Assistance database once a week by using Azure Data Factory. You must be able to manually trigger the data load process.
Privacy and security policy
Azure Active Directory must be used for all services where it is available.

For privacy reasons, license plate number information must not be accessible in Planning Assistance.

Unauthorized usage of the Planning Assistance data must be detected as quickly as possible.

Unauthorized usage is determined by looking for an unusual pattern of usage.
Data must only be stored for seven years.

Performance and availability
The report for Backtrack must execute as quickly as possible.

The SLA for Planning Assistance is 70 percent, and multiday outages are permitted.

All data must be replicated to multiple geographic regions to prevent data loss.

You must maximize the performance of the Real Time Response system.

Financial requirements
Azure resource costs must be minimized where possible.

Explanation/Reference:
Explanation:
To keep an interactive cluster configuration even after it has been terminated for more than 30 days, an administrator can pin a cluster to the cluster list.
References:
https://docs.azuredatabricks.net/user-guide/clusters/terminate.html

Spark in SQL Server big data cluster enables AI and machine learning.
You can use Apache Spark MLlib to create a machine learning application to do simple predictive analysis on an open dataset.
MLlib is a core Spark library that provides many utilities useful for machine learning tasks, including utilities that are suitable for:
* Classification
* Regression
* Clustering
* Topic modeling
* Singular value decomposition (SVD) and principal component analysis (PCA)
* Hypothesis testing and calculating sample statistics
Reference:
https://docs.microsoft.com/en-us/azure/hdinsight/spark/apache-spark-machine-learning-mllib-ipython

Explanation/Reference:
Explanation:
To achieve the fastest loading speed for moving data into a data warehouse table, load data into a staging
table. Define the staging table as a heap and use round-robin for the distribution option.
Incorrect:
Not B: Consider that loading is usually a two-step process in which you first load to a staging table and
then insert the data into a production data warehouse table. If the production table uses a hash
distribution, the total time to load and insert might be faster if you define the staging table with the hash
distribution. Loading to the staging table takes longer, but the second step of inserting the rows to the
production table does not incur data movement across the distributions.
References:
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/guidance-for-loading-data