Data Engineering on Microsoft Azure Test 8

Select 1 option(s):

Select 2 option(s):

A company wants to use a set of services on Azure. They want to make use of Platform-as-a-service products to create a new data pipeline process. They have the following requirements:

Data Ingestion:

• This layer must provide access to multiple sources
• This layer must provide the ability to orchestrate a workflow
• It must also provide the capability to run SQL Server Integration Service packages

Storage:

• The storage layer must be optimized for Big Data workloads
• It must provide encryption of data at rest
• There must be no size constraints

Prepare and Train:

• This layer must provide a fully managed interactive workspace for exploration and visualization
• Here you should be able to program in R, SQL or Scala
• It must provide seamless user authentication with Azure Active Directory

Model and Service:

• This layer must provide support for SQL language
• It must implement native columnar storage

Which of the following should be used as a technology for the “Data Ingestion” layer?

Select 1 option(s):

A company wants to use a set of services on Azure. They want to make use of Platform-as-a-service products to create a new data pipeline process. They have the following requirements:

Data Ingestion:

• This layer must provide access to multiple sources
• This layer must provide the ability to orchestrate a workflow
• It must also provide the capability to run SQL Server Integration Service packages

Storage:

• The storage layer must be optimized for Big Data workloads
• It must provide encryption of data at rest
• There must be no size constraints

Prepare and Train:

• This layer must provide a fully managed interactive workspace for exploration and visualization
• Here you should be able to program in R, SQL or Scala
• It must provide seamless user authentication with Azure Active Directory

Model and Service:

• This layer must provide support for SQL language
• It must implement native columnar storage

Which of the following should be used as a technology for the “Storage” layer?

Select 1 option(s):

A company wants to use a set of services on Azure. They want to make use of Platform-as-a-service products to create a new data pipeline process. They have the following requirements:

Data Ingestion:

• This layer must provide access to multiple sources
• This layer must provide the ability to orchestrate a workflow
• It must also provide the capability to run SQL Server Integration Service packages

Storage:

• The storage layer must be optimized for Big Data workloads
• It must provide encryption of data at rest
• There must be no size constraints

Prepare and Train:

• This layer must provide a fully managed interactive workspace for exploration and visualization
• Here you should be able to program in R, SQL or Scala
• It must provide seamless user authentication with Azure Active Directory

Model and Service:

• This layer must provide support for SQL language
• It must implement native columnar storage

Which of the following should be used as a technology for the “Prepare and Train” layer?

Select 1 option(s):

A company wants to use a set of services on Azure. They want to make use of Platform-as-a-service products to create a new data pipeline process. They have the following requirements:

Data Ingestion:

• This layer must provide access to multiple sources
• This layer must provide the ability to orchestrate a workflow
• It must also provide the capability to run SQL Server Integration Service packages

Storage:

• The storage layer must be optimized for Big Data workloads
• It must provide encryption of data at rest
• There must be no size constraints

Prepare and Train:

• This layer must provide a fully managed interactive workspace for exploration and visualization
• Here you should be able to program in R, SQL or Scala
• It must provide seamless user authentication with Azure Active Directory

Model and Service:

• This layer must provide support for SQL language
• It must implement native columnar storage

Which of the following should be used as a technology for the “Model and Service” layer?

Select 1 option(s):

Select 1 option(s):

They decide to create an Azure Automation runbook which would be used to copy events.
Would this fulfil the requirement?

Select 1 option(s):

They decide to use the information that is stored in Azure Active Directory reports.
Would this fulfil the requirement?

Select 1 option(s):

They decide to configure Azure Data Lake Storage diagnostics to store the logs and metric data in a   storage account.
Would this fulfil the requirement?

Select 1 option(s):

Overview:

skillcertlabs is an online training provider.

Current Environment:

The company currently has Microsoft SQL databases that are split into different categories or tiers. Some of the databases are used by Internal users, some by external partners and external distributions.

Below is the list of applications, tiers and their individual requirements

• Applications – Tier – Replication – Comments
• Internal skillcertlab – 1 – Yes – NULL
• Internal skillcertlab – 2 – Using SQL Data Sync – NULL
• Internal Partner – 3 – Yes – Data is replicated to the Partner
• External skillcertlab – 4,5,6 – Yes
• External Partner – 7,8 – No – This is a Partner managed database
• Internal Distribution and Sales – 9 – Yes, but only when the data is ingested at one of the branch offices – Data is ingested from skillcertlab branch offices
• External Distribution and Sales – 10 – Yes, but only once the data is ingested at the skillcertlab main office – Data is ingested from multiple sources

Below are the current requirements of the company:

• The databases in Tier 3, Tier 6 to 8 must use a database density on the same server and Elastic pools in cost effective manner
• The Applications must have access to data from internal and external sources whilst ensuring data is encrypted at rest and in transit
• The databases in Tier 3, Tier 6 to 8 must have a recovery strategy for in case whenever the server goes offline
• The Tier 1 applications must have their databases stored on Premium P2 tier
• The Tier 1 applications must have their databases stored on Standard S4 tier
• Data will be migrated from the on-premise databases to Azure SQL Databases using Azure Data Factory. The pipeline must support continued data movement and migration.
• The Application access for Tier 7 and 8 must be restricted to the database only
• For Tier 4 and Tier 5 databases, the backup strategy must include the following
  • Transactional log backup every hour
  • Differential backup every day
  • Full backup every week
• Backup strategies must be in place for all standalone Azure SQL databases using methods available with Azure SQL databases.
• Tier 1 database must implement the following data masking logic
  • For Data type skillcertlabA – Mask 4 or less string data type characters
  • For Data type skillcertlabB – Expose the first letter and mask the domain
  • For Data type skillcertlabC – Mask everything except characters at the beginning and the end
• All certificates and keys are internally managed in on-premise data stores
• For Tier 2 databases, if there are any conflicts between the data transfer from on-premise, preference should be given to on-premise data.
• Monitoring must be setup on every database
• Applications with Tiers 6 through 8 must ensure that unexpected resource storage usage is immediately reported to IT data engineers.
• Azure SQL Data warehouse would be used to gather data from multiple internal and external databases.
• The Azure SQL Data warehouse must be optimized to use data from its cache
• The below metrics must be available when it comes to the cache
  • Metric skillcertlabA – Low cache hit %, high cache usage %
  • Metric skillcertlabB – Low cache hit %, low cache usage %
  • Metric skillcertlabC – high cache hit %, high cache usage %
• The reporting data for external partners must be stored in Azure storage. The data should be made available during regular business hours in connecting regions.
• The reporting for Tier 9 needs to be moved to Event Hubs.
• The reporting for Tier 10 needs to be moved to Azure Blobs.

The following issues have been identified in the setup:

• The External partners have control over the data formats, types and schemas
• For External based clients, the queries can’t be changed or optimized
• The database development staff are familiar with T-SQL language
• Because of the size and amount of data, some applications and reporting features are not performing at SLA levels.

