Data Engineering on Microsoft Azure Test 4

You have to decide on which services will be used for each layer.
Which of the following would you choose as the service to use Service D?

Select 1 option(s):

The data is going to be stored in an Azure Cosmos DB container. The queries on the data will be filtered by using the Customer Category and the Customer Surname.
Which of the following would you use as the Partition Key?

Select 1 option(s):

The data is going to be stored in an Azure Cosmos DB container. The queries on the data will be filtered by using the Customer Category and the Customer Surname.
Which of the following would you use as the Item ID?

Select 1 option(s):

All dimension tables will be less than 4 GB after compression. The fact table will be approximately 5 TB. You have to decide on the underlying table type for each table.
Which of the following would you use as the underlying table type for the skillcertlab_employee table?

Select 1 option(s):

All dimension tables will be less than 4 GB after compression. The fact table will be approximately 5 TB. You have to decide on the underlying table type for each table.
Which of the following would you use as the underlying table type for the skillcertlab_fact table?

Select 1 option(s):

All dimension tables will be less than 4 GB after compression. The fact table will be approximately 5 TB. You have to decide on the underlying table type for each table.
Which of the following would you use as the underlying table type for the skillcertlab_Customer table?

Select 1 option(s):

All dimension tables will be less than 4 GB after compression. The fact table will be approximately 5 TB. You have to decide on the underlying table type for each table.
Which of the following would you use as the underlying table type for the skillcertlab_Course table?

Select 1 option(s):

When an image is first uploaded it would be accessed frequently
After a week, the images would not be accessed frequently. But if accessed, it would need to be available within 30 seconds.
After a year the data would not be accessed that frequently, but if it was accessed, it would need to be available within 5 minutes.
The data storage costs must be minimized.
Which of the following would you choose as the storage tier for the images for the first week?

Select 1 option(s):

When an image is first uploaded it would be accessed frequently
After a week, the images would not be accessed frequently. But if accessed, it would need to be available within 30 seconds.
After a year the data would not be accessed that frequently, but if it was accessed, it would need to be available within 5 minutes.
The data storage costs must be minimized.
Which of the following would you choose as the storage tier for the images after a month?

Select 1 option(s):

When an image is first uploaded it would be accessed frequently
After a week, the images would not be accessed frequently. But if accessed, it would need to be available within 30 seconds.
After a year the data would not be accessed that frequently, but if it was accessed, it would need to be available within 5 minutes.
The data storage costs must be minimized.
Which of the following would you choose as the storage tier for the images after a year?

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

Which of the following would they use as the file type for exporting the on-premise database?

Select 1 option(s):

Select 1 option(s):

Multiple users must be able to use the cluster
Overall costs must be reduced
Query latency should be minimized
Which of the following should be implemented as the cluster configuration for this requirement?

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

Select 2 option(s):

Select 1 option(s):

A company currently has the following virtual machines in their on-premise data centre:

Name – Role – Database Size – Type – Destination on Azure

skillcertlab_sql1 – Microsoft SQL Server – 2 TB – Hyper-V – Azure SQL Database

skillcertlab_sql2 – Microsoft SQL Server – 2 TB – Hyper-V – Azure SQL Database

skillcertlab_sql3 – Microsoft SQL Server – 90 GB – Hyper-V – Azure Virtual Machine

skillcertlab_sap1 – SAP – 1 TB – VMWare – On-premise

skillcertlab_sap2 – SAP – 1 TB – VMWare – On-premise

Requirements:

The company wants to migrate the SQL server workloads to Azure. Below are the key requirements:

• The server skillcertlab_sql3 requires an initial IOPS of 35000
• The servers skillcertlab_sql1 and skillcertlab_sql2 must use the vCore model and should also use replicas. These servers must support an IOPS of 8000.
• The compute and storage resources must be scaled independently
• The data from the SQL Servers must use zone redundant storage
• The current applications running on the on-premise servers must be able to interact with the databases on Azure.
• A regional disaster recover strategy must also be in place
• The database backups must be retained for 7 years
• The server skillcertlab_sql1 contains sales data. Data analysis must be performed on this data. A solution must in place which would read data from the database, perform ETL and then output the results to Power BI. The solution must use managed clusters to minimize costs.
• The analytics solution which would be in place for the sales data must be available even in the event of a regional outage.
• All employee PII data must be encrypted in rest and in transit
• Keys must be in place using hardware security modules
• The server skillcertlab_sql3 must not be able to communicate over the default ports
• Data engineers must be able to set the compute resources for the Data warehouse to 250 DWUs
• The server costs for skillcertlab_sql2 must be reduced when it is not being used during non-peak hours

