Data Engineering on Microsoft Azure Test 5

Ingest data from an on-premise SQL Server
Create pipelines that can integrate data and also run notebooks
Be able to develop notebooks that can be used to transform data
Be able to load the data into a massive parallel processing data for analysis
Which of the following would you use as the service to store the transformed data?

Select 1 option(s):

You have to ensure storage is optimized
You decide to ensure that files are smaller than 250 MB
Would this fulfil the requirement?

Select 1 option(s):

You have to ensure storage is optimized
You decide to ensure the files stored are larger than 250 MB
Would this fulfil the requirement?

Select 1 option(s):

You have to ensure storage is optimized
You decide to implement compaction jobs to combine the smaller files into larger files.
Would this fulfil the requirement?

Select 1 option(s):

A company is responsible for designing a new data engineering solution. The solution would be used by a media company that has offices in the following locations

• New York
• Manchester
• Singapore
• Melbourne

Current environment:

• The current solution stores millions of images on a physical server that is located in the New York office.
• Around 2 TB of images are added every day
• Currently the images are not being organized properly
• It becomes difficult to search for images
• The images need to have object and color tags generated
• The tags are stored in a document database that is queries by SQL
• The New York office also has a Microsoft SQL Server database that stores customer data

Proposed environment:

• All of the images and any customer data needs to be transferred to Azure.
• On-premise servers need to be decommissioned
• A proper analytical processing solution must be in place for customer related data
• There should be a proper image object and color tagging solution in place
• All expenses must be minimized
• The tagging data must be uploaded from the New York Office location
• Tagging data must be replicated to regions where other offices are located
• The customer data must be analyzed using Spark clusters
• The cluster should allow for parallel processing of data
• Power BI must be used to visualize transformed customer data
• There should be a facility to backup data if disaster recovery is required
• All the data in the cloud must be encrypted at rest and in transit
• Images must be replicated globally

You have to choose the right service for storing image tagging data. Which of the following should be used to fulfil this requirement?

Select 1 option(s):

A company is responsible for designing a new data engineering solution. The solution would be used by a media company that has offices in the following locations

• New York
• Manchester
• Singapore
• Melbourne

Current environment:

• The current solution stores millions of images on a physical server that is located in the New York office.
• Around 2 TB of images are added every day
• Currently the images are not being organized properly
• It becomes difficult to search for images
• The images need to have object and color tags generated
• The tags are stored in a document database that is queries by SQL
• The New York office also has a Microsoft SQL Server database that stores customer data

Proposed environment:

• All of the images and any customer data needs to be transferred to Azure.
• On-premise servers need to be decommissioned
• A proper analytical processing solution must be in place for customer related data
• There should be a proper image object and color tagging solution in place
• All expenses must be minimized
• The tagging data must be uploaded from the New York Office location
• Tagging data must be replicated to regions where other offices are located
• The customer data must be analyzed using Spark clusters
• The cluster should allow for parallel processing of data
• Power BI must be used to visualize transformed customer data
• There should be a facility to backup data if disaster recovery is required
• All the data in the cloud must be encrypted at rest and in transit
• Images must be replicated globally

You need to ensure the following requirement is met
“A proper analytical processing solution must be in place for customer related data”
Which of the following would you use for this requirement?

Select 1 option(s):

A company is responsible for designing a new data engineering solution. The solution would be used by a media company that has offices in the following locations

• New York
• Manchester
• Singapore
• Melbourne

Current environment:

• The current solution stores millions of images on a physical server that is located in the New York office.
• Around 2 TB of images are added every day
• Currently the images are not being organized properly
• It becomes difficult to search for images
• The images need to have object and color tags generated
• The tags are stored in a document database that is queries by SQL
• The New York office also has a Microsoft SQL Server database that stores customer data

Proposed environment:

• All of the images and any customer data needs to be transferred to Azure.
• On-premise servers need to be decommissioned
• A proper analytical processing solution must be in place for customer related data
• There should be a proper image object and color tagging solution in place
• All expenses must be minimized
• The tagging data must be uploaded from the New York Office location
• Tagging data must be replicated to regions where other offices are located
• The customer data must be analyzed using Spark clusters
• The cluster should allow for parallel processing of data
• Power BI must be used to visualize transformed customer data
• There should be a facility to backup data if disaster recovery is required
• All the data in the cloud must be encrypted at rest and in transit
• Images must be replicated globally

A company is responsible for designing a new data engineering solution. The solution would be used by a media company that has offices in the following locations

• New York
• Manchester
• Singapore
• Melbourne

Current environment:

• The current solution stores millions of images on a physical server that is located in the New York office.
• Around 2 TB of images are added every day
• Currently the images are not being organized properly
• It becomes difficult to search for images
• The images need to have object and color tags generated
• The tags are stored in a document database that is queries by SQL
• The New York office also has a Microsoft SQL Server database that stores customer data

Proposed environment:

• All of the images and any customer data needs to be transferred to Azure.
• On-premise servers need to be decommissioned
• A proper analytical processing solution must be in place for customer related data
• There should be a proper image object and color tagging solution in place
• All expenses must be minimized
• The tagging data must be uploaded from the New York Office location
• Tagging data must be replicated to regions where other offices are located
• The customer data must be analyzed using Spark clusters
• The cluster should allow for parallel processing of data
• Power BI must be used to visualize transformed customer data
• There should be a facility to backup data if disaster recovery is required
• All the data in the cloud must be encrypted at rest and in transit
• Images must be replicated globally

You need to meet the storage requirements for the image tagging data. Which of the following would you configure for the data store in the New York location?

Select 1 option(s):

A company is responsible for designing a new data engineering solution. The solution would be used by a media company that has offices in the following locations

• New York
• Manchester
• Singapore
• Melbourne

Current environment:

• The current solution stores millions of images on a physical server that is located in the New York office.
• Around 2 TB of images are added every day
• Currently the images are not being organized properly
• It becomes difficult to search for images
• The images need to have object and color tags generated
• The tags are stored in a document database that is queries by SQL
• The New York office also has a Microsoft SQL Server database that stores customer data

Proposed environment:

• All of the images and any customer data needs to be transferred to Azure.
• On-premise servers need to be decommissioned
• A proper analytical processing solution must be in place for customer related data
• There should be a proper image object and color tagging solution in place
• All expenses must be minimized
• The tagging data must be uploaded from the New York Office location
• Tagging data must be replicated to regions where other offices are located
• The customer data must be analyzed using Spark clusters
• The cluster should allow for parallel processing of data
• Power BI must be used to visualize transformed customer data
• There should be a facility to backup data if disaster recovery is required
• All the data in the cloud must be encrypted at rest and in transit
• Images must be replicated globally

You have to ensure the security requirements are met for the tagging data. Which of the following would you implement for this requirement?

Select 1 option(s):

A company is responsible for designing a new data engineering solution. The solution would be used by a media company that has offices in the following locations

• New York
• Manchester
• Singapore
• Melbourne

Current environment:

• The current solution stores millions of images on a physical server that is located in the New York office.
• Around 2 TB of images are added every day
• Currently the images are not being organized properly
• It becomes difficult to search for images
• The images need to have object and color tags generated
• The tags are stored in a document database that is queries by SQL
• The New York office also has a Microsoft SQL Server database that stores customer data

Proposed environment:

• All of the images and any customer data needs to be transferred to Azure.
• On-premise servers need to be decommissioned
• A proper analytical processing solution must be in place for customer related data
• There should be a proper image object and color tagging solution in place
• All expenses must be minimized
• The tagging data must be uploaded from the New York Office location
• Tagging data must be replicated to regions where other offices are located
• The customer data must be analyzed using Spark clusters
• The cluster should allow for parallel processing of data
• Power BI must be used to visualize transformed customer data
• There should be a facility to backup data if disaster recovery is required
• All the data in the cloud must be encrypted at rest and in transit
• Images must be replicated globally

You have to ensure the security requirements are met for the customer data. Which of the following would you implement for this requirement?