Which of the following can be used to process and query the ingested data for the Tier 9 data?

Select 1 option(s):

Overview:

skillcertlabs is an online training provider.

Current Environment:

The company currently has Microsoft SQL databases that are split into different categories or tiers. Some of the databases are used by Internal users, some by external partners and external distributions.

Below is the list of applications, tiers and their individual requirements

• Applications – Tier – Replication – Comments
• Internal skillcertlab – 1 – Yes – NULL
• Internal skillcertlab – 2 – Using SQL Data Sync – NULL
• Internal Partner – 3 – Yes – Data is replicated to the Partner
• External skillcertlab – 4,5,6 – Yes
• External Partner – 7,8 – No – This is a Partner managed database
• Internal Distribution and Sales – 9 – Yes, but only when the data is ingested at one of the branch offices – Data is ingested from skillcertlab branch offices
• External Distribution and Sales – 10 – Yes, but only once the data is ingested at the skillcertlab main office – Data is ingested from multiple sources

Below are the current requirements of the company:

• The databases in Tier 3, Tier 6 to 8 must use a database density on the same server and Elastic pools in cost effective manner
• The Applications must have access to data from internal and external sources whilst ensuring data is encrypted at rest and in transit
• The databases in Tier 3, Tier 6 to 8 must have a recovery strategy for in case whenever the server goes offline
• The Tier 1 applications must have their databases stored on Premium P2 tier
• The Tier 1 applications must have their databases stored on Standard S4 tier
• Data will be migrated from the on-premise databases to Azure SQL Databases using Azure Data Factory. The pipeline must support continued data movement and migration.
• The Application access for Tier 7 and 8 must be restricted to the database only
• For Tier 4 and Tier 5 databases, the backup strategy must include the following
  • Transactional log backup every hour
  • Differential backup every day
  • Full backup every week
• Backup strategies must be in place for all standalone Azure SQL databases using methods available with Azure SQL databases.
• Tier 1 database must implement the following data masking logic
  • For Data type skillcertlabA – Mask 4 or less string data type characters
  • For Data type skillcertlabB – Expose the first letter and mask the domain
  • For Data type skillcertlabC – Mask everything except characters at the beginning and the end
• All certificates and keys are internally managed in on-premise data stores
• For Tier 2 databases, if there are any conflicts between the data transfer from on-premise, preference should be given to on-premise data.
• Monitoring must be setup on every database
• Applications with Tiers 6 through 8 must ensure that unexpected resource storage usage is immediately reported to IT data engineers.
• Azure SQL Data warehouse would be used to gather data from multiple internal and external databases.
• The Azure SQL Data warehouse must be optimized to use data from its cache
• The below metrics must be available when it comes to the cache
  • Metric skillcertlabA – Low cache hit %, high cache usage %
  • Metric skillcertlabB – Low cache hit %, low cache usage %
  • Metric skillcertlabC – high cache hit %, high cache usage %
• The reporting data for external partners must be stored in Azure storage. The data should be made available during regular business hours in connecting regions.
• The reporting for Tier 9 needs to be moved to Event Hubs.
• The reporting for Tier 10 needs to be moved to Azure Blobs.

The following issues have been identified in the setup:

• The External partners have control over the data formats, types and schemas
• For External based clients, the queries can’t be changed or optimized
• The database development staff are familiar with T-SQL language
• Because of the size and amount of data, some applications and reporting features are not performing at SLA levels.

The Azure Data Factory instance must meet the requirements to move the data from the On-premise SQL Servers to Azure. Which of the following would you use as the integration runtime?

Select 1 option(s):

Overview:

skillcertlabs is an online training provider.

Current Environment:

The company currently has Microsoft SQL databases that are split into different categories or tiers. Some of the databases are used by Internal users, some by external partners and external distributions.

Below is the list of applications, tiers and their individual requirements

• Applications – Tier – Replication – Comments
• Internal skillcertlab – 1 – Yes – NULL
• Internal skillcertlab – 2 – Using SQL Data Sync – NULL
• Internal Partner – 3 – Yes – Data is replicated to the Partner
• External skillcertlab – 4,5,6 – Yes
• External Partner – 7,8 – No – This is a Partner managed database
• Internal Distribution and Sales – 9 – Yes, but only when the data is ingested at one of the branch offices – Data is ingested from skillcertlab branch offices
• External Distribution and Sales – 10 – Yes, but only once the data is ingested at the skillcertlab main office – Data is ingested from multiple sources

Below are the current requirements of the company:

• The databases in Tier 3, Tier 6 to 8 must use a database density on the same server and Elastic pools in cost effective manner
• The Applications must have access to data from internal and external sources whilst ensuring data is encrypted at rest and in transit
• The databases in Tier 3, Tier 6 to 8 must have a recovery strategy for in case whenever the server goes offline
• The Tier 1 applications must have their databases stored on Premium P2 tier
• The Tier 1 applications must have their databases stored on Standard S4 tier
• Data will be migrated from the on-premise databases to Azure SQL Databases using Azure Data Factory. The pipeline must support continued data movement and migration.
• The Application access for Tier 7 and 8 must be restricted to the database only
• For Tier 4 and Tier 5 databases, the backup strategy must include the following
  • Transactional log backup every hour
  • Differential backup every day
  • Full backup every week
• Backup strategies must be in place for all standalone Azure SQL databases using methods available with Azure SQL databases.
• Tier 1 database must implement the following data masking logic
  • For Data type skillcertlabA – Mask 4 or less string data type characters
  • For Data type skillcertlabB – Expose the first letter and mask the domain
  • For Data type skillcertlabC – Mask everything except characters at the beginning and the end
• All certificates and keys are internally managed in on-premise data stores
• For Tier 2 databases, if there are any conflicts between the data transfer from on-premise, preference should be given to on-premise data.
• Monitoring must be setup on every database
• Applications with Tiers 6 through 8 must ensure that unexpected resource storage usage is immediately reported to IT data engineers.
• Azure SQL Data warehouse would be used to gather data from multiple internal and external databases.
• The Azure SQL Data warehouse must be optimized to use data from its cache
• The below metrics must be available when it comes to the cache
  • Metric skillcertlabA – Low cache hit %, high cache usage %
  • Metric skillcertlabB – Low cache hit %, low cache usage %
  • Metric skillcertlabC – high cache hit %, high cache usage %
• The reporting data for external partners must be stored in Azure storage. The data should be made available during regular business hours in connecting regions.
• The reporting for Tier 9 needs to be moved to Event Hubs.
• The reporting for Tier 10 needs to be moved to Azure Blobs.

The following issues have been identified in the setup:

• The External partners have control over the data formats, types and schemas
• For External based clients, the queries can’t be changed or optimized
• The database development staff are familiar with T-SQL language
• Because of the size and amount of data, some applications and reporting features are not performing at SLA levels.

