Data Engineering on Microsoft Azure Test 24

Azure data engineer test

Welcome to your Data Engineering on Microsoft Azure - Test-24

Name

Phone

Q1. Which component enables you to perform code free transformations in Azure Synapse Analytics?

Select 1 option(s):

Mapping data flow

Copy activity

Studio

Q2. In Cosmos DB, Storage for single logical partition key value quota is limited to

Select 1 option(s):

40 GB

30 GB

20 GB

Q3. Your boss wants to monitor the ADF pipeline performance for last 6 months. then how would you do it

Select 1 option(s):

Create a diagnostic setting, route the pipeline data to Log analytics

Use ADF Activity dashboard

Q4. When a partition key reaches its provisioned storage limit, requests to create new resources will return a HTTP Status Code

Select 1 option(s):

500

403(Forbidden)

404

Q5. What type of trigger would you choose in Azure data factory to trigger pipeline batch job when a file gets deleted or created in Blob storage?

Select 1 option(s):

Storage event trigger

Tumbling window trigger

Scheduled trigger

Custom event trigger

Q6. You are designing a customer table with sensitive information in it. you want to hide the Age details from LowPreviUser. Below is the table definition.

CREATE TABLE Customer
(
CustId varachar (20),
CustName varchar (200),
CustAge varchar (9) not null,
CustPhone varchar (12) null
)
Complete the following snippet
GRANT ——————Customer (CustId, CustName,CustPhone) TO LowPrivUser ;

Select 1 option(s):

SELECT ON

MASK ON

ALTER ON

PREVILEGE

Q7. As a data engineer, you need to partially mask the numbers of an SSN column. you would need to make sure only last 4 digits are visible. What do you recommend?

Select 1 option(s):

ALTER TABLE [dbo] . [Student] ALTER COLUMN SSN ADD MASKED WITH FUNCTION = ‘PARTIAL ( 0,“XXX-XX-“, 4)‘);

ALTER TABLE [dbo] . [Student] ALTER COLUMN SSN ADD MASKED WITH FUNCTION = ‘PARTIAL ( 0,“XXX-XX-“, 0)‘);

ALTER TABLE [dbo] . [Student] ALTER COLUMN SSN ADD MASKED WITH FUNCTION = ‘PARTIAL ( 0,“XXX-XX-“, 4)‘);

ALTER TABLE [dbo] . [Student] ALTER COLUMN SSN ADD MASKED WITH FUNCTION = ‘PARTIAL ( 4,“XXX-XX-“, 0)‘);

Q8. As a data engineer for a transportation company, you have been asked to design the streaming pipeline to collect the telemetry data about driver driving patterns and display on dashboard to analyze the safety. you have decided to go with Azure Event Hubs, Stream analytics and Power BI based solution. Here are the options to setup the system. arrange the 5 actions that you should perform in the right sequence.

A- Start the Stream analytics job
B- Configure Power BI as the output for the Stream analytics Job
C- Build the Power BI dashboard to visualize the traffic data on a map
D- Build the Stream analytics query to aggregate the data based on locality
E- Copy the aggregated data into Synapse SQL Pool
F- Configure the Event Hubs as the input for Stream analytics job

Select 1 option(s):

F,B,D,A,C

A,B,C,D,E

G,A,B,D,C

Q9. As a data engineer for a retail company, there are three types of data the company wants to store in Azure Blob Storage. Select the storage tiers that you should recommend for storing data for generating quarterly sales reports.

Select 1 option(s):

Hot tier

Cold tier

Archive report

Q10. When creating a new cluster in the Azure Databricks workspace, what happens behind the scenes?

Select 1 option(s):

Azure Databricks provisions a dedicated VM that processes all jobs, bas

Azure Databricks provisions a dedicated VM that processes all jobs, based on your VM type and size selection.

Azure Databricks creates a cluster of driver and worker nodes, based on your VM type and size selections.

When an Azure Databricks workspace is deployed, you are allocated a pool of VMs. Creating a cluster draws from this pool.

Q11. You are hired as data engineer and you need to monitor the performance of the ADF pipeline for the last month. How would you do in azure portal.

Select 1 option(s):

both A and B

Create diagnostic setting, route the pipeline data to Log Analytics

Use the ADF pipeline activity dashboard

Q12. What are the two prerequisites for connecting Azure Databricks with Azure Synapse Analytics that apply to the Azure Synapse Analytics instance?

