DP 200 & 201: Implementing and Designing Azure Data Solution Practice Questions Part 3

A company is planning to set an Azure SQL database. The database contains a table that will be storing sensitive Personally Identifiable Information (PII) data. The company wants to have the ability to track and store all the queries that are executed against the PII data. The company decides to implement Transparent Data Encryption.
Would this fulfill the requirement?

A company wants Cosmos DB accounts. Below are the requirements for the account.
• Be able to store millions of objects.
• The data stored will contain information about users.
• The company should have the ability to identity and query relationships between users.
Which of the following could be used as the API for the Cosmos DB account?

A company is making use of an Azure SQL database. The database administrator is documenting the procedure for the automated backups which are taken by the SQL database service.
Which of the following is the first type of backup that is taken by the service?

A company is making use of an Azure SQL database. The database administrator documents the procedure for the automated backups taken by the SQL database service.
Which of the following is the third type of backup that is taken by the service?

A company is making use of an Azure SQL database. The database administrator is documenting the procedure for the automated backups which are taken by the SQL database service.
Which of the following is the first type of backup that is taken by the service?

You have to design a solution for your company. The solution would involve the following components.
• Processing of streams of data from multiple loT based devices.
• Processing of streaming data.
• Storage of output data in a JSON-based data store.
You have to decide on the ideal store for storing the JSON-based documents. You decide to implement a Cosmos DB Account using the SQL API
Would this fulfill the requirement?

You have to design a solution for your company. The solution would involve the following components.
• Processing of streams of data from multiple loT based devices.
• Processing of streaming data.
• Storage of output data in a JSON based data store.
You have to decide on the ideal store for storing the JSON based documents. You decide to implement Azure Event Hubs for the storage of JSON documents.
Would this fulfill the requirement?

A company is planning to deploy thousands of loT enabled devices. The data from these devices will be sent to an Azure Event Hub instance. The data from this instance must then be transferred to Power BI for real-time visualizations. Which of the following service can be used to complete this system?

A company has purchased a number of loT devices. An IoT appliance is used to communicate with the loT devices. The company needs a solution to monitor the devices in real-time. Which of the following can be used for this requirement?

Your company is making use of an Azure SQL database. The database comes under heavy load during the last month of the year. You need to scale the Azure SQL database during this time manually. Which of the following would you implement for this requirement?

A company wants to use an Azure SQL Data warehouse instance. They need to load millions of rows of data into the warehouse every day. Staging tables have been set up for the data load process. Which of the following should be used as the staging table type to optimize the data loading process?

Your company wants to create a real-time monitoring application. It would alert users when a loT enabled device travels more than 50 meters away from a particular location. You have to design an Azure Stream Analytics job to process the data and implement the requirement. You have to minimize the amount of code developed and the number of technologies used for this requirement.
Which of the following would you use as the Input type?

Your company wants to create a real-time monitoring application. It would alert users when an IoT enabled device travels more than 50 meters away from a particular location. You have to design an Azure Stream Analytics job to process the data and implement the requirement. You have to minimize the amount of code developed and the number of technologies used for this requirement.
Which of the following would you use as the Input Source?

Your company wants to create a real-time monitoring application. It would alert users when a loT enabled device travels more than 50 meters away from a particular location. You have to design an Azure Stream Analytics job to process the data and implement the requirement. You have to minimize the amount of code developed and the number of technologies used for this requirement.
Which of the following would you use as the underlying Function in Azure Stream Analytics?

A company wants to design a processing system. The system has the following requirements.
• Data would be sent from IoT enabled devices.
• The solution must be able to ingest high volumes of data.
• The data needs to be analyzed in real-time.
• Query-based solutions must be deployed using continuous integration.
• Data must be visualized using graphs.
Which of the following would you implement for this requirement? Choose 2 answers from the options given below.

A company has an Azure storage account that has over a million files. These files are going to be shared with an external partner organization. The organization will analyze the files over the duration of 3 months. You have to recommend an access solution for the files which fit the following requirements.
• Ensure that ONLY the partner organization can access the files.
• Ensure that the access is revoked ONLY for partner organizations after 3 months.
Which of the following would you implement for this requirement?

A company is planning to use an Azure SQL data warehouse. They have 2 fact tables named ipslab_sales and ipslab_invoice. Below are the details on each table.
 ipslab_sales
o The table would be 500 GB in size.
o A column named SalesDate would be used extensively in the WHERE clause in queries.
o A column named SalesProduct would be used extensively in JOIN operations.
o A column named SalesRegion is used for grouping.
o Around 75% of the records are related to one of the 40 region values of the SalesRegion column.
 ipslab_invoice
 The table would be 6 GB in size.
o A column named SalesDate and SalesProduct would be used extensively in the WHERE clause in queries.
o A column named SalesRegion is used for grouping.
You need to ensure that query performance is optimized for each table.
Which of the following would you use as the Distribution type for the ipslab_sales table?

A company is planning to use an Azure SQL data warehouse. They have 2 fact tables named ipslab_sales and ipslab_invoice. Below are the details on each table.
 ipslab_sales