The data for the external applications needs to be encrypted at rest. You decide to implement the following steps
Use the Always Encrypted Wizard in SQL Server Management Studio
Select the column that needs to be encrypted
Set the encryption type to Randomized
Configure the master key to be used from the Windows Certificate Store
Confirm the configuration and deploy the solution
Would these steps fulfil the requirement?

Select 1 option(s):

Overview:

skillcertlabs is an online training provider.

Current Environment:

The company currently has Microsoft SQL databases that are split into different categories or tiers. Some of the databases are used by Internal users, some by external partners and external distributions.

Below is the list of applications, tiers and their individual requirements

• Applications – Tier – Replication – Comments
• Internal skillcertlab – 1 – Yes – NULL
• Internal skillcertlab – 2 – Using SQL Data Sync – NULL
• Internal Partner – 3 – Yes – Data is replicated to the Partner
• External skillcertlab – 4,5,6 – Yes
• External Partner – 7,8 – No – This is a Partner managed database
• Internal Distribution and Sales – 9 – Yes, but only when the data is ingested at one of the branch offices – Data is ingested from skillcertlab branch offices
• External Distribution and Sales – 10 – Yes, but only once the data is ingested at the skillcertlab main office – Data is ingested from multiple sources

Below are the current requirements of the company:

• The databases in Tier 3, Tier 6 to 8 must use a database density on the same server and Elastic pools in cost effective manner
• The Applications must have access to data from internal and external sources whilst ensuring data is encrypted at rest and in transit
• The databases in Tier 3, Tier 6 to 8 must have a recovery strategy for in case whenever the server goes offline
• The Tier 1 applications must have their databases stored on Premium P2 tier
• The Tier 1 applications must have their databases stored on Standard S4 tier
• Data will be migrated from the on-premise databases to Azure SQL Databases using Azure Data Factory. The pipeline must support continued data movement and migration.
• The Application access for Tier 7 and 8 must be restricted to the database only
• For Tier 4 and Tier 5 databases, the backup strategy must include the following
  • Transactional log backup every hour
  • Differential backup every day
  • Full backup every week
• Backup strategies must be in place for all standalone Azure SQL databases using methods available with Azure SQL databases.
• Tier 1 database must implement the following data masking logic
  • For Data type skillcertlabA – Mask 4 or less string data type characters
  • For Data type skillcertlabB – Expose the first letter and mask the domain
  • For Data type skillcertlabC – Mask everything except characters at the beginning and the end
• All certificates and keys are internally managed in on-premise data stores
• For Tier 2 databases, if there are any conflicts between the data transfer from on-premise, preference should be given to on-premise data.
• Monitoring must be setup on every database
• Applications with Tiers 6 through 8 must ensure that unexpected resource storage usage is immediately reported to IT data engineers.
• Azure SQL Data warehouse would be used to gather data from multiple internal and external databases.
• The Azure SQL Data warehouse must be optimized to use data from its cache
• The below metrics must be available when it comes to the cache
  • Metric skillcertlabA – Low cache hit %, high cache usage %
  • Metric skillcertlabB – Low cache hit %, low cache usage %
  • Metric skillcertlabC – high cache hit %, high cache usage %
• The reporting data for external partners must be stored in Azure storage. The data should be made available during regular business hours in connecting regions.
• The reporting for Tier 9 needs to be moved to Event Hubs.
• The reporting for Tier 10 needs to be moved to Azure Blobs.

The following issues have been identified in the setup:

• The External partners have control over the data formats, types and schemas
• For External based clients, the queries can’t be changed or optimized
• The database development staff are familiar with T-SQL language
• Because of the size and amount of data, some applications and reporting features are not performing at SLA levels.

The data for the external applications needs to be encrypted at rest. You decide to implement the following steps
Use the Always Encrypted Wizard in SQL Server Management Studio
Select the column that needs to be encrypted
Set the encryption type to Deterministic
Configure the master key to be used from the Windows Certificate Store
Confirm the configuration and deploy the solution
Would these steps fulfil the requirement?

Select 1 option(s):

Overview:

skillcertlabs is an online training provider.

Current Environment:

The company currently has Microsoft SQL databases that are split into different categories or tiers. Some of the databases are used by Internal users, some by external partners and external distributions.

Below is the list of applications, tiers and their individual requirements

• Applications – Tier – Replication – Comments
• Internal skillcertlab – 1 – Yes – NULL
• Internal skillcertlab – 2 – Using SQL Data Sync – NULL
• Internal Partner – 3 – Yes – Data is replicated to the Partner
• External skillcertlab – 4,5,6 – Yes
• External Partner – 7,8 – No – This is a Partner managed database
• Internal Distribution and Sales – 9 – Yes, but only when the data is ingested at one of the branch offices – Data is ingested from skillcertlab branch offices
• External Distribution and Sales – 10 – Yes, but only once the data is ingested at the skillcertlab main office – Data is ingested from multiple sources

Below are the current requirements of the company:

• The databases in Tier 3, Tier 6 to 8 must use a database density on the same server and Elastic pools in cost effective manner
• The Applications must have access to data from internal and external sources whilst ensuring data is encrypted at rest and in transit
• The databases in Tier 3, Tier 6 to 8 must have a recovery strategy for in case whenever the server goes offline
• The Tier 1 applications must have their databases stored on Premium P2 tier
• The Tier 1 applications must have their databases stored on Standard S4 tier
• Data will be migrated from the on-premise databases to Azure SQL Databases using Azure Data Factory. The pipeline must support continued data movement and migration.
• The Application access for Tier 7 and 8 must be restricted to the database only
• For Tier 4 and Tier 5 databases, the backup strategy must include the following
  • Transactional log backup every hour
  • Differential backup every day
  • Full backup every week
• Backup strategies must be in place for all standalone Azure SQL databases using methods available with Azure SQL databases.
• Tier 1 database must implement the following data masking logic
  • For Data type skillcertlabA – Mask 4 or less string data type characters
  • For Data type skillcertlabB – Expose the first letter and mask the domain
  • For Data type skillcertlabC – Mask everything except characters at the beginning and the end
• All certificates and keys are internally managed in on-premise data stores
• For Tier 2 databases, if there are any conflicts between the data transfer from on-premise, preference should be given to on-premise data.
• Monitoring must be setup on every database
• Applications with Tiers 6 through 8 must ensure that unexpected resource storage usage is immediately reported to IT data engineers.
• Azure SQL Data warehouse would be used to gather data from multiple internal and external databases.
• The Azure SQL Data warehouse must be optimized to use data from its cache
• The below metrics must be available when it comes to the cache
  • Metric skillcertlabA – Low cache hit %, high cache usage %
  • Metric skillcertlabB – Low cache hit %, low cache usage %
  • Metric skillcertlabC – high cache hit %, high cache usage %
• The reporting data for external partners must be stored in Azure storage. The data should be made available during regular business hours in connecting regions.
• The reporting for Tier 9 needs to be moved to Event Hubs.
• The reporting for Tier 10 needs to be moved to Azure Blobs.

The following issues have been identified in the setup:

• The External partners have control over the data formats, types and schemas
• For External based clients, the queries can’t be changed or optimized
• The database development staff are familiar with T-SQL language
• Because of the size and amount of data, some applications and reporting features are not performing at SLA levels.

The data for the external applications needs to be encrypted at rest. You decide to implement the following steps
Use the Always Encrypted Wizard in SQL Server Management Studio
Select the column that needs to be encrypted
Set the encryption type to Deterministic
Configure the master key to be used from Azure Key vault
Confirm the configuration and deploy the solution
Would these steps fulfil the requirement?

Select 1 option(s):

Overview:

skillcertlabs is an online training provider.

Current Environment:

The company currently has Microsoft SQL databases that are split into different categories or tiers. Some of the databases are used by Internal users, some by external partners and external distributions.

Below is the list of applications, tiers and their individual requirements

• Applications – Tier – Replication – Comments
• Internal skillcertlab – 1 – Yes – NULL
• Internal skillcertlab – 2 – Using SQL Data Sync – NULL
• Internal Partner – 3 – Yes – Data is replicated to the Partner
• External skillcertlab – 4,5,6 – Yes
• External Partner – 7,8 – No – This is a Partner managed database
• Internal Distribution and Sales – 9 – Yes, but only when the data is ingested at one of the branch offices – Data is ingested from skillcertlab branch offices
• External Distribution and Sales – 10 – Yes, but only once the data is ingested at the skillcertlab main office – Data is ingested from multiple sources

Below are the current requirements of the company:

• The databases in Tier 3, Tier 6 to 8 must use a database density on the same server and Elastic pools in cost effective manner
• The Applications must have access to data from internal and external sources whilst ensuring data is encrypted at rest and in transit
• The databases in Tier 3, Tier 6 to 8 must have a recovery strategy for in case whenever the server goes offline
• The Tier 1 applications must have their databases stored on Premium P2 tier
• The Tier 1 applications must have their databases stored on Standard S4 tier
• Data will be migrated from the on-premise databases to Azure SQL Databases using Azure Data Factory. The pipeline must support continued data movement and migration.
• The Application access for Tier 7 and 8 must be restricted to the database only
• For Tier 4 and Tier 5 databases, the backup strategy must include the following
  • Transactional log backup every hour
  • Differential backup every day
  • Full backup every week
• Backup strategies must be in place for all standalone Azure SQL databases using methods available with Azure SQL databases.
• Tier 1 database must implement the following data masking logic
  • For Data type skillcertlabA – Mask 4 or less string data type characters
  • For Data type skillcertlabB – Expose the first letter and mask the domain
  • For Data type skillcertlabC – Mask everything except characters at the beginning and the end
• All certificates and keys are internally managed in on-premise data stores
• For Tier 2 databases, if there are any conflicts between the data transfer from on-premise, preference should be given to on-premise data.
• Monitoring must be setup on every database
• Applications with Tiers 6 through 8 must ensure that unexpected resource storage usage is immediately reported to IT data engineers.
• Azure SQL Data warehouse would be used to gather data from multiple internal and external databases.
• The Azure SQL Data warehouse must be optimized to use data from its cache
• The below metrics must be available when it comes to the cache
  • Metric skillcertlabA – Low cache hit %, high cache usage %
  • Metric skillcertlabB – Low cache hit %, low cache usage %
  • Metric skillcertlabC – high cache hit %, high cache usage %
• The reporting data for external partners must be stored in Azure storage. The data should be made available during regular business hours in connecting regions.
• The reporting for Tier 9 needs to be moved to Event Hubs.
• The reporting for Tier 10 needs to be moved to Azure Blobs.

The following issues have been identified in the setup:

• The External partners have control over the data formats, types and schemas
• For External based clients, the queries can’t be changed or optimized
• The database development staff are familiar with T-SQL language
• Because of the size and amount of data, some applications and reporting features are not performing at SLA levels.

Which of the following should you use as the masking function for Data type skillcertlabA?

Select 1 option(s):

Overview:

skillcertlabs is an online training provider.

Current Environment:

The company currently has Microsoft SQL databases that are split into different categories or tiers. Some of the databases are used by Internal users, some by external partners and external distributions.

Below is the list of applications, tiers and their individual requirements

• Applications – Tier – Replication – Comments
• Internal skillcertlab – 1 – Yes – NULL
• Internal skillcertlab – 2 – Using SQL Data Sync – NULL
• Internal Partner – 3 – Yes – Data is replicated to the Partner
• External skillcertlab – 4,5,6 – Yes
• External Partner – 7,8 – No – This is a Partner managed database
• Internal Distribution and Sales – 9 – Yes, but only when the data is ingested at one of the branch offices – Data is ingested from skillcertlab branch offices
• External Distribution and Sales – 10 – Yes, but only once the data is ingested at the skillcertlab main office – Data is ingested from multiple sources

Below are the current requirements of the company:

• The databases in Tier 3, Tier 6 to 8 must use a database density on the same server and Elastic pools in cost effective manner
• The Applications must have access to data from internal and external sources whilst ensuring data is encrypted at rest and in transit
• The databases in Tier 3, Tier 6 to 8 must have a recovery strategy for in case whenever the server goes offline
• The Tier 1 applications must have their databases stored on Premium P2 tier
• The Tier 1 applications must have their databases stored on Standard S4 tier
• Data will be migrated from the on-premise databases to Azure SQL Databases using Azure Data Factory. The pipeline must support continued data movement and migration.
• The Application access for Tier 7 and 8 must be restricted to the database only
• For Tier 4 and Tier 5 databases, the backup strategy must include the following
  • Transactional log backup every hour
  • Differential backup every day
  • Full backup every week
• Backup strategies must be in place for all standalone Azure SQL databases using methods available with Azure SQL databases.
• Tier 1 database must implement the following data masking logic
  • For Data type skillcertlabA – Mask 4 or less string data type characters
  • For Data type skillcertlabB – Expose the first letter and mask the domain
  • For Data type skillcertlabC – Mask everything except characters at the beginning and the end
• All certificates and keys are internally managed in on-premise data stores
• For Tier 2 databases, if there are any conflicts between the data transfer from on-premise, preference should be given to on-premise data.
• Monitoring must be setup on every database
• Applications with Tiers 6 through 8 must ensure that unexpected resource storage usage is immediately reported to IT data engineers.
• Azure SQL Data warehouse would be used to gather data from multiple internal and external databases.
• The Azure SQL Data warehouse must be optimized to use data from its cache
• The below metrics must be available when it comes to the cache
  • Metric skillcertlabA – Low cache hit %, high cache usage %
  • Metric skillcertlabB – Low cache hit %, low cache usage %
  • Metric skillcertlabC – high cache hit %, high cache usage %
• The reporting data for external partners must be stored in Azure storage. The data should be made available during regular business hours in connecting regions.
• The reporting for Tier 9 needs to be moved to Event Hubs.
• The reporting for Tier 10 needs to be moved to Azure Blobs.

The following issues have been identified in the setup:

• The External partners have control over the data formats, types and schemas
• For External based clients, the queries can’t be changed or optimized
• The database development staff are familiar with T-SQL language
• Because of the size and amount of data, some applications and reporting features are not performing at SLA levels.

Which of the following should you use as the masking function for Data type skillcertlabB?

Select 1 option(s):

Overview:

skillcertlabs is an online training provider.

Current Environment:

The company currently has Microsoft SQL databases that are split into different categories or tiers. Some of the databases are used by Internal users, some by external partners and external distributions.

Below is the list of applications, tiers and their individual requirements

• Applications – Tier – Replication – Comments
• Internal skillcertlab – 1 – Yes – NULL
• Internal skillcertlab – 2 – Using SQL Data Sync – NULL
• Internal Partner – 3 – Yes – Data is replicated to the Partner
• External skillcertlab – 4,5,6 – Yes
• External Partner – 7,8 – No – This is a Partner managed database
• Internal Distribution and Sales – 9 – Yes, but only when the data is ingested at one of the branch offices – Data is ingested from skillcertlab branch offices
• External Distribution and Sales – 10 – Yes, but only once the data is ingested at the skillcertlab main office – Data is ingested from multiple sources

Below are the current requirements of the company:

• The databases in Tier 3, Tier 6 to 8 must use a database density on the same server and Elastic pools in cost effective manner
• The Applications must have access to data from internal and external sources whilst ensuring data is encrypted at rest and in transit
• The databases in Tier 3, Tier 6 to 8 must have a recovery strategy for in case whenever the server goes offline
• The Tier 1 applications must have their databases stored on Premium P2 tier
• The Tier 1 applications must have their databases stored on Standard S4 tier
• Data will be migrated from the on-premise databases to Azure SQL Databases using Azure Data Factory. The pipeline must support continued data movement and migration.
• The Application access for Tier 7 and 8 must be restricted to the database only
• For Tier 4 and Tier 5 databases, the backup strategy must include the following
  • Transactional log backup every hour
  • Differential backup every day
  • Full backup every week
• Backup strategies must be in place for all standalone Azure SQL databases using methods available with Azure SQL databases.
• Tier 1 database must implement the following data masking logic
  • For Data type skillcertlabA – Mask 4 or less string data type characters
  • For Data type skillcertlabB – Expose the first letter and mask the domain
  • For Data type skillcertlabC – Mask everything except characters at the beginning and the end
• All certificates and keys are internally managed in on-premise data stores
• For Tier 2 databases, if there are any conflicts between the data transfer from on-premise, preference should be given to on-premise data.
• Monitoring must be setup on every database
• Applications with Tiers 6 through 8 must ensure that unexpected resource storage usage is immediately reported to IT data engineers.
• Azure SQL Data warehouse would be used to gather data from multiple internal and external databases.
• The Azure SQL Data warehouse must be optimized to use data from its cache
• The below metrics must be available when it comes to the cache
  • Metric skillcertlabA – Low cache hit %, high cache usage %
  • Metric skillcertlabB – Low cache hit %, low cache usage %
  • Metric skillcertlabC – high cache hit %, high cache usage %
• The reporting data for external partners must be stored in Azure storage. The data should be made available during regular business hours in connecting regions.
• The reporting for Tier 9 needs to be moved to Event Hubs.
• The reporting for Tier 10 needs to be moved to Azure Blobs.

The following issues have been identified in the setup:

• The External partners have control over the data formats, types and schemas
• For External based clients, the queries can’t be changed or optimized
• The database development staff are familiar with T-SQL language
• Because of the size and amount of data, some applications and reporting features are not performing at SLA levels.

Which of the following should you use as the masking function for Data type skillcertlabC?

Select 1 option(s):

Overview:

skillcertlabs is an online training provider.

Current Environment:

The company currently has Microsoft SQL databases that are split into different categories or tiers. Some of the databases are used by Internal users, some by external partners and external distributions.

Below is the list of applications, tiers and their individual requirements

• Applications – Tier – Replication – Comments
• Internal skillcertlab – 1 – Yes – NULL
• Internal skillcertlab – 2 – Using SQL Data Sync – NULL
• Internal Partner – 3 – Yes – Data is replicated to the Partner
• External skillcertlab – 4,5,6 – Yes
• External Partner – 7,8 – No – This is a Partner managed database
• Internal Distribution and Sales – 9 – Yes, but only when the data is ingested at one of the branch offices – Data is ingested from skillcertlab branch offices
• External Distribution and Sales – 10 – Yes, but only once the data is ingested at the skillcertlab main office – Data is ingested from multiple sources

Below are the current requirements of the company:

• The databases in Tier 3, Tier 6 to 8 must use a database density on the same server and Elastic pools in cost effective manner
• The Applications must have access to data from internal and external sources whilst ensuring data is encrypted at rest and in transit
• The databases in Tier 3, Tier 6 to 8 must have a recovery strategy for in case whenever the server goes offline
• The Tier 1 applications must have their databases stored on Premium P2 tier
• The Tier 1 applications must have their databases stored on Standard S4 tier
• Data will be migrated from the on-premise databases to Azure SQL Databases using Azure Data Factory. The pipeline must support continued data movement and migration.
• The Application access for Tier 7 and 8 must be restricted to the database only
• For Tier 4 and Tier 5 databases, the backup strategy must include the following
  • Transactional log backup every hour
  • Differential backup every day
  • Full backup every week
• Backup strategies must be in place for all standalone Azure SQL databases using methods available with Azure SQL databases.
• Tier 1 database must implement the following data masking logic
  • For Data type skillcertlabA – Mask 4 or less string data type characters
  • For Data type skillcertlabB – Expose the first letter and mask the domain
  • For Data type skillcertlabC – Mask everything except characters at the beginning and the end
• All certificates and keys are internally managed in on-premise data stores
• For Tier 2 databases, if there are any conflicts between the data transfer from on-premise, preference should be given to on-premise data.
• Monitoring must be setup on every database
• Applications with Tiers 6 through 8 must ensure that unexpected resource storage usage is immediately reported to IT data engineers.
• Azure SQL Data warehouse would be used to gather data from multiple internal and external databases.
• The Azure SQL Data warehouse must be optimized to use data from its cache
• The below metrics must be available when it comes to the cache
  • Metric skillcertlabA – Low cache hit %, high cache usage %
  • Metric skillcertlabB – Low cache hit %, low cache usage %
  • Metric skillcertlabC – high cache hit %, high cache usage %
• The reporting data for external partners must be stored in Azure storage. The data should be made available during regular business hours in connecting regions.
• The reporting for Tier 9 needs to be moved to Event Hubs.
• The reporting for Tier 10 needs to be moved to Azure Blobs.

The following issues have been identified in the setup:

• The External partners have control over the data formats, types and schemas
• For External based clients, the queries can’t be changed or optimized
• The database development staff are familiar with T-SQL language
• Because of the size and amount of data, some applications and reporting features are not performing at SLA levels.