Select 1 option(s):

A company is responsible for designing a new data engineering solution. The solution would be used by a media company that has offices in the following locations

• New York
• Manchester
• Singapore
• Melbourne

Current environment:

• The current solution stores millions of images on a physical server that is located in the New York office.
• Around 2 TB of images are added every day
• Currently the images are not being organized properly
• It becomes difficult to search for images
• The images need to have object and color tags generated
• The tags are stored in a document database that is queries by SQL
• The New York office also has a Microsoft SQL Server database that stores customer data

Proposed environment:

• All of the images and any customer data needs to be transferred to Azure.
• On-premise servers need to be decommissioned
• A proper analytical processing solution must be in place for customer related data
• There should be a proper image object and color tagging solution in place
• All expenses must be minimized
• The tagging data must be uploaded from the New York Office location
• Tagging data must be replicated to regions where other offices are located
• The customer data must be analyzed using Spark clusters
• The cluster should allow for parallel processing of data
• Power BI must be used to visualize transformed customer data
• There should be a facility to backup data if disaster recovery is required
• All the data in the cloud must be encrypted at rest and in transit
• Images must be replicated globally

You need to comply with the following requirement for the customer data
“There should be a facility to backup data if disaster recovery is required”
Which of the following would you implement for this requirement?

Select 1 option(s):

A company is responsible for designing a new data engineering solution. The solution would be used by a media company that has offices in the following locations

• New York
• Manchester
• Singapore
• Melbourne

Current environment:

• The current solution stores millions of images on a physical server that is located in the New York office.
• Around 2 TB of images are added every day
• Currently the images are not being organized properly
• It becomes difficult to search for images
• The images need to have object and color tags generated
• The tags are stored in a document database that is queries by SQL
• The New York office also has a Microsoft SQL Server database that stores customer data

Proposed environment:

• All of the images and any customer data needs to be transferred to Azure.
• On-premise servers need to be decommissioned
• A proper analytical processing solution must be in place for customer related data
• There should be a proper image object and color tagging solution in place
• All expenses must be minimized
• The tagging data must be uploaded from the New York Office location
• Tagging data must be replicated to regions where other offices are located
• The customer data must be analyzed using Spark clusters
• The cluster should allow for parallel processing of data
• Power BI must be used to visualize transformed customer data
• There should be a facility to backup data if disaster recovery is required
• All the data in the cloud must be encrypted at rest and in transit
• Images must be replicated globally

You need to decide on a storage solution for the images. Which of the following would you choose for this requirement?

Select 1 option(s):

A company is responsible for designing a new data engineering solution. The solution would be used by a media company that has offices in the following locations

• New York
• Manchester
• Singapore
• Melbourne

Current environment:

• The current solution stores millions of images on a physical server that is located in the New York office.
• Around 2 TB of images are added every day
• Currently the images are not being organized properly
• It becomes difficult to search for images
• The images need to have object and color tags generated
• The tags are stored in a document database that is queries by SQL
• The New York office also has a Microsoft SQL Server database that stores customer data

Proposed environment:

• All of the images and any customer data needs to be transferred to Azure.
• On-premise servers need to be decommissioned
• A proper analytical processing solution must be in place for customer related data
• There should be a proper image object and color tagging solution in place
• All expenses must be minimized
• The tagging data must be uploaded from the New York Office location
• Tagging data must be replicated to regions where other offices are located
• The customer data must be analyzed using Spark clusters
• The cluster should allow for parallel processing of data
• Power BI must be used to visualize transformed customer data
• There should be a facility to backup data if disaster recovery is required
• All the data in the cloud must be encrypted at rest and in transit
• Images must be replicated globally

You need to allow users from the on-premise network to access the Azure SQL database. Which of the following would you set for this requirement?

Select 1 option(s):

Datastore1 – This data store must be able to store JSON related data. It must also have the ability to replicate data to multiple regions
Datastore2 – This would behave as an OLTP store
Datastore3 – On this data store , one should be able to run queries across petabytes of data
Datastore4 – This store should be able to ingest large amounts of images per day
Which of the following technology would you use for Datastore1?