o The table would be 500 GB in size.
o A column named SalesDate would be used extensively in the WHERE clause in queries.
o A column named SalesProduct would be used extensively in JOIN operations.
o A column named SalesRegion is used for grouping.
o Around 75% of the records are related to one of the 40 region values of the SalesRegion column.
 ipslab_invoice
o The table would be 6 GB in size
o A column named SalesDate and SalesProduct would be used extensively in the WHERE clause in queries.
o A column named SalesRegion is used for grouping.
You need to ensure that query performance is optimized for each table.
Which of the following would you use as the Distribution column for the ipslab_sales table?

A company is planning to use an Azure SQL data warehouse. They have 2 fact tables named ipslab_sales and ipslab_invoice. Below are the details on each table.
 ipslab_sales
o The table would be 500 GB in size.
o A column named SalesDate would be used extensively in the WHERE clause in queries.
o A column named SalesProduct would be used extensively in JOIN operations.
o A column named SalesRegion is used for grouping.
o Around 75% of the records are related to one of the 40 region values of the SalesRegion column.
 ipslab_invoice
o The table would be 6 GB in size
o A column named SalesDate and SalesProduct would be used extensively in the WHERE clause in queries.
o A column named SalesRegion is used for grouping.
You need to ensure that query performance is optimized for each table.
Which of the following would you use as the Distribution type for the ipslab_invoice table?

A company is planning to use an Azure SQL data warehouse. They have 2 fact tables named ipslab_sales and ipslab_invoice. Below are the details on each table.
 ipslab_sales
o The table would be 500 GB in size.
o A column named SalesDate would be used extensively in the W/HERE clause in queries.
o A column named SalesProduct would be used extensively in JOIN operations.
o A column named SalesRegion is used for grouping.
o Around 75% of the records are related to one of the 40 region values of the SalesRegion column.
 ipslab_invoice
o The table would be 6 GB in size.
o A column named SalesDate and SalesProduct would be used extensively in the WHERE clause in queries.
o A column named SalesRegion is used for grouping.
You need to ensure that query performance is optimized for each table.
Which of the following would you use as the Distribution column for the ipslab_invoice table?

A company wants to have a data store in Azure. They want to store data in the form of nodes and relationships between the nodes via graph structures.
Which of the following could they use as the data store?

Your company has an enterprise Data warehouse in Azure Synapse. You have to load data into the SQL data warehouse. You have to ensure that load times are decreased when data is loaded into the tables in the data warehouse. Which of the following would you consider carrying out for this requirement? Choose 2 answers from the options given below.

A company wants to have a data store in Azure. They want to store data in the form of nodes and relationships between the nodes via graph structures.
Which of the following could they use as the data store?

Your company has an enterprise Data warehouse in Azure Synapse. You have to load data into the SQL data warehouse. You have to ensure that load times are decreased when data is loaded into the tables in the data warehouse. Which of the following would you consider carrying out for this requirement? Choose 2 answers from the options given below.

You have to develop a solution that would make use of Azure Stream Analytics. The Stream Analytics job would be used to load data into an Azure Cosmos DB Account. Which of the following would you use as the underlying API for the Azure Cosmos DB account?

Your company is planning to use the Azure SGL Database along with elastic pools. The tables in the databases will store customer information. Each record in the table will have a value for the column CustomerID. You have to partition the data based on the values in the column CustomerID. You decide to separate the data into shards and use horizontal partitioning.
Would this fulfill the requirement?

Your company is planning to use the Azure SQL Database along with elastic pools. The tables in the databases will store customer information. Each record in the table will have a value for the column CustomerID. You have to partition the data based on the values in the column CustomerID. You decide to separate the data into regions by using horizontal partitioning.
Would this fulfill the requirement?

Your company is planning to use the Azure SQL Database along with elastic pools. The tables in the databases will store customer information. Each record in the table will have a value for the column CustomerID. You have to partition the data based on the values in the column CustomerID. You decide to separate the data into regions by using vertical partitioning.
Would this fulfill the requirement?

Case Study

Overview

A company currently works with the local transportation sector. The company is responsible for building solutions that will help in the improvement of traffic and safety.

Current Requirements

The company is currently managing the following systems:

Traffic sensors have been installed at different road junctions to monitor traffic. The sensors capture the following data:

• Time
• Location in terms of latitude and longitude
• Speed in km per hour
• The license plate number
• The length of the vehicle in meters

A sample of the data sent is shown below:

The traffic sensors will also capture images of the vehicle from time to time

Requirements

Below are the various requirements for the various systems:

The traffic sensor data

• The sensors must only be able to add items to a collection named “CompanySensorDt”
• The insertion rate of the data must be maximized
• Once every 2 months, traffic sensor data must be analyzed to check for any malfunctions
• The collection “CompanySensorDt” must reside in Cosmos DB
• The impact of the storing the vehicle images on the collection throughput must be minimized

The Company_track system

• This system should be able to report on data that is related to specific plate number.
• The report would come from the “CompanySensorDt” collection
• Business users must be able to filter on vehicles that drive over a specific speed limit
• The Company_planning application
• The data for this application must be stored in an Azure SQL Database
• The data in the database would be sharded
• The data would be loaded from the “CompanySensorDt” collection once a week using Azure Data Factory
• A manual trigger would be used to transfer the data
• Security
• Azure Active Directory should be used for all services wherever possible
• The license plate information must not be visible in the “Company_planning” database
• If there is an unauthorized usage of the “Company_planning” database, the security team must be notified immediately
• Data must be stored for a maximum of 5 years