You need to implement the following requirement as per the case study
The Application access for Tier 7 and 8 must be restricted to the database only
Which of the following steps would you implement for this requirement? Choose 3 answers from the options given below

Select 3 option(s):

Overview:

skillcertlabs is an online training provider.

Current Environment:

The company currently has Microsoft SQL databases that are split into different categories or tiers. Some of the databases are used by Internal users, some by external partners and external distributions.

Below is the list of applications, tiers and their individual requirements

• Applications – Tier – Replication – Comments
• Internal skillcertlab – 1 – Yes – NULL
• Internal skillcertlab – 2 – Using SQL Data Sync – NULL
• Internal Partner – 3 – Yes – Data is replicated to the Partner
• External skillcertlab – 4,5,6 – Yes
• External Partner – 7,8 – No – This is a Partner managed database
• Internal Distribution and Sales – 9 – Yes, but only when the data is ingested at one of the branch offices – Data is ingested from skillcertlab branch offices
• External Distribution and Sales – 10 – Yes, but only once the data is ingested at the skillcertlab main office – Data is ingested from multiple sources

Below are the current requirements of the company:

• The databases in Tier 3, Tier 6 to 8 must use a database density on the same server and Elastic pools in cost effective manner
• The Applications must have access to data from internal and external sources whilst ensuring data is encrypted at rest and in transit
• The databases in Tier 3, Tier 6 to 8 must have a recovery strategy for in case whenever the server goes offline
• The Tier 1 applications must have their databases stored on Premium P2 tier
• The Tier 1 applications must have their databases stored on Standard S4 tier
• Data will be migrated from the on-premise databases to Azure SQL Databases using Azure Data Factory. The pipeline must support continued data movement and migration.
• The Application access for Tier 7 and 8 must be restricted to the database only
• For Tier 4 and Tier 5 databases, the backup strategy must include the following
  • Transactional log backup every hour
  • Differential backup every day
  • Full backup every week
• Backup strategies must be in place for all standalone Azure SQL databases using methods available with Azure SQL databases.
• Tier 1 database must implement the following data masking logic
  • For Data type skillcertlabA – Mask 4 or less string data type characters
  • For Data type skillcertlabB – Expose the first letter and mask the domain
  • For Data type skillcertlabC – Mask everything except characters at the beginning and the end
• All certificates and keys are internally managed in on-premise data stores
• For Tier 2 databases, if there are any conflicts between the data transfer from on-premise, preference should be given to on-premise data.
• Monitoring must be setup on every database
• Applications with Tiers 6 through 8 must ensure that unexpected resource storage usage is immediately reported to IT data engineers.
• Azure SQL Data warehouse would be used to gather data from multiple internal and external databases.
• The Azure SQL Data warehouse must be optimized to use data from its cache
• The below metrics must be available when it comes to the cache
  • Metric skillcertlabA – Low cache hit %, high cache usage %
  • Metric skillcertlabB – Low cache hit %, low cache usage %
  • Metric skillcertlabC – high cache hit %, high cache usage %
• The reporting data for external partners must be stored in Azure storage. The data should be made available during regular business hours in connecting regions.
• The reporting for Tier 9 needs to be moved to Event Hubs.
• The reporting for Tier 10 needs to be moved to Azure Blobs.

The following issues have been identified in the setup:

• The External partners have control over the data formats, types and schemas
• For External based clients, the queries can’t be changed or optimized
• The database development staff are familiar with T-SQL language
• Because of the size and amount of data, some applications and reporting features are not performing at SLA levels.

You have to implement logging for monitoring the data warehousing solution. Which of the following would you log?

Select 1 option(s):

You decide to implement the following steps
Add the secret to the storage container
Create a Databricks workspace and add the access keys
Access the blob container from Azure Databricks
Would these steps fulfil the requirement?

Select 1 option(s):

You decide to implement the following steps
Add the secret to the key vault
Create a Databricks workspace and add the secret scope
Access the blob container from Azure Databricks
Would these steps fulfil the requirement?

Select 1 option(s):

Which of the following can they use to ingest data from a relational data store?

Select 1 option(s):

Which of the following can they use to ingest data from a local workstation?

Select 1 option(s):

Which of the following can they use to ingest data from log data stored on web servers?

Select 1 option(s):

You decide to implement the following steps
Create an external data source pointing to the Azure storage account
Create a workload group using the Azure storage account name as the pool name
Load the data using the CREATE TABLE AS SELECT statement
Would these steps fulfil the requirement?

Select 1 option(s):

You decide to implement the following steps
Create a remote service binding pointing to the Azure Data Lake Gen 2 storage account
Create an external file format and external table using the external data source
Load the data using the CREATE TABLE AS SELECT statement
Would these steps fulfil the requirement?

Select 1 option(s):

You decide to implement the following steps
Use Azure Data Factory to convert the parquet files to CSV files
Create an external data source pointing to the Azure storage account
Create an external file format and external table using the external data source
Load the data using the INSERT..SELECT statement
Would these steps fulfil the requirement?

Select 1 option(s):

You decide to implement the following steps
Create an external data source that points to the Azure Data Lake Gen 2 storage account
Then create and external file format and an external table by making use of an external data source
Then load the data using the CREATE TABLE AS SELECT statement
Would these steps fulfil the requirement?

Select 1 option(s):

Which of the following actions need to be performed to accomplish this requirement? Choose 2 answers from the options given below

Select 2 option(s):

Which of the following Powershell commands would you execute to create and configure the database? Choose 3 answers from the options below

Select 3 option(s):

View Case Study:

A company is hosting a computational data analysis processing application on a set of virtual machines. The application runs daily jobs and then stores the results in virtual hard disk drives. The application uses data from the previous data and stores the results in a snapshot of the VHD. When a new month starts, the applications creates a new VHD. You need to implement a data lifecycle policy that would meet the following requirements

• Ensure that results are kept for 60 days
• The data for the current year must be available for weekly reports
• Data from the prior 10 years must be available for auditing purposes
• Data that is required for auditing must be made available within 10 days of the request being made.

You have to enforce the data lifecycle policy and also ensure costs are kept to a minimum

You need complete the below lifecycle policy JSON segment

Which of the following would go into Slot 1?

Select 1 option(s):

A company is hosting a computational data analysis processing application on a set of virtual machines. The application runs daily jobs and then stores the results in virtual hard disk drives. The application uses data from the previous data and stores the results in a snapshot of the VHD. When a new month starts, the applications creates a new VHD. You need to implement a data lifecycle policy that would meet the following requirements

• Ensure that results are kept for 60 days
• The data for the current year must be available for weekly reports
• Data from the prior 10 years must be available for auditing purposes
• Data that is required for auditing must be made available within 10 days of the request being made.

You have to enforce the data lifecycle policy and also ensure costs are kept to a minimum

You need complete the below lifecycle policy JSON segment

Which of the following would go into Slot 2?

Select 1 option(s):