Select 1 option(s):

Datastore1 – This data store must be able to store JSON related data. It must also have the ability to replicate data to multiple regions
Datastore2 – This would behave as an OLTP store
Datastore3 – On this data store , one should be able to run queries across petabytes of data
Datastore4 – This store should be able to ingest large amounts of images per day
Which of the following technology would you use for Datastore2?

Select 1 option(s):

Datastore1 – This data store must be able to store JSON related data. It must also have the ability to replicate data to multiple regions
Datastore2 – This would behave as an OLTP store
Datastore3 – On this data store , one should be able to run queries across petabytes of data
Datastore4 – This store should be able to ingest large amounts of images per day
Which of the following technology would you use for Datastore3?

Select 1 option(s):

Datastore1 – This data store must be able to store JSON related data. It must also have the ability to replicate data to multiple regions
Datastore2 – This would behave as an OLTP store
Datastore3 – On this data store , one should be able to run queries across petabytes of data
Datastore4 – This store should be able to ingest large amounts of images per day
Which of the following technology would you use for Datastore4?

Select 1 option(s):

The company decides to create a Standard cluster
Would this fulfil the requirement?

Select 1 option(s):

The company decides to create a High concurrency cluster
Would this fulfil the requirement?

Select 1 option(s):

The company decides to create a Premium cluster
Would this fulfil the requirement?

Select 1 option(s):

The overall architecture is given below

Azure Event Hubs would be used to ingest data from multiple devices.
The data needs to be processed by Service A and sent to a relational store services by Service B
Every month, an ETL service (Service C) needs to run and store the output data in a columnar data store hosted by Service D
Which of the following would you use as Service A?

Select 1 option(s):

The overall architecture is given below

Azure Event Hubs would be used to ingest data from multiple devices.
The data needs to be processed by Service A and sent to a relational store services by Service B
Every month, an ETL service (Service C) needs to run and store the output data in a columnar data store hosted by Service D
Which of the following would you use as Service B?

Select 1 option(s):

The overall architecture is given below

Azure Event Hubs would be used to ingest data from multiple devices.
The data needs to be processed by Service A and sent to a relational store services by Service B
Every month, an ETL service (Service C) needs to run and store the output data in a columnar data store hosted by Service D
Which of the following would you use as Service C?

Select 1 option(s):

The overall architecture is given below

Azure Event Hubs would be used to ingest data from multiple devices.
The data needs to be processed by Service A and sent to a relational store services by Service B
Every month, an ETL service (Service C) needs to run and store the output data in a columnar data store hosted by Service D
Which of the following would you use as Service D?

Select 1 option(s):

The company database administrator decides to add classifications to the columns that contain sensitive data. Auditing is also turned on for the database.
Would this fulfil the requirement?

Select 1 option(s):

The company database administrator decides to create a SELECT trigger on the table in the database. This trigger will write data to a new table in the database. A stored procedure would then be executed to look up column classifications and perform joins.
Would this fulfil the requirement?

Select 1 option(s):

The company decides to implement Transparent Data Encryption
Would this fulfil the requirement?

Select 1 option(s):

Which of the following is the first type of backup that is taken by the service?

Select 1 option(s):

Which of the following is the third type of backup that is taken by the service?

Select 1 option(s):

Which of the following is the first type of backup that is taken by the service?

Select 1 option(s):

Which of the following would you use for the monitoring of jobs?

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

Department A – Here the cluster must be optimized for ad hoc HVE queries
Department B – Here the cluster must be optimized for HVE queries that are used in batch processes
Which of the following would you use as the cluster type for Department A?

Select 1 option(s):

Department A – Here the cluster must be optimized for ad hoc HVE queries
Department B – Here the cluster must be optimized for HVE queries that are used in batch processes
Which of the following would you use as the cluster type for Department B?

Select 1 option(s):

Select 1 option(s):

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

Select 2 option(s):

Select 2 option(s):