Other requirements

• Costs should be minimized wherever possible
• The reports for the “Company_track” application must execute as quickly as possible
• An SLA of 75% is permitted for the “Company_planning” application

It must be ensured that all data is replicated to multiple geographic locations to prevent any sort of data loss. You have to design the storage solution for the vehicle images. Which of the following would you use for this requirement?

Case Study

Overview

A company currently works with the local transportation sector. The company is responsible for building solutions that will help in improvement of traffic and safety.

Current Requirements

The company is currently managing the following systems:

Traffic sensors have been installed at different road junctions to monitor traffic. The sensors capture the following data:

• Time
• Location in terms of latitude and longitude
• Speed in km per hour
• The license plate number
• The length of the vehicle in meters

A sample of the data sent is shown below:

The traffic sensors will also capture images of the vehicle from time to time

Requirements

Below are the various requirements for the various systems:

The traffic sensor data

• The sensors must only be able to add items to a collection named “CompanySensorDt”
• The insertion rate of the data must be maximized
• Once every 2 months, traffic sensor data must be analyzed to check for any malfunctions
• The collection “CompanySensorDt” must reside in Cosmos DB
• The impact of the storing the vehicle images on the collection throughput must be minimized

The Company_track system

• This system should be able to report on data that is related to specific plate number.
• The report would come from the “CompanySensorDt” collection
• Business users must be able to filter on vehicles that drive over a specific speed limit

The Company_planning application

• The data for this application must be stored in an Azure SQL Database
• The data in the database would be sharded
• The data would be loaded from the “CompanySensorDt” collection once a week using Azure Data Factory
• A manual trigger would be used to transfer the data
• Security
• Azure Active Directory should be used for all services wherever possible
• The license plate information must not be visible in the “Company_planning” database
• If there is an unauthorized usage of the “Company_planning” database, the security team must be notified immediately
• Data must be stored for a maximum of 5 years

Other requirements

• Costs should be minimized wherever possible
• The reports for the “Company_track” application must execute as quickly as possible
• An SLA of 75% is permitted for the “Company_planning” application

You have to design sharding for the database in Azure SQL databases. Which of the following column could be used for sharding the data?

Case Study

Overview

A company currently works with the local transportation sector. The company is responsible for building solutions that will help in the improvement of traffic and safety.

Current Requirements

The company is currently managing the following systems:

Traffic sensors have been installed at different road junctions to monitor traffic. The sensors capture the following data:

• Time
• Location in terms of latitude and longitude
• Speed in km per hour
• The license plate number
• The length of the vehicle in meters

A sample of the data sent is shown below:

The traffic sensors will also capture images of the vehicle from time to time

Requirements

Below are the various requirements for the various systems:

The traffic sensor data

• The sensors must only be able to add items to a collection named “CompanySensorDt”
• The insertion rate of the data must be maximized
• Once every 2 months, traffic sensor data must be analyzed to check for any malfunctions
• The collection “CompanySensorDt” must reside in Cosmos DB
• The impact of the storing the vehicle images on the collection throughput must be minimized

The Company_track system

• This system should be able to report on data that is related to specific plate number.
• The report would come from the “CompanySensorDt” collection
• Business users must be able to filter on vehicles that drive over a specific speed limit

The Company_planning application

• The data for this application must be stored in an Azure SQL Database
• The data in the database would be sharded
• The data would be loaded from the “CompanySensorDt” collection once a week using Azure Data Factory
• A manual trigger would be used to transfer the data
• Security
• Azure Active Directory should be used for all services wherever possible
• The license plate information must not be visible in the “Company_planning” database
• If there is an unauthorized usage of the “Company_planning” database, the security team must be notified immediately
• Data must be stored for a maximum of 5 years

Other requirements

• Costs should be minimized wherever possible
• The reports for the “Company_track” application must execute as quickly as possible
• An SLA of 75% is permitted for the “Company_planning” application

Which of the following should be set as the consistency level for the “CompanySensorDt” collection?

Case Study

Overview

A company currently works with the local transportation sector. The company is responsible for building solutions that will help in the improvement of traffic and safety.

Current Requirements

The company is currently managing the following systems:

Traffic sensors have been installed at different road junctions to monitor traffic. The sensors capture the following data:

• Time
• Location in terms of latitude and longitude
• Speed in km per hour
• The license plate number
• The length of the vehicle in meters

A sample of the data sent is shown below:

The traffic sensors will also capture images of the vehicle from time to time

Requirements

Below are the various requirements for the various systems:

The traffic sensor data

• The sensors must only be able to add items to a collection named “CompanySensorDt”
• The insertion rate of the data must be maximized
• Once every 2 months, traffic sensor data must be analyzed to check for any malfunctions
• The collection “CompanySensorDt” must reside in Cosmos DB
• The impact of the storing the vehicle images on the collection throughput must be minimized

The Company_track system

• This system should be able to report on data that is related to specific plate number.
• The report would come from the “CompanySensorDt” collection
• Business users must be able to filter on vehicles that drive over a specific speed limit