Which of the following would you use as the disk type for server skillcertlab_sql3 when it is migrated to Azure?

Select 1 option(s):

A company currently has the following virtual machines in their on-premise data centre:

Name – Role – Database Size – Type – Destination on Azure

skillcertlab_sql1 – Microsoft SQL Server – 2 TB – Hyper-V – Azure SQL Database

skillcertlab_sql2 – Microsoft SQL Server – 2 TB – Hyper-V – Azure SQL Database

skillcertlab_sql3 – Microsoft SQL Server – 90 GB – Hyper-V – Azure Virtual Machine

skillcertlab_sap1 – SAP – 1 TB – VMWare – On-premise

skillcertlab_sap2 – SAP – 1 TB – VMWare – On-premise

Requirements:

The company wants to migrate the SQL server workloads to Azure. Below are the key requirements:

• The server skillcertlab_sql3 requires an initial IOPS of 35000
• The servers skillcertlab_sql1 and skillcertlab_sql2 must use the vCore model and should also use replicas. These servers must support an IOPS of 8000.
• The compute and storage resources must be scaled independently
• The data from the SQL Servers must use zone redundant storage
• The current applications running on the on-premise servers must be able to interact with the databases on Azure.
• A regional disaster recover strategy must also be in place
• The database backups must be retained for 7 years
• The server skillcertlab_sql1 contains sales data. Data analysis must be performed on this data. A solution must in place which would read data from the database, perform ETL and then output the results to Power BI. The solution must use managed clusters to minimize costs.
• The analytics solution which would be in place for the sales data must be available even in the event of a regional outage.
• All employee PII data must be encrypted in rest and in transit
• Keys must be in place using hardware security modules
• The server skillcertlab_sql3 must not be able to communicate over the default ports
• Data engineers must be able to set the compute resources for the Data warehouse to 250 DWUs
• The server costs for skillcertlab_sql2 must be reduced when it is not being used during non-peak hours

Which of the following would you choose as the database service tier?

Select 1 option(s):

A company currently has the following virtual machines in their on-premise data centre:

Name – Role – Database Size – Type – Destination on Azure

skillcertlab_sql1 – Microsoft SQL Server – 2 TB – Hyper-V – Azure SQL Database

skillcertlab_sql2 – Microsoft SQL Server – 2 TB – Hyper-V – Azure SQL Database

skillcertlab_sql3 – Microsoft SQL Server – 90 GB – Hyper-V – Azure Virtual Machine

skillcertlab_sap1 – SAP – 1 TB – VMWare – On-premise

skillcertlab_sap2 – SAP – 1 TB – VMWare – On-premise

Requirements:

The company wants to migrate the SQL server workloads to Azure. Below are the key requirements:

• The server skillcertlab_sql3 requires an initial IOPS of 35000
• The servers skillcertlab_sql1 and skillcertlab_sql2 must use the vCore model and should also use replicas. These servers must support an IOPS of 8000.
• The compute and storage resources must be scaled independently
• The data from the SQL Servers must use zone redundant storage
• The current applications running on the on-premise servers must be able to interact with the databases on Azure.
• A regional disaster recover strategy must also be in place
• The database backups must be retained for 7 years
• The server skillcertlab_sql1 contains sales data. Data analysis must be performed on this data. A solution must in place which would read data from the database, perform ETL and then output the results to Power BI. The solution must use managed clusters to minimize costs.
• The analytics solution which would be in place for the sales data must be available even in the event of a regional outage.
• All employee PII data must be encrypted in rest and in transit
• Keys must be in place using hardware security modules
• The server skillcertlab_sql3 must not be able to communicate over the default ports
• Data engineers must be able to set the compute resources for the Data warehouse to 250 DWUs
• The server costs for skillcertlab_sql2 must be reduced when it is not being used during non-peak hours

You have to ensure data can be accessed from the on-premise network for the Azure SQL Databases. Which of the following would you use as the tool to access the data?

Select 1 option(s):

