Data Engineering on Microsoft Azure Test 7

Enable monotonic reads and writes within a session
Provide fast throughput
Provide the lowest latency
Which of the following should be set as the consistency level for the database?

Select 1 option(s):

Select 3 option(s):

Select 1 option(s):

Minimize data movement
Provide the fastest query time
Which of the following would you choose as the table type?

Select 1 option(s):

The first two prefix characters must be exposed
The last four prefix characters must be exposed
All other characters must be masked
You decide to implement data masking and use a credit card function mask
Would this fulfil the requirement?

Select 1 option(s):

The first two prefix characters must be exposed
The last four prefix characters must be exposed
All other characters must be masked
You decide to implement data masking and use an email function mask.
Would this fulfil the requirement?

Select 1 option(s):

You need to configure PolyBase to connect the data warehouse to the storage account. Which of the following would you need to create for this requirement? Choose 3 answers from the options given below

Select 3 option(s):

Currently the following issues are occurring within the application
There are delays which occur during live conversations
There is a delay which occurs before the matching link appears after the code snippet is added to the conversation
Which of the following can be used to resolve the below issue?
“There are delays which occur during live conversations”

Select 1 option(s):

Currently the following issues are occurring within the application
There are delays which occur during live conversations
There is a delay which occurs before the matching link appears after the code snippet is added to the conversation
Which of the following can be used to resolve the below issue?
“There is a delay which occurs before the matching link appears after the code snippet is added to the conversation”

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

Select 5 option(s):