skillcertlab_sales
The table would be 500 GB in size
A column named SalesDate would be used extensively in the WHERE clause in queries
A column named SalesProduct would be used extensively in JOIN operations
A column named SalesRegion is used for grouping
Around 75% of the records are related to one of the 40 region values of the SalesRegion column
skillcertlab_invoice
The table would be 6 GB in size
A column named SalesDate and SalesProduct would be used extensively in the WHERE clause in queries
A column named SalesRegion is used for grouping
You need to ensure query performance is optimized for each table.
Which of the following would you use as the Distribution column for the skillcertlab_sales table?

Select 1 option(s):

skillcertlab_sales
The table would be 500 GB in size
A column named SalesDate would be used extensively in the WHERE clause in queries
A column named SalesProduct would be used extensively in JOIN operations
A column named SalesRegion is used for grouping
Around 75% of the records are related to one of the 40 region values of the SalesRegion column
skillcertlab_invoice
The table would be 6 GB in size
A column named SalesDate and SalesProduct would be used extensively in the WHERE clause in queries
A column named SalesRegion is used for grouping
You need to ensure query performance is optimized for each table.
Which of the following would you use as the Distribution type for the skillcertlab_invoice table?

Select 1 option(s):

skillcertlab_sales
The table would be 500 GB in size
A column named SalesDate would be used extensively in the WHERE clause in queries
A column named SalesProduct would be used extensively in JOIN operations
A column named SalesRegion is used for grouping
Around 75% of the records are related to one of the 40 region values of the SalesRegion column
skillcertlab_invoice
The table would be 6 GB in size
A column named SalesDate and SalesProduct would be used extensively in the WHERE clause in queries
A column named SalesRegion is used for grouping
You need to ensure query performance is optimized for each table.
Which of the following would you use as the Distribution column for the skillcertlab_invoice table?

Select 1 option(s):

Select 1 option(s):

Information on course sales group by course category and price range
Reflect new course purchases
Ensure optimal performance
Which of the following can be used as the technology used for data abstraction?

Select 1 option(s):

You decide to separate the data into shards and use horizontal partitioning
Would this fulfil the requirement?

Select 1 option(s):

You decide to separate the data into regions by using horizontal partitioning
Would this fulfil the requirement?

Select 1 option(s):

You decide to separate the data into regions by using vertical partitioning
Would this fulfil the requirement?

Select 1 option(s):

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

{

“time” : “2019-10-15T22:15:25.72511745”,

“location” : {

“type” : “Point”,

“coordinates”:[ 22.4, 2.4] },

“speed” : 44.5,

“plate_number” : “22333W”,

“length” : 5.2

}

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 data 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?

Select 1 option(s):

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

{

“time” : “2019-10-15T22:15:25.72511745”,

“location” : {

“type” : “Point”,

“coordinates”:[ 22.4, 2.4] },

“speed” : 44.5,

“plate_number” : “22333W”,

“length” : 5.2

}

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 data 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 sharding for the database in Azure SQL databases. Which of the following column could be used for sharding the data?

Select 1 option(s):

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

{

“time” : “2019-10-15T22:15:25.72511745”,

“location” : {

“type” : “Point”,

“coordinates”:[ 22.4, 2.4] },

“speed” : 44.5,

“plate_number” : “22333W”,

“length” : 5.2

}

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 data 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.

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

Select 1 option(s):

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

{

“time” : “2019-10-15T22:15:25.72511745”,

“location” : {

“type” : “Point”,

“coordinates”:[ 22.4, 2.4] },

“speed” : 44.5,

“plate_number” : “22333W”,

“length” : 5.2

}

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 data 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.

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

Select 1 option(s):

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

{

“time” : “2019-10-15T22:15:25.72511745”,

“location” : {

“type” : “Point”,

“coordinates”:[ 22.4, 2.4] },

“speed” : 44.5,

“plate_number” : “22333W”,

“length” : 5.2

}

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 data 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 “Company_planning” database. You decide to include a clustered columnstore index to improve performance. Is this an ideal implementation?

Select 1 option(s):

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