A company currently has the following virtual machines in their on-premise data centre:

Name – Role – Database Size – Type – Destination on Azure

skillcertlab_sql1 – Microsoft SQL Server – 2 TB – Hyper-V – Azure SQL Database

skillcertlab_sql2 – Microsoft SQL Server – 2 TB – Hyper-V – Azure SQL Database

skillcertlab_sql3 – Microsoft SQL Server – 90 GB – Hyper-V – Azure Virtual Machine

skillcertlab_sap1 – SAP – 1 TB – VMWare – On-premise

skillcertlab_sap2 – SAP – 1 TB – VMWare – On-premise

Requirements:

The company wants to migrate the SQL server workloads to Azure. Below are the key requirements:

• The server skillcertlab_sql3 requires an initial IOPS of 35000
• The servers skillcertlab_sql1 and skillcertlab_sql2 must use the vCore model and should also use replicas. These servers must support an IOPS of 8000.
• The compute and storage resources must be scaled independently
• The data from the SQL Servers must use zone redundant storage
• The current applications running on the on-premise servers must be able to interact with the databases on Azure.
• A regional disaster recover strategy must also be in place
• The database backups must be retained for 7 years
• The server skillcertlab_sql1 contains sales data. Data analysis must be performed on this data. A solution must in place which would read data from the database, perform ETL and then output the results to Power BI. The solution must use managed clusters to minimize costs.
• The analytics solution which would be in place for the sales data must be available even in the event of a regional outage.
• All employee PII data must be encrypted in rest and in transit
• Keys must be in place using hardware security modules
• The server skillcertlab_sql3 must not be able to communicate over the default ports
• Data engineers must be able to set the compute resources for the Data warehouse to 250 DWUs
• The server costs for skillcertlab_sql2 must be reduced when it is not being used during non-peak hours

You have to ensure data can be accessed from the on-premise network for the Azure SQL Databases. Which of the following would you use as the port number to connect to the database?

Select 1 option(s):

A company currently has the following virtual machines in their on-premise data centre:

Name – Role – Database Size – Type – Destination on Azure

skillcertlab_sql1 – Microsoft SQL Server – 2 TB – Hyper-V – Azure SQL Database

skillcertlab_sql2 – Microsoft SQL Server – 2 TB – Hyper-V – Azure SQL Database

skillcertlab_sql3 – Microsoft SQL Server – 90 GB – Hyper-V – Azure Virtual Machine

skillcertlab_sap1 – SAP – 1 TB – VMWare – On-premise

skillcertlab_sap2 – SAP – 1 TB – VMWare – On-premise

Requirements:

The company wants to migrate the SQL server workloads to Azure. Below are the key requirements:

• The server skillcertlab_sql3 requires an initial IOPS of 35000
• The servers skillcertlab_sql1 and skillcertlab_sql2 must use the vCore model and should also use replicas. These servers must support an IOPS of 8000.
• The compute and storage resources must be scaled independently
• The data from the SQL Servers must use zone redundant storage
• The current applications running on the on-premise servers must be able to interact with the databases on Azure.
• A regional disaster recover strategy must also be in place
• The database backups must be retained for 7 years
• The server skillcertlab_sql1 contains sales data. Data analysis must be performed on this data. A solution must in place which would read data from the database, perform ETL and then output the results to Power BI. The solution must use managed clusters to minimize costs.
• The analytics solution which would be in place for the sales data must be available even in the event of a regional outage.
• All employee PII data must be encrypted in rest and in transit
• Keys must be in place using hardware security modules
• The server skillcertlab_sql3 must not be able to communicate over the default ports
• Data engineers must be able to set the compute resources for the Data warehouse to 250 DWUs
• The server costs for skillcertlab_sql2 must be reduced when it is not being used during non-peak hours

The company wants to ensure that data is encrypted when it is stored in the Azure SQL database. Which of the following could be used for this requirement?

Select 1 option(s):

A company currently has the following virtual machines in their on-premise data centre:

Name – Role – Database Size – Type – Destination on Azure

skillcertlab_sql1 – Microsoft SQL Server – 2 TB – Hyper-V – Azure SQL Database

skillcertlab_sql2 – Microsoft SQL Server – 2 TB – Hyper-V – Azure SQL Database

skillcertlab_sql3 – Microsoft SQL Server – 90 GB – Hyper-V – Azure Virtual Machine