private static readonly string skillcertlabendpointUrl = ConfigurationManager.AppSettings[“EndpointUrl”];
private static readonly SecureString skillcertlabkey=ToSecureString(ConfigurationManager.AppSettings[“AuthorizationKey”]);
var skillcertlab_client= new DocumentClient(new Url(skillcertlabendpointUrl), skillcertlabkey);
Database database= await skillcertlab_client.CreateDatabaseAsync(new Database { Id=”skillcertlabdb” );
Which of the following is the type of database the code is connecting to?

Select 1 option(s):

private static readonly string skillcertlabendpointUrl = ConfigurationManager.AppSettings[“EndpointUrl”];
private static readonly SecureString skillcertlabkey=ToSecureString(ConfigurationManager.AppSettings[“AuthorizationKey”]);
var skillcertlab_client= new DocumentClient(new Url(skillcertlabendpointUrl), skillcertlabkey);
Database database= await skillcertlab_client.CreateDatabaseAsync(new Database { Id=”skillcertlabdb” );
Which of the following is the key type used in the code?

Select 1 option(s):

Select 3 option(s):

Which of the following actions would you perform to implement this solution? Choose 5 answers from the options given below

Select 5 option(s):

Data storage
The data store should serve as a repository for high volumes of files.
The files can be large and of different formats
It should be optimized for big data analytics workloads
The data should be organized using a hierarchical structure
Batch processing
This layer should provide a managed solution for in-memory computation processing
It should provide support for a variety of programming languages
It should provide the ability to resize and terminate the cluster automatically
Analytical data store
This layer must provide support for SQL language
It must implement native columnar storage
It should support parallel processing
Which of the following should be used as a technology for the “Data Storage” layer?

Select 1 option(s):

Data storage
The data store should serve as a repository for high volumes of files.
The files can be large and of different formats
It should be optimized for big data analytics workloads
The data should be organized using a hierarchical structure
Batch processing
This layer should provide a managed solution for in-memory computation processing
It should provide support for a variety of programming languages
It should provide the ability to resize and terminate the cluster automatically
Analytical data store
This layer must provide support for SQL language
It must implement native columnar storage
It should support parallel processing
Which of the following should be used as a technology for the “Batch processing” layer?

Select 1 option(s):

Data storage
The data store should serve as a repository for high volumes of files.
The files can be large and of different formats
It should be optimized for big data analytics workloads
The data should be organized using a hierarchical structure
Batch processing
This layer should provide a managed solution for in-memory computation processing
It should provide support for a variety of programming languages
It should provide the ability to resize and terminate the cluster automatically
Analytical data store
This layer must provide support for SQL language
It must implement native columnar storage
It should support parallel processing
Which of the following should be used as a technology for the “Analytical data store” layer?

Select 1 option(s):

Overview:

skillcertlabs is an online training provider. They also provide a yearly gaming competition for their students. The competition is held every month in different locations.

Current Environment:

The company currently has the following environment in place:

• The racing cars for the competition send their telemetry data to a MongoDB database. The telemetry data has around 100 attributes.
• A custom application is then used to transfer the data from the MongoDB database to a SQL Server 2017 database. The attribute names are changed when they are sent to the SQL Server database.
• Another application named “skillcertlab workflow” is then used to perform analytics on the telemetry data to look for improvements on the racing cars.
• The SQL Server 2017 database has a table named “cardata” which has around 1 TB of data. “skillcertlab workflow” performs the required analytics on the data in this table. Large aggregations are performed on a column of the table.

Proposed Environment:

The company now wants to move the environment to Azure. Below are the key requirements

• The racing car data will now be moved to Azure Cosmos DB and Azure SQL database. The data must be written to the closest Azure data center and must converge in the least amount of time.
• The query performance for data in the Azure SQL database must be stable without the need of administrative overhead
• The data for analytics will be moved to an Azure SQL Data warehouse
• Transparent data encryption must be enabled for all data stores wherever possible
• An Azure Data Factory pipeline will be used to move data from the Cosmos DB database to the Azure SQL database. If there is a delay of more than 15 minutes for the data transfer, then configuration changes need to be made to the pipeline workflow.
• The telemetry data must be monitored for any sort of performance issues.
• The Request Units for Cosmos DB must be adjusted to maintain the demand while also minimizing costs.
• The data in the Azure SQL Server database must be protected via the following requirements
• Only the last four digits of the values in the column carID must be shown
• A zero value must be shown for all values in the column carWeight

Which of the following should be used as the API for the Cosmos DB account?

Select 1 option(s):

Which of the following would you use for the consistency level for the database?

Select 1 option(s):

You need to build the Azure SQL Data warehouse data store. Which of the following would you use as the underlying table type?

Select 1 option(s):

You need to build the Azure SQL Data warehouse data store. Which of the following would you use as the underlying index type?

Select 1 option(s):

Which of the following masking functions should be used for the “carID” column?

Select 1 option(s):

Which of the following masking functions should be used for the “carWeight” column?

Select 1 option(s):

Which of the following should be included in the Data Factory Pipeline?

Select 1 option(s):

The team is monitoring the Data Factory pipeline. They can see that the Cosmos DB to SQL database run time is taking 45 minutes. Which of the following can be carried out to improve the performance of the job?

Select 1 option(s):

Which of the following can be used to satisfy the case study requirement?
“The query performance for data in the Azure SQL database must be stable without the need of administrative overhead”

Select 1 option(s):

You need to monitor the telemetry data being sent to Cosmos DB so that you can decide on the amount of Request Units to provision for Cosmos DB. Which of the following metrics must you monitor? Choose 2 answers from the options given below

Select 2 option(s):

WITH step1 AS (SELECT * FROM input1 PARTITION BY skillcertlabID INTO 10),
step2 AS (SELECT * FROM input2 PARTITION BY skillcertlabID INTO 10)
SELECT * INTO output FROM step1 PARTITION BY skillcertlabID UNION step2 PARTITION BY skillcertlabID
Does the query represent the joining of two streams of repartitioned data?

Select 1 option(s):

WITH step1 AS (SELECT * FROM input1 PARTITION BY skillcertlabID INTO 10),
step2 AS (SELECT * FROM input2 PARTITION BY skillcertlabID INTO 10)
SELECT * INTO output FROM step1 PARTITION BY skillcertlabID UNION step2 PARTITION BY skillcertlabID
Do both input streams need to have the same partition key and count?

Select 1 option(s):

WITH step1 AS (SELECT * FROM input1 PARTITION BY skillcertlabID INTO 10),
step2 AS (SELECT * FROM input2 PARTITION BY skillcertlabID INTO 10)
SELECT * INTO output FROM step1 PARTITION BY skillcertlabID UNION step2 PARTITION BY skillcertlabID
Does the output schema need to match the stream scheme key and count?

Select 1 option(s):

ClusterA – Here the cluster need to be configured to terminate automatically after 120 minutes
ClusterB – Here an environment needs to be created for each notebook
ClusterC – Here a group of data engineers will be sharing the same cluster
Which of the following cluster type would you set for ClusterA?

Select 1 option(s):

ClusterA – Here the cluster need to be configured to terminate automatically after 120 minutes
ClusterB – Here an environment needs to be created for each notebook
ClusterC – Here a group of data engineers will be sharing the same cluster
Which of the following cluster type would you set for ClusterC?

Select 1 option(s):

Select 2 option(s):

Which of the following would you choose as the Log type when setting up the diagnostic setting for Azure Data Factory?

Select 1 option(s):

Which of the following would you use as the storage location when setting up the diagnostic setting for Azure Data Factory?

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

Select 3 option(s):

Use an Azure HDInsight for data ingestion. The data would be ingested from a relational database hosted on another cloud service
Use an Azure Data Lake Storage account which would be used to store the processed data
Give the ability to users to download the processed data
Which of the following technology would you suggest using for the data ingestion process?

Select 1 option(s):

Use an Azure HDInsight for data ingestion. The data would be ingested from a relational database hosted on another cloud service
Use an Azure Data Lake Storage account which would be used to store the processed data
Give the ability to users to download the processed data
Which of the following would you use as a process for the solution?

Select 1 option(s):

Use an Azure HDInsight for data ingestion. The data would be ingested from a relational database hosted on another cloud service
Use an Azure Data Lake Storage account which would be used to store the processed data
Give the ability to users to download the processed data
Which of the following can be used to download the data?

Select 1 option(s):

Provide the ability to process the data every 5 hours
Give the ability for interactive data analysis
Give the ability to process data using solid-state drive caching
Make use of Directed Acyclic Graph processing mechanisms
Provide support for REST API calls for monitoring purposes
Ensure support for Python and Integration with Microsoft Power BI
Which of the following would you consider for the solution?

Select 1 option(s):

Ingest twitter-based data into Azure
Give the ability to visualize real-time twitter data
Which of the following would you use to implement this solution? Choose 3 answers from the options given below

Select 3 option(s):

Select 3 option(s):

Select 1 option(s):

Which of the following would they use in Azure to host the SQL databases?

Select 1 option(s):

Which of the following would you use to provide data access to clients?

Select 1 option(s):

Which of the following would be used to run operations on files and directories on the file system?

Select 1 option(s):

Which of the following is used to perform block creation, deletion and replication?

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

Select 3 option(s):

Which of the following would they use to configure security for the Azure SQL Database?

Select 1 option(s):

Which of the following would they use to configure security for the Azure Blob storage account?

Select 1 option(s):

Select 3 option(s):

Select 4 option(s):

Select 2 option(s):