The Company_planning application

• The data for this application must be stored in an Azure SQL Database
• The data in the database would be sharded
• The data would be loaded from the “CompanySensorDt” collection once a week using Azure Data Factory
• A manual trigger would be used to transfer the data
• Security
• Azure Active Directory should be used for all services wherever possible
• The license plate information must not be visible in the “Company_planning” database
• If there is an unauthorized usage of the “Company_planning” database, the security team must be notified immediately
• Data must be stored for a maximum of 5 years

Other requirements

• Costs should be minimized wherever possible
• The reports for the “Company_track” application must execute as quickly possible
• An SLA of 75% is permitted for the “Company_planning” application

Which of the following should be set as the partition key for the “CompanySensorDt” collection?

Case Study

Overview

A company currently works with the local transportation sector. The company is responsible for building solutions that will help in improvement of traffic and safety.

Current Requirements

The company is currently managing the following systems:

Traffic sensors have been installed at different road junctions to monitor traffic. The sensors capture the following data:

• Time
• Location in terms of latitude and longitude
• Speed in km per hour
• The license plate number
• The length of the vehicle in meters

A sample of the data sent is shown below:

The traffic sensors will also capture images of the vehicle from time to time

Requirements

Below are the various requirements for the various systems:

The traffic sensor data

• The sensors must only be able to add items to a collection named “CompanySensorDt”
• The insertion rate of the data must be maximized
• Once every 2 months, traffic sensor data must be analyzed to check for any malfunctions
• The collection “CompanySensorDt” must reside in Cosmos DB
• The impact of the storing the vehicle images on the collection throughput must be minimized

The Company_track system

• This system should be able to report on data that is related to specific plate number.
• The report would come from the “CompanySensorDt” collection
• Business users must be able to filter on vehicles that drive over a specific speed limit

The Company_planning application

• The data for this application must be stored in an Azure SQL Database
• The data in the database would be sharded
• The data would be loaded from the “CompanySensorDt” collection once a week using Azure Data Factory
• A manual trigger would be used to transfer the data
• Security
• Azure Active Directory should be used for all services wherever possible
• The license plate information must not be visible in the “Company_planning” database
• If there is an unauthorized usage of the “Company_planning” database, the security team must be notified immediately
• Data must be stored for a maximum of 5 years

Other requirements

• Costs should be minimized wherever possible
• The reports for the “Company_track” application must execute as quickly possible
• An SLA of 75% is permitted ofor the “Company_planning” application

You have to design the “Company_planning” database. You decide to include a clustered columnstore index to improve performance. Is this an ideal implementation?

Case Study

Overview

A company currently works with the local transportation sector. The company is responsible for building solutions that will help in the improvement of traffic and safety.

Current Requirements

The company is currently managing the following systems:

Traffic sensors have been installed at different road junctions to monitor traffic. The sensors capture the following data:

• Time
• Location in terms of latitude and longitude
• Speed in km per hour
• The license plate number
• The length of the vehicle in meters

A sample of the data sent is shown below:

The traffic sensors will also capture images of the vehicle from time to time

Requirements

Below are the various requirements for the various systems:

The traffic sensor data

• The sensors must only be able to add items to a collection named “CompanySensorDt”
• The insertion rate of the data must be maximized
• Once every 2 months, traffic sensor data must be analyzed to check for any malfunctions
• The collection “CompanySensorDt” must reside in Cosmos DB
• The impact of the storing the vehicle images on the collection throughput must be minimized

The Company_track system

• This system should be able to report on data that is related to specific plate number.
• The report would come from the “CompanySensorDt” collection
• Business users must be able to filter on vehicles that drive over a specific speed limit

The Company_planning application

• The data for this application must be stored in an Azure SQL Database
• The data in the database would be sharded
• The data would be loaded from the “CompanySensorDt” collection once a week using Azure Data Factory
• A manual trigger would be used to transfer the data
• Security
• Azure Active Directory should be used for all services wherever possible
• The license plate information must not be visible in the “Company_planning” database
• If there is an unauthorized usage of the “Company_planning” database, the security team must be notified immediately
• Data must be stored for a maximum of 5 years

Other requirements

• Costs should be minimized wherever possible
• The reports for the “Company_track” application must execute as quickly as possible
• An SLA of 75% is permitted for the “Company_planning” application

You have to design the “Company_planning” database. You decide to include a nonclustered columnstore index to improve performance. Is this an ideal implementation?

Case study

Overview

A company currently works with the local transportation sector. The company is responsible for building solutions that will help in the improvement of traffic and safety.

Current Requirements

The company is currently managing the following systems:

Traffic sensors have been installed at different road junctions to monitor traffic. The sensors capture the following data:

• Time
• Location in terms of latitude and longitude
• Speed in km per hour
• The license plate number
• The length of the vehicle in meters

A sample of the data sent is shown below:

The traffic sensors will also capture images of the vehicle from time to time

Requirements

Below are the various requirements for the various systems:

The traffic sensor data

• The sensors must only be able to add items to a collection named “CompanySensorDt”
• The insertion rate of the data must be maximized
• Once every 2 months, traffic sensor data must be analyzed to check for any malfunctions
• The collection “CompanySensorDt” must reside in Cosmos DB
• The impact of the storing the vehicle images on the collection throughput must be minimized