Select 1 option(s):

Create a database master key and configure the firewall to enable Azure services to connect

Use a correctly formatted ConnectionString and create a database master key

Add the client IP address to the firewall‘s allowed IP addresses list and use the correctly formatted ConnectionString

Q13. Which is the correct syntax for overwriting data in Azure Synapse Analytics from a Databricks notebook?

Select 1 option(s):

df.write.format(“com.databricks.spark.sqldw“).overwrite().option(“...“).option(“...“).save()

df.write.format(“com.databricks.spark.sqldw“).mode(“overwrite“).option(“...“).option(“...“).save()

df.write.mode(“overwrite“).option(“...“).option(“...“).save()

Q14. You are a Architect for a major supply chain industry. your team is using blob storage for last 2 months now. you were asked by your director to find the usage and availability of the Blob storage. You can find Blob availability metrics from storage metrics blade?

Select 1 option(s):

Yes

Q15. You are planning to migrate your applications from on-premise to Microsoft Azure. You have created 3 virtual networks to segregate Web, App and database layers virtual machines in Azure. You have created 30 virtual machines across 3 virtual networks and assigned private IP address for your virtual machines. You planned to use Azure Bastion service to remote login into your Azure VMs.

How many Azure Bastion services you must consider in your design keeping costs minimal?

Select 1 option(s):

Q16. You are working as a data engineer for a retail industry. you need to design a pipeline to capture the data from various social media websites, product reviews and other online forums.

The input data includes files in CSV,JSON,Image,Video and plain text formats. The data is expected to have duplicate entries and missing fields. The overall data size is about 2 petabytes very month. The engineering team are experts in Python and would like a Notebook experience. Engineers must be able to visualize the data for debugging purposes. Daily reports need to be generated. The reports should contain graphs and charts with the ability to filter and sort in the reports. For designing the data pipeline, what azure resources would you select for the Transformation zone of data lake?

Select 1 option(s):

Azure Databricks Spark

Azure Data Lake Gen2

Azure Stream analytics

Q17. Azure SQL Database elastic pools are a simple, cost-effective solution for managing and scaling resources for multiple databases on a single server?

Select 1 option(s):

FALSE

TRUE

Q18. Can we create two database API ( eg. Cassandra API and Core SQL API) using single Cosmos DB account.

Select 1 option(s):

Yes

Q19. You are the data engineer for a cab company. you are designing the schema to store trip information. you have a large fact table that has a tera bytes of data. you have dimension tables in the range of 400- 500 MB, and you have daily car health data in the range of 40 GB. Health data of the car needs to be loaded into a staging table as quickly as possible. What distribution would you choose for the staging table?

Select 1 option(s):

Hash

Round Robin

Replicated

Q20. You work as azure data engineer for a major bank that stores all transactions in an Azure SQL database. You are required to keep track of all delete activities in the SQL database. Which of the following activities should you perform to track this?

Select 1 option(s):

Configure Log analytics as the destination for audit logs

Create alerts using Azure SQL Metrics

Build custom metrics for delete events

Q21. You have an Azure Active Directory (Azure AD) tenant. You have an existing Azure AD conditional access policy named Policy1. Policy1 enforces the use of Azure AD-joined devices when members of the Global Administrators group authenticate to Azure AD from untrusted locations. You need to ensure that members of the Global Administrators group will also be forced to use multi-factor authentication when authenticating from untrusted locations.

What should you do?

Select 1 option(s):

From the Azure portal, modify session control of Policy1.

From the Azure portal, modify grant control of Policy1

From multi-factor authentication page, modify the user settings

From multi-factor authentication page, modify the service settings

Q22. Which T-SQL Statement loads data directly from Azure Storage?

Select 1 option(s):

LOAD DATA

INSERT FROM FILE

COPY

Q23. You are the data engineer for a cab company. you are designing the schema to store trip information. you have a large fact table that has a tera bytes of data. you have dimension tables in the range of 400- 500 MB, and you have daily car health data in the range of 40 GB. Health data of the car needs to be loaded into a staging table as quickly as possible. What distribution would you choose for the Dimension tables?

Select 1 option(s):

Replicated

Round robin

Hash