{

“time” : “2019-10-15T22:15:25.72511745”,

“location” : {

“type” : “Point”,

“coordinates”:[ 22.4, 2.4] },

“speed” : 44.5,

“plate_number” : “22333W”,

“length” : 5.2

}

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 data 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 “Company_planning” database. You decide to include an index on the plate number to improve performance. Is this an ideal implementation?

Select 1 option(s):

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

{

“time” : “2019-10-15T22:15:25.72511745”,

“location” : {

“type” : “Point”,

“coordinates”:[ 22.4, 2.4] },

“speed” : 44.5,

“plate_number” : “22333W”,

“length” : 5.2

}

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 data 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 ensure 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?

Select 1 option(s):

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

{

“time” : “2019-10-15T22:15:25.72511745”,

“location” : {

“type” : “Point”,

“coordinates”:[ 22.4, 2.4] },

“speed” : 44.5,

“plate_number” : “22333W”,

“length” : 5.2

}

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 data 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 ensure 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?

Select 1 option(s):

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

{

“time” : “2019-10-15T22:15:25.72511745”,

“location” : {

“type” : “Point”,

“coordinates”:[ 22.4, 2.4] },

“speed” : 44.5,

“plate_number” : “22333W”,

“length” : 5.2

}

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 data 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 need to ensure the performance requirements are met for the The Company_track system application. Which of the following could be used to fulfil this requirement?

Select 1 option(s):

The duration
The distance
The pickup and dropoff locations
The solution should allow to calculate the average tip per mile driven in real time.
Below is the architecture diagram. You have to recommend on appropriate services for each stage of the architecture

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

Select 1 option(s):

The duration
The distance
The pickup and dropoff locations
The solution should allow to calculate the average tip per mile driven in real time.
Below is the architecture diagram. You have to recommend on appropriate services for each stage of the architecture

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

Select 1 option(s):

The duration
The distance
The pickup and dropoff locations
The solution should allow to calculate the average tip per mile driven in real time.
Below is the architecture diagram. You have to recommend on appropriate services for each stage of the architecture

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

Select 1 option(s):

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 data engineers can only connect from their on-premise workstations”
Which of the following port must be enabled on the firewall for the data engineer’s workstation?

Select 1 option(s):

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 right authentication and authorization measures are put in place”
Which of the following technique would you use to provide authorization to the SQL data warehouse?

Select 1 option(s):

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”

Select 1 option(s):

skillcertlabsrv1 – This database server has a collection of databases that are using a set of shared resources.
skillcertlabsrv2 – This database server is hosting a single database. The company wants to ensure a simple lift-and-shift migration for this database.
skillcertlabsrv3 – This server hosts 2 databases. The company wants to have complete control over the underlying database server
skillcertlabsrv4 – 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 skillcertlabsrv1?

Select 1 option(s):

skillcertlabsrv1 – This database server has a collection of databases that are using a set of shared resources.
skillcertlabsrv2 – This database server is hosting a single database. The company wants to ensure a simple lift-and-shift migration for this database.
skillcertlabsrv3 – This server hosts 2 databases. The company wants to have complete control over the underlying database server
skillcertlabsrv4 – 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 skillcertlabsrv2?

Select 1 option(s):

skillcertlabsrv1 – This database server has a collection of databases that are using a set of shared resources.
skillcertlabsrv2 – This database server is hosting a single database. The company wants to ensure a simple lift-and-shift migration for this database.
skillcertlabsrv3 – This server hosts 2 databases. The company wants to have complete control over the underlying database server
skillcertlabsrv4 – 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 skillcertlabsrv3?

Select 1 option(s):

skillcertlabsrv1 – This database server has a collection of databases that are using a set of shared resources.
skillcertlabsrv2 – This database server is hosting a single database. The company wants to ensure a simple lift-and-shift migration for this database.
skillcertlabsrv3 – This server hosts 2 databases. The company wants to have complete control over the underlying database server
skillcertlabsrv4 – 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 skillcertlabsrv4?

Select 1 option(s):