The Company_track system

• This system should be able to report on data that is related to specific plate number.
• The report would come from the “CompanySensorDt” collection
• Business users must be able to filter on vehicles that drive over a specific speed limit

The Company_planning application

• The data for this application must be stored in an Azure SQL Database
• The data in the database would be sharded
• The data would be loaded from the “CompanySensorDt” collection once a week using Azure Data Factory
• A manual trigger would be used to transfer the data
• Security
• Azure Active Directory should be used for all services wherever possible
• The license plate information must not be visible in the “Company_planning” database
• If there is an unauthorized usage of the “Company_planning” database, the security team must be notified immediately
• Data must be stored for a maximum of 5 years

Other requirements

• Costs should be minimized wherever possible
• The reports for the “Company_track” application must execute as quickly as possible
• An SLA of 75% is permitted for the “Company_planning” application

You have to design the “Company_planning” database. You decide to include an index on the plate number to improve performance. Is this an ideal implementation?

Case Study

Overview

A company currently works with the local transportation sector. The company is responsible for building solutions that will help in the improvement of traffic and safety.

Current Requirements

The company is currently managing the following systems:

Traffic sensors have been installed at different road junctions to monitor traffic. The sensors capture the following data:

• Time
• Location in terms of latitude and longitude
• Speed in km per hour
• The license plate number
• The length of the vehicle in meters

A sample of the data sent is shown below:

The traffic sensors will also capture images of the vehicle from time to time

Requirements

Below are the various requirements for the various systems:

The traffic sensor data

• The sensors must only be able to add items to a collection named “CompanySensorDt”
• The insertion rate of the data must be maximized
• Once every 2 months, traffic sensor data must be analyzed to check for any malfunctions
• The collection “CompanySensorDt” must reside in Cosmos DB
• The impact of the storing the vehicle images on the collection throughput must be minimized

The Company_track system

• This system should be able to report on data that is related to specific plate number.
• The report would come from the “CompanySensorDt” collection
• Business users must be able to filter on vehicles that drive over a specific speed limit

The Company_planning application

• The data for this application must be stored in an Azure SQL Database
• The data in the database would be sharded
• The data would be loaded from the “CompanySensorDt” collection once a week using Azure Data Factory
• A manual trigger would be used to transfer the data
• Security
• Azure Active Directory should be used for all services wherever possible
• The license plate information must not be visible in the “Company_planning” database
• If there is an unauthorized usage of the “Company_planning” database, the security team must be notified immediately
• Data must be stored for a maximum of 5 years

Other requirements

• Costs should be minimized wherever possible
• The reports for the “Company_track” application must execute as quickly as possible
• An SLA of 75% is permitted for the “Company_planning” application

You have to define the pipeline activity to transfer data from Azure Cosmos DB to the Azure SQL database.

Which of the following would go into Slot 1?

Case Study

Overview

A company currently works with the local transportation sector. The company is responsible for building solutions that will help in the improvement of traffic and safety.

Current Requirements

The company is currently managing the following systems:

Traffic sensors have been installed at different road junctions to monitor traffic. The sensors capture the following data:

• Time
• Location in terms of latitude and longitude
• Speed in km per hour
• The license plate number
• The length of the vehicle in meters

A sample of the data sent is shown below:

The traffic sensors will also capture images of the vehicle from time to time

Requirements

Below are the various requirements for the various systems:

The traffic sensor data

• The sensors must only be able to add items to a collection named “CompanySensorDt”
• The insertion rate of the data must be maximized
• Once every 2 months, traffic sensor data must be analyzed to check for any malfunctions
• The collection “CompanySensorDt” must reside in Cosmos DB
• The impact of the storing the vehicle images on the collection throughput must be minimized

The Company_track system

• This system should be able to report on data that is related to specific plate number.
• The report would come from the “CompanySensorDt” collection
• Business users must be able to filter on vehicles that drive over a specific speed limit

The Company_planning application

• The data for this application must be stored in an Azure SQL Database
• The data in the database would be sharded
• The data would be loaded from the “CompanySensorDt” collection once a week using Azure Data Factory
• A manual trigger would be used to transfer the data
• Security
• Azure Active Directory should be used for all services wherever possible
• The license plate information must not be visible in the “Company_planning” database
• If there is an unauthorized usage of the “Company_planning” database, the security team must be notified immediately
• Data must be stored for a maximum of 5 years

Other requirements

• Costs should be minimized wherever possible
• The reports for the “Company_track” application must execute as quickly as possible
• An SLA of 75% is permitted for the “Company_planning” application

You have to define the pipeline activity to transfer data from Azure Cosmos DB to the Azure SQL database.

Which of the following would go into Slot 2?

Case Study

Overview

A company currently works with the local transportation sector. The company is responsible for building solutions that will help in improvement of traffic and safety.

Current Requirements

The company is currently managing the following systems:

Traffic sensors have been installed at different road junctions to monitor traffic. The sensors capture the following data:

• Time
• Location in terms of latitude and longitude
• Speed in km per hour
• The license plate number
• The length of the vehicle in meters

A sample of the data sent is shown below:

The traffic sensors will also capture images of the vehicle from time to time