Q24. You are migrating business critical applications to Microsoft Azure. The application owners are concerned about cyber-attack risks that may happen in cloud environments against commonly used management ports. Considering the criticality and sensitivity of data processed in these applications, your security administrator wants to implement time-based access to Operations team to perform maintenance activities. Your legal team wants a log of activities for auditing purpose. Which of the below solution is correct?

Select 1 option(s):

Just-in-time (JIT) access & activity logs

Network Security Groups (NSG) & Flow logs

Azure Firewall & Logs generated by Azure Firewall

Q25. You are working for a bank credit card department. your director asked you to design a system to detect credit card fraud. one of the use case is to check if the credit card has been used more than 4 times in last 15 minutes. You have designed a pipeline using stream analytics and event hub. you have decided to use window functions of stream analytics to figure out if the credit card transactions occurred in last 15 minutes. which of the following window would you use for this solution?

Select 1 option(s):

Session window

Sliding window

Tumbling window

Hopping window

Q26. You are working for a retail company that is storing daily Sales data in Parquet format and Item data in CSV format. You are required to generate a report to list all the sales aggregated using store field. The report should contain all the columns from both the files.

Sales file format (Parquet)
storeNo saleDate itemId
Item(CSV)
itemId itemDescription Price
Val JoinDF = fromCSV. —(fromParquet,fromCSV(“itemId“)==fromParquet(“itemId“),“Inner“),—-(“storeNo“)

Select 1 option(s):

orderBy, groupBy

join,groupBy

select,Join

Q27. As a lead data engineer, you are designing a storage solution that will use Azure Blob storage. The data will be stored in a cool access tier, or an archive access tier based on the access patterns of the data.

You identify the following types of infrequently accessed data:
Telemetry data: Deleted after two years
Promotional material: Deleted after 14 days
Virtual machine audit data: Deleted after 200 days
A colleague recommends using the archive access tier to store the data.
Which statement accurately describes the recommendation?

Select 1 option(s):

Storage costs will be based on a minimum of 180 days.

Storage costs will be based on a minimum of 30 days.

Access to the data is guaranteed within 30 minutes

Access to the data is guaranteed within five minutes.

Q28. You are working as a data engineer for a retail industry. you need to design a pipeline to capture the data from various social media websites, product reviews and other online forums.

The input data includes files in CSV,JSON,Image,Video and plain text formats. The data is expected to have duplicate entries and missing fields. The overall data size is about 2 petabytes very month. The engineering team are experts in Python and would like a Notebook experience. Engineers must be able to visualize the data for debugging purposes. Daily reports need to be generated. The reports should contain graphs and charts with the ability to filter and sort in the reports. For designing the data pipeline, what azure resources would you select for the Reporting layer of data lake?

Select 1 option(s):

Azure Synapse SQL Pool

Power BI

Data Lake Storage Gen2

Q29. What type of trigger would you choose in Azure data factory to trigger pipeline batch job everyday morning at 7 A.M CST?

Select 1 option(s):

Schedule trigger

Custom event trigger

Storage event trigger

Q30. As an Architect for designing Cosmos DB, you should specify a partition key that satisfy the following core properties.

Select 1 option(s):

Have a high cardinality (each partition can grow up to 20 GB in size)

Evenly distribute storage

All of the above

Evenly distribute requests

Q31. In order to create an Apache Spark pool in Azure Synapse Analytics, what needs to be created first?

Select 1 option(s):

Azure Synapse analytics workspace

Apache Spark instance

Azure Synapse studio

Q32. In Cosmos DB, Partitions that are approaching thresholds are referred to as

Select 1 option(s):

Cold Partition

Hot Partition

Q33. As a data engineer, Identify the type of SCD by looking at below table schema.

CREATE TABLE CustomerDim (
SurrogateId Identify,
CustId varchar (20),
Name varchar (100),
StartDate Date,
EndDate Date,
IsActive Int
)

Select 1 option(s):

SCD Type 3

SCD Type 2

SCD Type 1

Q34. You are the data engineer for a cab company. you are designing the schema to store trip information. you have a large fact table that has a tera bytes of data. you have dimension tables in the range of 400- 500 MB, and you have daily car health data in the range of 40 GB. Health data of the car needs to be loaded into a staging table as quickly as possible. What distribution would you choose for the Fact table?

Select 1 option(s):

Replicated

Hash

Round robin