A company is hosting a computational data analysis processing application on a set of virtual machines. The application runs daily jobs and then stores the results in virtual hard disk drives. The application uses data from the previous data and stores the results in a snapshot of the VHD. When a new month starts, the applications creates a new VHD. You need to implement a data lifecycle policy that would meet the following requirements

• Ensure that results are kept for 60 days
• The data for the current year must be available for weekly reports
• Data from the prior 10 years must be available for auditing purposes
• Data that is required for auditing must be made available within 10 days of the request being made.

You have to enforce the data lifecycle policy and also ensure costs are kept to a minimum

You need complete the below lifecycle policy JSON segment

Which of the following would go into Slot 3?

Select 1 option(s):

A company is hosting a computational data analysis processing application on a set of virtual machines. The application runs daily jobs and then stores the results in virtual hard disk drives. The application uses data from the previous data and stores the results in a snapshot of the VHD. When a new month starts, the applications creates a new VHD. You need to implement a data lifecycle policy that would meet the following requirements

• Ensure that results are kept for 60 days
• The data for the current year must be available for weekly reports
• Data from the prior 10 years must be available for auditing purposes
• Data that is required for auditing must be made available within 10 days of the request being made.

You have to enforce the data lifecycle policy and also ensure costs are kept to a minimum

You need complete the below lifecycle policy JSON segment

Which of the following would go into Slot 4?

Select 1 option(s):

A company is hosting a computational data analysis processing application on a set of virtual machines. The application runs daily jobs and then stores the results in virtual hard disk drives. The application uses data from the previous data and stores the results in a snapshot of the VHD. When a new month starts, the applications creates a new VHD. You need to implement a data lifecycle policy that would meet the following requirements

• Ensure that results are kept for 60 days
• The data for the current year must be available for weekly reports
• Data from the prior 10 years must be available for auditing purposes
• Data that is required for auditing must be made available within 10 days of the request being made.

You have to enforce the data lifecycle policy and also ensure costs are kept to a minimum

You need complete the below lifecycle policy JSON segment

Which of the following would go into Slot 5?

Select 1 option(s):

Which of the following could be used as a native client to run interactive queries and batch processes?

Select 1 option(s):

Which of the following can be used as a web browser to run interactive queries and batch processes?

Select 1 option(s):

Which of the following can be used to develop batch processing applications that use Azure HDInsight?

Select 1 option(s):

Ingestion
Have the ability to receive millions of events per second
Be a fully managed platform-as-a-service solution
Integrate with Azure Functions
Stream Processing
Have the ability to process data on a per-job basis
Have the ability to connect seamlessly to Azure services
Use a SQL based query language
Analytical data store
Perform as a managed service
Ability to behave as a document store
Provide data encryption at rest
Which of the following would you consider using at the Ingestion layer?

Select 1 option(s):

Ingestion
Have the ability to receive millions of events per second
Be a fully managed platform-as-a-service solution
Integrate with Azure Functions
Stream Processing
Have the ability to process data on a per-job basis
Have the ability to connect seamlessly to Azure services
Use a SQL based query language
Analytical data store
Perform as a managed service
Ability to behave as a document store
Provide data encryption at rest
Which of the following would you consider using at the Stream Processing layer?

Select 1 option(s):

Ingestion
Have the ability to receive millions of events per second
Be a fully managed platform-as-a-service solution
Integrate with Azure Functions
Stream Processing
Have the ability to process data on a per-job basis
Have the ability to connect seamlessly to Azure services
Use a SQL based query language
Analytical data store
Perform as a managed service
Ability to behave as a document store
Provide data encryption at rest
Which of the following would you consider using at the Analytical data store layer?

Select 1 option(s):

You need to complete the below PowerShell snippet for implementing the solution

Which of the following would go into Area 2?

Select 1 option(s):

You need to complete the below PowerShell snippet for implementing the solution

Which of the following would go into Area 3?

Select 1 option(s):

Select 3 option(s):

Select 3 option(s):

Which of the following would go into Area 1?

Select 1 option(s):

Which of the following would go into Area 2?

Select 1 option(s):

Ingest data from Blob storage
Be able to analyze data in real time
Be able to store the processed data in Azure Cosmos DB
Which of the following actions would you implement for this requirement? Choose 3 answers from the options given below

Select 3 option(s):

Select 3 option(s):

The solution must scale up and down to ensure cost is effectively managed
It should use an in-memory data processing engine to speed up the machine learning operations
The system should provide streaming capabilities
The system should provide the ability to code in SQL, Python and Scala
Which of the following would you consider implementing for this solution?

Select 1 option(s):

Which of the following would be used for the task of storing “Execution results and diagnostics”?

Select 1 option(s):

Which of the following would be used for the task of handling the “Job launcher and tracker”?

Select 1 option(s):

Which of the following would be used for the task of storing the “Job metadata and state”?

Select 1 option(s):

Select 2 option(s):

Which of the following would you choose as the database instance type for uploading daily sales data?

Select 1 option(s):

Which of the following would you choose as the database instance type for the weekly sales data on which analytics needs to be performed?

Select 1 option(s):

Select 1 option(s):

Which of the following would they need to choose as the container type?

Select 1 option(s):

Which of the following would they need to choose as the item type?

Select 1 option(s):

skillcertlab_sales – Here the rows should be distributed in such a way that it offers high performance
skillcertlab_offers – Here data should be available on all nodes to achieve better performance on table joins
skillcertlab_orders – Here data should be loaded faster on the underlying table
Which of the following table type would you use for the table skillcertlab_sales?

Select 1 option(s):

skillcertlab_sales – Here the rows should be distributed in such a way that it offers high performance
skillcertlab_offers – Here data should be available on all nodes to achieve better performance on table joins
skillcertlab_orders – Here data should be loaded faster on the underlying table
Which of the following table type would you use for the table skillcertlab_offers?

Select 1 option(s):

skillcertlab_sales – Here the rows should be distributed in such a way that it offers high performance
skillcertlab_offers – Here data should be available on all nodes to achieve better performance on table joins
skillcertlab_orders – Here data should be loaded faster on the underlying table
Which of the following table type would you use for the table skillcertlab_orders?

Select 1 option(s):

Select 1 option(s):

Which of the following would go into Area 1?

Select 1 option(s):

Which of the following would go into Area 2?

Select 1 option(s):

Overview:

skillcertlabs is an online training provider. They regularly conduct polls on the effectiveness of their training material. The polling data comes from various sources, such as online surveys and public events.

The polling data would be stored into 2 locations

• An on-premise Microsoft SQL Server database
• Azure Data Lake Gen 2 storage

The data in the data lake would be queried using PolyBase

Each poll data also has associated metadata. The metadata is stored as JSON. The metadata has the date and number of people who have taken the poll.

Polling data is also taken via phone calls. Below are the security requirements for polling data taken via phone calls

• The poll data must be uploaded by authorized users from authorized devices
• External contractors can only access their own polling data
• The access to the polling data would be given to users on a per-active directory user basis