Requirements

Below are the various requirements for the various systems:

The traffic sensor data

• The sensors must only be able to add items to a collection named “CompanySensorDt”
• The insertion rate of the data must be maximized
• Once every 2 months, traffic sensor data must be analyzed to check for any malfunctions
• The collection “CompanySensorDt” must reside in Cosmos DB
• The impact of the storing the vehicle images on the collection throughput must be minimized

The Company_track system

• This system should be able to report on data that is related to specific plate number.
• The report would come from the “CompanySensorDt” collection
• Business users must be able to filter on vehicles that drive over a specific speed limit

The Company_planning application

• The data for this application must be stored in an Azure SQL Database
• The data in the database would be sharded
• The data would be loaded from the “CompanySensorDt” collection once a week using Azure Data Factory
• A manual trigger would be used to transfer the data
• Security
• Azure Active Directory should be used for all services wherever possible
• The license plate information must not be visible in the “Company_planning” database
• If there is an unauthorized usage of the “Company_planning” database, the security team must be notified immediately
• Data must be stored for a maximum of 5 years

Other requirements

• Costs should be minimized wherever possible
• The reports for the “Company_track” application must execute as quickly as possible
• An SLA of 75% is permitted ofor the “Company_planning” application

You have to ensure that the following requirement is met for the “Company_Response” application “Whenever there are any sudden changes in the traffic, a response team needs to be immediately notified”

Which of the following would go into Slot 1?

Case Study

Overview

A company currently works with the local transportation sector. The company is responsible for building solutions that will help in the improvement of traffic and safety.

Current Requirements

The company is currently managing the following systems:

Traffic sensors have been installed at different road junctions to monitor traffic. The sensors capture the following data:

• Time
• Location in terms of latitude and longitude
• Speed in km per hour
• The license plate number
• The length of the vehicle in meters

A sample of the data sent is shown below:

The traffic sensors will also capture images of the vehicle from time to time

Requirements

Below are the various requirements for the various systems:

The traffic sensor data

• The sensors must only be able to add items to a collection named “CompanySensorDt”
• The insertion rate of the data must be maximized
• Once every 2 months, traffic sensor data must be analyzed to check for any malfunctions
• The collection “CompanySensorDt” must reside in Cosmos DB
• The impact of the storing the vehicle images on the collection throughput must be minimized

The Company_track system

• This system should be able to report on data that is related to specific plate number.
• The report would come from the “CompanySensorDt” collection
• Business users must be able to filter on vehicles that drive over a specific speed limit

The Company_planning application

• The data for this application must be stored in an Azure SQL Database
• The data in the database would be sharded
• The data would be loaded from the “CompanySensorDt” collection once a week using Azure Data Factory
• A manual trigger would be used to transfer the data
• Security
• Azure Active Directory should be used for all services wherever possible
• The license plate information must not be visible in the “Company_planning” database
• If there is an unauthorized usage of the “Company_planning” database, the security team must be notified immediately
• Data must be stored for a maximum of 5 years

Other requirements

• Costs should be minimized wherever possible
• The reports for the “Company_track” application must execute as quickly as possible
• An SLA of 75% is permitted for the “Company_planning” application

You have to ensure that the following requirement is met for the “Company_Response” application. “Whenever there are any sudden changes in the traffic, a response team needs to be immediately notified”

Which of the following would go into Slot 2?

Case study

Overview

A company currently works with the local transportation sector. The company is responsible for building solutions that will help in the improvement of traffic and safety.

Current Requirements

The company is currently managing the following systems:

Traffic sensors have been installed at different road junctions to monitor traffic. The sensors capture the following data:

• Time
• Location in terms of latitude and longitude
• Speed in km per hour
• The license plate number
• The length of the vehicle in meters

A sample of the data sent is shown below:

The traffic sensors will also capture images of the vehicle from time to time

Requirements

Below are the various requirements for the various systems:

The traffic sensor data

• The sensors must only be able to add items to a collection named “CompanySensorDt”
• The insertion rate of the data must be maximized
• Once every 2 months, traffic sensor data must be analyzed to check for any malfunctions
• The collection “CompanySensorDt” must reside in Cosmos DB
• The impact of the storing the vehicle images on the collection throughput must be minimized

The Company_track system

• This system should be able to report on data that is related to specific plate number.
• The report would come from the “CompanySensorDt” collection
• Business users must be able to filter on vehicles that drive over a specific speed limit

The Company_planning application

• The data for this application must be stored in an Azure SQL Database
• The data in the database would be sharded
• The data would be loaded from the “CompanySensorDt” collection once a week using Azure Data Factory
• A manual trigger would be used to transfer the data
• Security
• Azure Active Directory should be used for all services wherever possible
• The license plate information must not be visible in the “Company_planning” database
• If there is an unauthorized usage of the “Company_planning” database, the security team must be notified immediately
• Data must be stored for a maximum of 5 years

Other requirements

• Costs should be minimized wherever possible
• The reports for the “Company_track” application must execute as quickly as possible
• An SLA of 75% is permitted for the “Company_planning” application

You need to ensure that the performance requirements are met for The Company_track system application. Which of the following could be used to fulfill this requirement?

Case Study

Overview