Q35. Your customer has created several Azure subscriptions and deployed several resources as part of cloud transformation program. Over a period of time, the number of subscriptions has significantly increased. Cloud operations team finds it is difficult to manage number of subscriptions especially to define standards and governance strategies.

You are asked to review the Azure design and recommend a change which will reduce cloud operations team concerns. What should you consider in your recommendation?

Select 1 option(s):

Azure Management Groups

Resource Groups

Azure Policy

Q36. As an Architect for a company, one of the team members has mistakenly checked in the storage access key as part of a source code into a Git repository. you want to regenerate the new access key to avoid security risk. Which of the following existing authorization keys you will generate?

Select 1 option(s):

Azure active directory security groups

Security certificates

Shared access signature (SAS) keys

Q37. In Cosmos DB, A Partition that stores all data associated with same partition key value is called

Select 1 option(s):

Logical partition

Shard

Physical partition

Data Engineering on Microsoft Azure Test 24

Q1. Which component enables you to perform code free transformations in Azure Synapse Analytics?

Q2. In Cosmos DB, Storage for single logical partition key value quota is limited to

Q3. Your boss wants to monitor the ADF pipeline performance for last 6 months. then how would you do it

Q4. When a partition key reaches its provisioned storage limit, requests to create new resources will return a HTTP Status Code

Q5. What type of trigger would you choose in Azure data factory to trigger pipeline batch job when a file gets deleted or created in Blob storage?

Q6. You are designing a customer table with sensitive information in it. you want to hide the Age details from LowPreviUser. Below is the table definition.

Q7. As a data engineer, you need to partially mask the numbers of an SSN column. you would need to make sure only last 4 digits are visible. What do you recommend?

Q9. As a data engineer for a retail company, there are three types of data the company wants to store in Azure Blob Storage. Select the storage tiers that you should recommend for storing data for generating quarterly sales reports.

Q10. When creating a new cluster in the Azure Databricks workspace, what happens behind the scenes?

Q11. You are hired as data engineer and you need to monitor the performance of the ADF pipeline for the last month. How would you do in azure portal.

Q12. What are the two prerequisites for connecting Azure Databricks with Azure Synapse Analytics that apply to the Azure Synapse Analytics instance?

Q13. Which is the correct syntax for overwriting data in Azure Synapse Analytics from a Databricks notebook?

Q14. You are a Architect for a major supply chain industry. your team is using blob storage for last 2 months now. you were asked by your director to find the usage and availability of the Blob storage. You can find Blob availability metrics from storage metrics blade?

Q16. You are working as a data engineer for a retail industry. you need to design a pipeline to capture the data from various social media websites, product reviews and other online forums.

Q17. Azure SQL Database elastic pools are a simple, cost-effective solution for managing and scaling resources for multiple databases on a single server?

Q18. Can we create two database API ( eg. Cassandra API and Core SQL API) using single Cosmos DB account.

Q20. You work as azure data engineer for a major bank that stores all transactions in an Azure SQL database. You are required to keep track of all delete activities in the SQL database. Which of the following activities should you perform to track this?

Q22. Which T-SQL Statement loads data directly from Azure Storage?

Q26. You are working for a retail company that is storing daily Sales data in Parquet format and Item data in CSV format. You are required to generate a report to list all the sales aggregated using store field. The report should contain all the columns from both the files.

Q27. As a lead data engineer, you are designing a storage solution that will use Azure Blob storage. The data will be stored in a cool access tier, or an archive access tier based on the access patterns of the data.

Q28. You are working as a data engineer for a retail industry. you need to design a pipeline to capture the data from various social media websites, product reviews and other online forums.

Q29. What type of trigger would you choose in Azure data factory to trigger pipeline batch job everyday morning at 7 A.M CST?

Q30. As an Architect for designing Cosmos DB, you should specify a partition key that satisfy the following core properties.

Q31. In order to create an Apache Spark pool in Azure Synapse Analytics, what needs to be created first?

Q32. In Cosmos DB, Partitions that are approaching thresholds are referred to as

Q33. As a data engineer, Identify the type of SCD by looking at below table schema.

Q36. As an Architect for a company, one of the team members has mistakenly checked in the storage access key as part of a source code into a Git repository. you want to regenerate the new access key to avoid security risk. Which of the following existing authorization keys you will generate?

Q37. In Cosmos DB, A Partition that stores all data associated with same partition key value is called

Company

Some Useful Links

Our Services

Oh yeah, we're on social media too!