skillcertlab_sap1 – SAP – 1 TB – VMWare – On-premise

skillcertlab_sap2 – SAP – 1 TB – VMWare – On-premise

Requirements:

The company wants to migrate the SQL server workloads to Azure. Below are the key requirements:

• The server skillcertlab_sql3 requires an initial IOPS of 35000
• The servers skillcertlab_sql1 and skillcertlab_sql2 must use the vCore model and should also use replicas. These servers must support an IOPS of 8000.
• The compute and storage resources must be scaled independently
• The data from the SQL Servers must use zone redundant storage
• The current applications running on the on-premise servers must be able to interact with the databases on Azure.
• A regional disaster recover strategy must also be in place
• The database backups must be retained for 7 years
• The server skillcertlab_sql1 contains sales data. Data analysis must be performed on this data. A solution must in place which would read data from the database, perform ETL and then output the results to Power BI. The solution must use managed clusters to minimize costs.
• The analytics solution which would be in place for the sales data must be available even in the event of a regional outage.
• All employee PII data must be encrypted in rest and in transit
• Keys must be in place using hardware security modules
• The server skillcertlab_sql3 must not be able to communicate over the default ports
• Data engineers must be able to set the compute resources for the Data warehouse to 250 DWUs
• The server costs for skillcertlab_sql2 must be reduced when it is not being used during non-peak hours

One of the databases is going to store sensitive data. You have to implement a solution that would be used to identify the sensitive data and monitor access to the data. Which of the following would you implement for this requirement? Choose 3 answers from the options given below

Select 3 option(s):

A company currently has the following virtual machines in their on-premise data centre:

Name – Role – Database Size – Type – Destination on Azure

skillcertlab_sql1 – Microsoft SQL Server – 2 TB – Hyper-V – Azure SQL Database

skillcertlab_sql2 – Microsoft SQL Server – 2 TB – Hyper-V – Azure SQL Database

skillcertlab_sql3 – Microsoft SQL Server – 90 GB – Hyper-V – Azure Virtual Machine

skillcertlab_sap1 – SAP – 1 TB – VMWare – On-premise

skillcertlab_sap2 – SAP – 1 TB – VMWare – On-premise

Requirements:

The company wants to migrate the SQL server workloads to Azure. Below are the key requirements:

• The server skillcertlab_sql3 requires an initial IOPS of 35000
• The servers skillcertlab_sql1 and skillcertlab_sql2 must use the vCore model and should also use replicas. These servers must support an IOPS of 8000.
• The compute and storage resources must be scaled independently
• The data from the SQL Servers must use zone redundant storage
• The current applications running on the on-premise servers must be able to interact with the databases on Azure.
• A regional disaster recover strategy must also be in place
• The database backups must be retained for 7 years
• The server skillcertlab_sql1 contains sales data. Data analysis must be performed on this data. A solution must in place which would read data from the database, perform ETL and then output the results to Power BI. The solution must use managed clusters to minimize costs.
• The analytics solution which would be in place for the sales data must be available even in the event of a regional outage.
• All employee PII data must be encrypted in rest and in transit
• Keys must be in place using hardware security modules
• The server skillcertlab_sql3 must not be able to communicate over the default ports
• Data engineers must be able to set the compute resources for the Data warehouse to 250 DWUs
• The server costs for skillcertlab_sql2 must be reduced when it is not being used during non-peak hours

You have to ensure a backup strategy is present for the serve skillcertlab_sql1 and skillcertlab_sql2. Which of the following would you implement?

Select 1 option(s):

A company currently has the following virtual machines in their on-premise data centre:

Name – Role – Database Size – Type – Destination on Azure

skillcertlab_sql1 – Microsoft SQL Server – 2 TB – Hyper-V – Azure SQL Database

skillcertlab_sql2 – Microsoft SQL Server – 2 TB – Hyper-V – Azure SQL Database

skillcertlab_sql3 – Microsoft SQL Server – 90 GB – Hyper-V – Azure Virtual Machine

skillcertlab_sap1 – SAP – 1 TB – VMWare – On-premise

skillcertlab_sap2 – SAP – 1 TB – VMWare – On-premise

Requirements:

The company wants to migrate the SQL server workloads to Azure. Below are the key requirements:

• The server skillcertlab_sql3 requires an initial IOPS of 35000
• The servers skillcertlab_sql1 and skillcertlab_sql2 must use the vCore model and should also use replicas. These servers must support an IOPS of 8000.
• The compute and storage resources must be scaled independently
• The data from the SQL Servers must use zone redundant storage
• The current applications running on the on-premise servers must be able to interact with the databases on Azure.
• A regional disaster recover strategy must also be in place
• The database backups must be retained for 7 years
• The server skillcertlab_sql1 contains sales data. Data analysis must be performed on this data. A solution must in place which would read data from the database, perform ETL and then output the results to Power BI. The solution must use managed clusters to minimize costs.
• The analytics solution which would be in place for the sales data must be available even in the event of a regional outage.
• All employee PII data must be encrypted in rest and in transit
• Keys must be in place using hardware security modules
• The server skillcertlab_sql3 must not be able to communicate over the default ports
• Data engineers must be able to set the compute resources for the Data warehouse to 250 DWUs
• The server costs for skillcertlab_sql2 must be reduced when it is not being used during non-peak hours

You need to implement disaster recovery for the data analysis solution. Which of the following would you implement for this requirement? Choose 3 answers from the options given below

Select 3 option(s):

The company decides to use Azure SQL Data Warehouse as the analytics service
Would this fulfil the requirement?

Select 1 option(s):

The company decides to use Azure Databricks as the analytics service
Would this fulfil the requirement?

Select 1 option(s):

The company decides to use Azure Stream Analytics as the analytics service
Would this fulfil the requirement?

Select 1 option(s):

The company decides to use Azure Analysis service as the analytics service
Would this fulfil the requirement?

Select 1 option(s):

Select 1 option(s):

Ensure the database is encrypted at rest
Ensure that when sensitive data is accessed from the columns, it is encrypted in transit
Which of the following would you use for the following requirement?
“Ensure that when sensitive data is accessed from the columns, it is encrypted in transit”

Select 1 option(s):

Select 1 option(s):

The solution must have support for 1 million blobs
The solution must scale automatically
Costs must be minimized
Which of the following would you recommend for this requirement?

Select 1 option(s):

Select 2 option(s):

Q38. A company is planning on designing a solution in Azure. The solution would be based on the Kappa architecture as shown below

Which of the following could be used for Layer 2?

Select 1 option(s):

Select 1 option(s):

They decide to disable hierarchical namespace and use access control lists.
Would this fulfil the requirement?

Select 1 option(s):

They decide to enable hierarchical namespace and use RBAC
Would this fulfil the requirement?

Select 1 option(s):

They decide to disable hierarchical namespace and use RBAC
Would this fulfil the requirement?

Select 1 option(s):

It should have support for a hierarchical file system
It should be optimized for parallel analytic workloads
It should provide unlimited account sizes
Which of the following would you implement for this requirement?

Select 1 option(s):

Be able to receive thousands of files per minute
The files would be in different file formats – JSON, text and CSV
The files would eventually be processed, transformed and loaded into an Azure SQL data warehouse
Which of the following would you use as the underlying data store?

Select 1 option(s):

Select 1 option(s):

Storage costs should be minimized
The storage account will be used to hold objects which are infrequently accessed
The data in the storage account will be stored for at least 30 days
Data availability must be guaranteed at an SLA of 99%
Which of the following could be used as the underlying storage tier?

Select 1 option(s):

Select 1 option(s):

Data must be available in the secondary region if the primary region goes down.
The storage and compute layers for the SQL database must be integrated and replicated together
Which of the following would you use as the Service tier for the database?

Select 1 option(s):

Data must be available in the secondary region if the primary region goes down.
The storage and compute layers for the SQL database must be integrated and replicated together
Which of the following would you use as the redundancy type?

Select 1 option(s):

The company decides to configure database-level auditing and set a retention period as part of the implementation process.
Would this meet the requirement?

Select 1 option(s):

The company decides to create user-defined restore points before the data is uploaded. And then delete the restore point after the data corruption checks are complete
Would this meet the requirement?

Select 1 option(s):

The company decides to configure transactions and then perform a rollback if data corruption is detected
Would this meet the requirement?

Select 1 option(s):

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 develop notebooks to transform the data?

Select 1 option(s):

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 run notebooks?

Select 1 option(s):

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

Select 1 option(s):