A company currently works with the local transportation sector. The company is responsible for building solutions that will help in the improvement of traffic and safety.

Current Requirements

The company is currently managing the following systems:

Traffic sensors have been installed at different road junctions to monitor traffic. The sensors capture the following data:

• Time
• Location in terms of latitude and longitude
• Speed in km per hour
• The license plate number
• The length of the vehicle in meters

A sample of the data sent is shown below:

The traffic sensors will also capture images of the vehicle from time to time

Requirements

Below are the various requirements for the various systems:

The traffic sensor data

• The sensors must only be able to add items to a collection named “CompanySensorDt”
• The insertion rate of the data must be maximized
• Once every 2 months, traffic sensor data must be analyzed to check for any malfunctions
• The collection “CompanySensorDt” must reside in Cosmos DB
• The impact of the storing the vehicle images on the collection throughput must be minimized

The Company_track system

• This system should be able to report on data that is related to specific plate number.
• The report would come from the “CompanySensorDt” collection
• Business users must be able to filter on vehicles that drive over a specific speed limit

The Company_planning application

• The data for this application must be stored in an Azure SQL Database
• The data in the database would be sharded
• The data would be loaded from the “CompanySensorDt” collection once a week using Azure Data Factory
• A manual trigger would be used to transfer the data
• Security
• Azure Active Directory should be used for all services wherever possible
• The license plate information must not be visible in the “Company_planning” database
• If there is an unauthorized usage of the “Company_planning” database, the security team must be notified immediately
• Data must be stored for a maximum of 5 years

Other requirements

• Costs should be minimized wherever possible
• The reports for the “Company_track” application must execute as quickly as possible
• An SLA of 75% is permitted for the “Company_planning” application

You have to ensure that the authentication and authorization for the devices sending data to Cosmos DB is set up correctly. Which of the following would you use for authentication?

Case Study

Overview

A company currently works with the local transportation sector. The company is responsible for building solutions that will help in the improvement of traffic and safety.

Current Requirements

The company is currently managing the following systems:

Traffic sensors have been installed at different road junctions to monitor traffic. The sensors capture the following data:

• Time
• Location in terms of latitude and longitude
• Speed in km per hour
• The license plate number
• The length of the vehicle in meters

A sample of the data sent is shown below:

The traffic sensors will also capture images of the vehicle from time to time

Requirements

Below are the various requirements for the various systems:

The traffic sensor data

• The sensors must only be able to add items to a collection named “CompanySensorDt”
• The insertion rate of the data must be maximized
• Once every 2 months, traffic sensor data must be analyzed to check for any malfunctions
• The collection “CompanySensorDt” must reside in Cosmos DB
• The impact of the storing the vehicle images on the collection throughput must be minimized

The Company_track system

• This system should be able to report on data that is related to specific plate number.
• The report would come from the “CompanySensorDt” collection
• Business users must be able to filter on vehicles that drive over a specific speed limit

The Company_planning application

• The data for this application must be stored in an Azure SQL Database
• The data in the database would be sharded
• The data would be loaded from the “CompanySensorDt” collection once a week using Azure Data Factory
• A manual trigger would be used to transfer the data
• Security
• Azure Active Directory should be used for all services wherever possible
• The license plate information must not be visible in the “Company_planning” database
• If there is an unauthorized usage of the “Company_planning” database, the security team must be notified immediately
• Data must be stored for a maximum of 5 years

Other requirements

• Costs should be minimized wherever possible
• The reports for the “Company_track” application must execute as quickly as possible
• An SLA of 75% is permitted for the “Company_planning” application

You have to ensure that the authentication and authorization for the devices sending data to Cosmos DB is set up correctly. Which of the following would you use for authentication?

Your company needs to set a Cosmos DB database. An application would be connecting and using the database. The application always needs to see the latest committed write. You need to decide on the ideal consistency level for the database. You decide to set the consistency level to Consistent Prefix.
Would this fulfill the requirement?

Your company needs to set a Cosmos DB database. An application would be connecting and using the database. The application always needs to see the latest committed write. You need to decide on the ideal consistency level for the database. You decide to set the consistency level to Consistent Prefix.
Would this fulfill the requirement?

Your company needs to set a Cosmos DB database. An application would be connecting and using the database. The application always needs to see the latest committed write. You need to decide on the ideal consistency level for the database. You decide to set the consistency level to Strong.
Would this fulfill the requirement?

A company is developing an end-to-end stream processing pipeline. The solution would be used to collect data for a taxi service. The taxi service would send data for each ride. The data being sent is as follows.
• The duration
• The distance
• The pickup and dropoff locations
The solution should allow us to calculate the average tip per mile driven in real-time.

Which of the following would you recommend using for Service 1?

A company is developing an end-to-end stream processing pipeline. The solution would be used to collect data for a taxi service. The taxi service would send data for each ride. The data being sent is as follows.
• The duration
• The distance
• The pickup and dropoff locations
The solution should allow us to calculate the average tip per mile driven in real-time. Below is the architecture diagram. You have to recommend appropriate services for each stage of the architecture.

Which of the following would you recommend using for Service 2?