Other requirements:

• All data migration processes must be carried out using Azure Data Factory
• All of the data migrations must run automatically and be carried out during non-business hours
• All services and processes must be resilient to regional Azure outages
• All services must be monitored using Azure Monitor
• The performance of the on-premise SQL Server must also be monitored
• After 3 months all polling data must be moved to low cost storage
• All deployments must be performed using Azure DevOps.
• Deployments must make use of templates
• No credentials or secrets of any kind must be exposed during deployments

You have to implement the deployment of Azure Data Factory pipelines. Which of the following would you use for authorization of the deployments?

Select 1 option(s):

Overview:

skillcertlabs is an online training provider. They regularly conduct polls on the effectiveness of their training material. The polling data comes from various sources, such as online surveys and public events.

The polling data would be stored into 2 locations

• An on-premise Microsoft SQL Server database
• Azure Data Lake Gen 2 storage

The data in the data lake would be queried using PolyBase

Each poll data also has associated metadata. The metadata is stored as JSON. The metadata has the date and number of people who have taken the poll.

Polling data is also taken via phone calls. Below are the security requirements for polling data taken via phone calls

• The poll data must be uploaded by authorized users from authorized devices
• External contractors can only access their own polling data
• The access to the polling data would be given to users on a per-active directory user basis

Other requirements:

• All data migration processes must be carried out using Azure Data Factory
• All of the data migrations must run automatically and be carried out during non-business hours
• All services and processes must be resilient to regional Azure outages
• All services must be monitored using Azure Monitor
• The performance of the on-premise SQL Server must also be monitored
• After 3 months all polling data must be moved to low cost storage
• All deployments must be performed using Azure DevOps.
• Deployments must make use of templates
• No credentials or secrets of any kind must be exposed during deployments

You have to implement the deployment of Azure Data Factory pipelines. Which of the following would you use for authentication of the deployments?

Select 1 option(s):

Overview:

skillcertlabs is an online training provider. They regularly conduct polls on the effectiveness of their training material. The polling data comes from various sources, such as online surveys and public events.

The polling data would be stored into 2 locations

• An on-premise Microsoft SQL Server database
• Azure Data Lake Gen 2 storage

The data in the data lake would be queried using PolyBase

Each poll data also has associated metadata. The metadata is stored as JSON. The metadata has the date and number of people who have taken the poll.

Polling data is also taken via phone calls. Below are the security requirements for polling data taken via phone calls

• The poll data must be uploaded by authorized users from authorized devices
• External contractors can only access their own polling data
• The access to the polling data would be given to users on a per-active directory user basis

Other requirements:

• All data migration processes must be carried out using Azure Data Factory
• All of the data migrations must run automatically and be carried out during non-business hours
• All services and processes must be resilient to regional Azure outages
• All services must be monitored using Azure Monitor
• The performance of the on-premise SQL Server must also be monitored
• After 3 months all polling data must be moved to low cost storage
• All deployments must be performed using Azure DevOps.
• Deployments must make use of templates
• No credentials or secrets of any kind must be exposed during deployments

You have to create the storage account that would be used to store the polling data. Which of the following would you use as the Account type?

Select 1 option(s):

Overview:

skillcertlabs is an online training provider. They regularly conduct polls on the effectiveness of their training material. The polling data comes from various sources, such as online surveys and public events.

The polling data would be stored into 2 locations

• An on-premise Microsoft SQL Server database
• Azure Data Lake Gen 2 storage

The data in the data lake would be queried using PolyBase

Each poll data also has associated metadata. The metadata is stored as JSON. The metadata has the date and number of people who have taken the poll.

Polling data is also taken via phone calls. Below are the security requirements for polling data taken via phone calls

• The poll data must be uploaded by authorized users from authorized devices
• External contractors can only access their own polling data
• The access to the polling data would be given to users on a per-active directory user basis

Other requirements:

• All data migration processes must be carried out using Azure Data Factory
• All of the data migrations must run automatically and be carried out during non-business hours
• All services and processes must be resilient to regional Azure outages
• All services must be monitored using Azure Monitor
• The performance of the on-premise SQL Server must also be monitored
• After 3 months all polling data must be moved to low cost storage
• All deployments must be performed using Azure DevOps.
• Deployments must make use of templates
• No credentials or secrets of any kind must be exposed during deployments

You have to create the storage account that would be used to store the polling data. Which of the following would you use as the replication type?

Select 1 option(s):

Overview:

skillcertlabs is an online training provider. They regularly conduct polls on the effectiveness of their training material. The polling data comes from various sources, such as online surveys and public events.

The polling data would be stored into 2 locations

• An on-premise Microsoft SQL Server database
• Azure Data Lake Gen 2 storage

The data in the data lake would be queried using PolyBase

Each poll data also has associated metadata. The metadata is stored as JSON. The metadata has the date and number of people who have taken the poll.

Polling data is also taken via phone calls. Below are the security requirements for polling data taken via phone calls

• The poll data must be uploaded by authorized users from authorized devices
• External contractors can only access their own polling data
• The access to the polling data would be given to users on a per-active directory user basis

Other requirements:

• All data migration processes must be carried out using Azure Data Factory
• All of the data migrations must run automatically and be carried out during non-business hours
• All services and processes must be resilient to regional Azure outages
• All services must be monitored using Azure Monitor
• The performance of the on-premise SQL Server must also be monitored
• After 3 months all polling data must be moved to low cost storage
• All deployments must be performed using Azure DevOps.
• Deployments must make use of templates
• No credentials or secrets of any kind must be exposed during deployments

You have to ensure Azure Data Factory would run to make the polling data available in the polling data database. Which of the following would you configure in Azure Data Factory?

Select 1 option(s):

Overview:

skillcertlabs is an online training provider. They regularly conduct polls on the effectiveness of their training material. The polling data comes from various sources, such as online surveys and public events.

The polling data would be stored into 2 locations

• An on-premise Microsoft SQL Server database
• Azure Data Lake Gen 2 storage

The data in the data lake would be queried using PolyBase

Each poll data also has associated metadata. The metadata is stored as JSON. The metadata has the date and number of people who have taken the poll.

Polling data is also taken via phone calls. Below are the security requirements for polling data taken via phone calls

• The poll data must be uploaded by authorized users from authorized devices
• External contractors can only access their own polling data
• The access to the polling data would be given to users on a per-active directory user basis

Other requirements:

• All data migration processes must be carried out using Azure Data Factory
• All of the data migrations must run automatically and be carried out during non-business hours
• All services and processes must be resilient to regional Azure outages
• All services must be monitored using Azure Monitor
• The performance of the on-premise SQL Server must also be monitored
• After 3 months all polling data must be moved to low cost storage
• All deployments must be performed using Azure DevOps.
• Deployments must make use of templates
• No credentials or secrets of any kind must be exposed during deployments

You have to ensure the polling data security requirements are met. Which of the following would you set for Polybase?

Select 1 option(s):

Select 1 option(s):