A company is developing an end-to-end stream processing pipeline. The solution would be used to collect data for a taxi service. The taxi service would send data for each ride. The data being sent is as follows.
• The duration
• The distance
• The pickup and dropoff locations
The solution should allow us to calculate the average tip per mile driven in real-time. Below is the architecture diagram. You have to recommend appropriate services for each stage of the architecture.

Which of the following would you recommend using for Service 3?

Your company wants to set up an Azure SQL data warehouse. Data would be loaded weekly from an Azure SQL database instance. You have to advise on recommendations based on the following security requirements for the data warehouse.
• You have to ensure that data engineers can only connect from there on-premises workstations.
• You have to ensure that the right authentication and authorization measures are put in place.
• You have to ensure that the data is encrypted at rest.
Which of the following would you recommend for the requirement?
“You have to ensure data engineers can only connect from their on-premises workstations.”
Which of the following port must be enabled on the firewall for the data engineer’s workstation?

Your company wants to set up an Azure SQL data warehouse. Data would be loaded weekly from an Azure SQL database instance. You have to advise on recommendations based on the following security requirements for the data warehouse.
• You have to ensure that data engineers can only connect from their on-premise workstations.
• You have to ensure that the right authentication and authorization measures are put in place.
• You have to ensure that the data is encrypted at rest.
Which of the following would you recommend for the requirement?
“You have to ensure the right authentication and authorization measures are put in place.”
Which of the following technique would you use to provide authorization to the SOL data warehouse?

Your company wants to set up an Azure SQL data warehouse. Data would be loaded weekly from an Azure SQL database instance. You have to advise on recommendations based on the following security requirements for the data warehouse.
• You have to ensure data engineers can only connect from their on-premise workstations.
• You have to ensure the right authentication and authorization measures are put in place.
• You have to ensure the data is encrypted at rest.
Which of the following would you recommend for the requirement?
“You have to ensure the data is encrypted at rest.”

A company wants to migrate a set of on-premises Microsoft SQL Server databases to Azure. Below are the requirements for each database server.
• ipslabsrv1 – This database server has a collection of databases that are using a set of shared resources.
• ipslabsrv2 – This database server is hosting a single database. The company wants to ensure a simple lift-and-shift migration for this database.
• ipslabsrv3 – This server hosts 2 databases. The company wants to have complete control over the underlying database server.
• ipslabsrv4 – This server hosts a database that has a current size of 8 TB.
You have to recommend the right technology in Azure for each server ensuring costs are kept in check.
Which of the following would you recommend for ipslabsrv1?

A company wants to migrate a set of on-premises Microsoft SQL Server databases to Azure. Below are the requirements for each database server.
• ipslabsrv1 – This database server has a collection of databases that are using a set of shared resources.
• ipslabsrv2 – This database server is hosting a single database. The company wants to ensure a simple lift-and-shift migration for this database.
• ipslabsrv3 – This server hosts 2 databases. The company wants to have complete control over the underlying database server.
• ipslabsrv4 – This server hosts a database that has a current size of 8 TB.
You have to recommend the right technology in Azure for each server ensuring costs are kept in check.
Which of the following would you recommend for ipslabsrv2?

A company wants to migrate a set of on-premises Microsoft SQL Server databases to Azure. Below are the requirements for each database server.
• ipslabsrv1 – This database server has a collection of databases that are using a set of shared resources.
• ipslabsrv2 – This database server is hosting a single database. The company wants to ensure a simple lift-and-shift migration for this database.
• ipslabsrv3 – This server hosts 2 databases. The company wants to have complete control over the underlying database server.
• ipslabsrv4 – This server hosts a database that has a current size of 8 TB.
You have to recommend the right technology in Azure for each server. ensuring costs are kept in check.
Which of the following would you recommend for ipslabsrv3?

A company wants to migrate a set of on-premises Microsoft SQL Server databases to Azure. Below are the requirements for each database server.
• ipslabsrv1 – This database server has a collection of databases that are using a set of shared resources.
• ipslabsrv2 – This database server is hosting a single database. The company wants to ensure a simple lift-and-shift migration for this database.
• ipslabsrv3 – This server hosts 2 databases. The company wants to have complete control over the underlying database server.
• ipslabsrv4 – This server hosts a database which has a current size of 8 TB
You have to recommend the right technology in Azure for each server ensuring costs are kept in check.
Which of the following would you recommend for ipslabsrv4?

A company has an Azure SQL database. The database contains tables that have masked columns. The company wants to identify when a user tries to attempt to access the data from any one of the masked columns. Which of the following would you use for this requirement?

A company has an Azure SQL Data Warehouse defined as part of its Azure subscription. The company wants to ensure that its support department gets an alert when the Data Warehouse consumes the maximum allotted resources to it? Which of the following would they use as the resource type when configuring the alert in Azure Monitor?

A company has an Azure SQL Data Warehouse defined as part of its Azure subscription. The company wants to ensure that its support department gets an alert when the Data Warehouse consumes the maximum allotted resources. Which of the following would you use as the signal type for the alert?

A company has an Azure SQL Database defined as part of its Azure subscription. The Automatic tuning settings are configured. as shown below.

Would the setting of “Force Plan” be ON for the database?

A company has an Azure SOL Database defined as part of its Azure subscription. The Automatic tuning settings are configured as shown below.

Would the setting of “Create Index” be ON for the database?