Data Engineering on Microsoft Azure Test 2

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

Name

Phone

Q1. You are building a pipeline for processing big data on Microsoft Azure. The pipeline must meet the following requirements: – Use streaming capabilities – Provide the ability to code in SQL, Python, Scala and R – Workspace integration with Git repository – Use in-memory data processing engine to speed up ETL and machine learning operations. What should you use?

Select 1 option(s):

Azure Stream Analytics

Azure Synapse

HDInsight Hadoop Cluster

HDInsight Spark Cluster

HDInsight Storm Cluster

Q2. You are considering to deploy an Azure Databricks interactive cluster. You need to ensure that the cluster configuration is kept, even if the cluster is inactive for more than 30 days.

How would you achieve this goal?

Select 1 option(s):

Terminate the cluster manually

Clone the cluster after termination

Pin the cluster

Start the cluster manually

Q3. You are designing a big data analytics solution that will use azure stream analytics to analyse real-time twitter data with hashtag #cloud. Which windowing function would you recommend to be used in your query, if you need to give every 5 seconds the count of tweets over the last 10 seconds?

Select 1 option(s):

Session window

Sliding window

Tumbling window

Hopping window

Q4. You are designing a big data engineering solution on Microsoft Azure. Some of the key requirements that your solution needs to meet are the following:

– support of streaming data processing
– capability to assign fine-grained user permissions for notebooks, clusters, jobs, and data using RBAC
– integration with Power BI
– fully managed Spark clusters in the cloud
Which Azure service would you recommend?

Select 1 option(s):

Azure Data Lake Storage Gen2

Azure Function

Azure Databricks

Azure Stream Analytics

Q5. You are designing a big data solution for leading healthcare provider that will use Azure Synapse. A health care provider allows only doctors and nurses to have access to sensitive medical records while not allowing members of the billing department to view this data.

What would you recommend?

Select 1 option(s):

Row-level security

Dynamic Data Masking

Column-level security

TLS

Q6. You are designing a big data solution that will use Azure SQL Data Warehouse. You expect to load millions of rows of data into the data warehouse each day. You must ensure that staging tables are optimized for data loading. You need to design the staging tables.

What type of distributed tables should you recommend?

Select 1 option(s):

Hash-distributed

Round-Robin

None

Replicated table

Q7. You are designing a big data solution that will use Azure Synapse. The solution must be able to load millions of rows of data into the Azure Synapse once a week (on Friday) in the most efficient way possible. Which type of distributed table would you choose?

Select 1 option(s):

Round-robin distributed table

Hash-distributed table

Replicated table

Q8. You are designing a data engineering solution for data stream processing. You need to recommend a solution for data ingestion, in order to meet the following requirements:

– Ingest millions of events per second
– Easily scale from streaming megabytes of data to terabytes while keeping control over when and how much to scale
– Integrate with Azure Functions
– Natively connect with Stream Analytics to build an end-to-end serverless streaming solution.

What would you recommend?

Select 1 option(s):

Azure Cosmos DB

Apache Spark

Azure Synapse Analytics

Azure Event Hubs

Q9. You are designing a data engineering solution that will use Azure Databricks. Which 2 capabilities are only available on premium service tier?

Please select the correct answers.

Select 2 option(s):

Audit logs

Automatic start and termination of clusters

Production streaming with monitoring

Alerting and monitoring with retries

Optimized autoscaling of compute

Role-based access control for notebooks, clusters, jobs, and tables

Q10. You are designing a data engineering solution to copy telemetry data from Azure Blob Storage to Azure Data Lake Storage Gen 2 using Azure Data Factory. There is no need to perform data integration securely in a private network environment. Which integration runtime would you suggest to use?

Select 1 option(s):

Azure-SSIS Integration runtime

None

Self-hosted integration runtime

Azure integration runtime

Q11. You are designing a data engineering solution to import the customers’ data from the SAP Hana database to Azure Data Lake Storage Gen 2 using Azure Data Factory. Which Integration runtime would you suggest to use?

Select 1 option(s):

Azure-SSIS integration runtime

Self-hosted integration runtime

Azure integration runtime

Q12. You are designing a data engineering solution to import the customers’ data from the SAP Hana database to Azure Data Lake Storage Gen 2 using Azure Data Factory. Which type would you suggest to use?

Select 1 option(s):

Insert operation

None

Lookup activity

Copy activity

Q13. You are designing a monitoring solution for Azure SQL Data Warehouse. You need to receive an alert when Azure SQL Data Warehouse consumes the maximum allotted resources. Which metric would you monitor?

Select 1 option(s):

CPU percentage

Memory percentage

DWU used

Data IO percentage

DWU limit

Q14. You are designing a solution that will use Azure Stream Analytics for near real-time stream processing. The solution will need to use reference data which is a finite data set that is static or slowly changing in nature and join it with real-time data streams. What would you use to store reference data? The solution must minimise the cost. Please select the correct answer.

Select 1 option(s):

Azure Blob Storage

Azure Event Hubs

Azure IoT Hub

Azure Cosmos DB

Q15. You are designing a storage solution for a big data pipeline. The solution must meet the following requirements:

– can store an unlimited amount of data
– ability to run massively parallel analytics
– organizes objects/ files into a hierarchy of directories for efficient data access
– minimise the costs
What would you choose?

Select 1 option(s):

Azure Data Lake Storage Gen 2

Azure Table Storage

Azure Blob Storage

Azure Cosmos DB

Q16. You are designing a storage solution for a big data workflow. The solution must the following requirements:

– collection of objects/files within a storage account to be organized into a hierarchy of directories and nested subdirectories in the same way that the file system on your computer is organized.
– ability to store data of any size
– optimised for parallel analytics workloads

Select 1 option(s):

Azure Data Lake Gen2

Azure Cosmos DB

Azure Blob Storage

Azure Table Storage

Q17. You are designing an Azure SQL Database on Azure that will need to deal with sensitive customer information. You need to ensure that data remains encrypted while at rest on the server, during movement between client and server, and while the data is in use, ensuring that sensitive data never appears as plaintext inside the database system.

What would you recommend?

Select 1 option(s):

Azure Disk Encryption

Always Encrypted

SQL Server Always on Availability Group

TLS

Transparent Data Encryption (TDE)

Q18. You are designing an IoT solution for an Insurance company that will use the capabilities of Microsoft Azure to gain real-time, predictive insights on vehicle health and driving habits for insurance policy pricing purposes. Your solution would include millions of IoT telematics sensors that would send data to the event hubs, stream processing fully managed solution on Azure for gaining real-time insights on vehicle health and persists that data into long-term storage for richer batch analytics, ML Studio for anomaly detection in real-time and batch processing to gain predictive insights.HDInsight is leveraged to transform data at scale, and Data Factory handles orchestration, scheduling, resource management, and monitoring of the batch processing pipeline. Finally, Power BI gives this solution a rich dashboard for real-time data and predictive analytics visualizations.

Which streaming solution would you recommend?

Select 1 option(s):

Azure Data Fabric

Azure HDInsight with Spark Streaming

Apache Hadoop

Azure Stream Analytics

Q19. You are designing big data engineering solutions for a fashion company. The solution requires the analytics of a large amount of data and has the following requirements:

– Integration with Microsoft Power BI for discovering and sharing impactful insights quickly and easily
– Fully managed Spark Clusters
– Dynamically autoscale clusters up and down, including serverless clusters, and share them across teams.
Which Azure service should you recommend?

Select 1 option(s):

Azure Databricks

Blob Storage Account

ML Studio

Azure HDInsight

Q20. You are designing the access tier for a blob storage account that will store TBs of customer data for auditing purposes. The data needs to be kept for a few years and the rehydrating a blob from an archive can take several hours. Your solution should minimise the costs. What would you propose?

Select 1 option(s):

Cold Access Tier

None

Archive Access Tier

Hot Access Tier

Q21. You are designing the access tier for a blob storage account that will store TBs of customer older media content which will be viewed frequently but is expected to be available immediately when accessed. Your solution should minimise the costs. What would you propose?

Select 1 option(s):

Hot Access Tier

None

Archive Access Tier

Cold Access Tier

Q22. You are designing the access tier for a blob storage account that will store TBs of customer older media content which will not be viewed frequently but is expected to be available immediately when accessed. Your solution should minimise the costs. What would you propose?

Select 1 option(s):

Cold Access Tier

Hot Access Tier

Archive Access Tier

None

Q23. You are developing a mission-critical IoT solution for real-time analysis of sensors data that will use Azure Stream Analytics. The solution must remain available even during Azure Stream Analytics service updates. How would you achieve this goal? Please select all the correct answers.

Select 2 option(s):

Monitor jobs to get notified when something unexpected happens

Deploy identical azure stream analytics jobs to any two regions

Deploy identical azure stream analytics jobs to both paired regions

Monitor any of two deployed jobs and get notified when something unexpected happens

Deploy identical azure stream analytics jobs to two different availability zones

Q24. You are developing a new data pipeline process for your company that will use PaaS on Microsoft Azure. The data ingestion process must meet the following requirements: – Provide the ability to access multiple data sources (on-prem and cloud) – Work as a workflow orchestrator – Provide the capability to run SQL Server Integration Services packages. Which technology would you use?

Select 1 option(s):

Azure Logic Apps

Azure ML Studio

Azure Functions

Azure Data Factory

Q25. You are developing a new data pipeline process for your company that will use PaaS on Microsoft Azure. The data prepare and train solution must meet the following requirements: – Provide the ability to program in R, SQL, Python and Scala – Provide a fully-managed and interactive workspace for exploration and visualization – Provide seamless user authentication with Azure Active Directory Which technology would you use?

Select 1 option(s):

Azure Data Lake Gen1

Azure Databricks

None

Azure Cosmos DB

Azure Data Lake Gen2

Q26. You are developing a new data pipeline process for your company that will use PaaS on Microsoft Azure. The data storage solution must meet the following requirements: – can store petabytes (PB) of various data types – optimised storage for big data workloads – uses hierarchical namespaces What would you choose?

Select 1 option(s):

Azure Data Lake Gen2

Azure Blob Storage

Azure Table Storage

Azure SQL Hyper-Scale tier

Azure File Storage

Q27. You are hired as a cloud consultant by an accounting company to help them deploy a storage solution on Azure, that will be used as object storage (Azure Blob) to store scanned invoices. An external (partner) organisation will need to have access to these files (invoices) during the next 60 days in order to train their OCR ML model. You need to propose a solution that would meet the following requirements:

– ensure that only the partner organisation can access the storage account
– ensure that access is removed automatically after 60 days.
What would you include in the recommendation?

Select 1 option(s):

Shared Access Signature (SAS)

Azure Policy

Shared Keys

Always Encrypted

Q28. You are implementing a big data streaming solution using Azure Stream Analytics. For data ingestion, you have deployed Azure Event Hubs and you are about to write a data transformation query that will apply one of the windowing functions. If you need to segment the data stream into distinct time segments that repeat but never overlap. Which windowing function would you use?

Select 1 option(s):

Hopping

Sliding

Tumbling

Session

None

Q29. You are working as a cloud architect for a big construction company. Your application development team is currently working on designing a new app that will use Azure SQL Database to store the data about construction sites, employees, resources and suppliers. The app needs to able to generate different reports (text documents) for different stakeholders within the company. These reports should be stored in an Azure storage solution that supports SMB 3.0.

Which Azure data storage type should you recommend?

Select 1 option(s):

Azure Blob Storage

Azure Table Storage

Azure Queue

Azure File Storage

Q30. You are working as a cloud architect for a big energy company. Storing energy is not cost-effective, so utilities and power generators need to forecast future power consumption so that they can efficiently balance the supply with the demand. During peak hours, short supply can result in power outages. Conversely, too much supply can result in a waste of resources. Advanced demand forecasting techniques detail hourly demand and peak hours for a particular day, allowing an energy provider to optimize the power generation process. You need to design a demand forecasting solution for your company as per the diagram below:

Which services would you recommend for forecast/ predictive service, storage of the prediction results and model retraining pipeline orchestration? Your solution should minimise the costs.

Select 1 option(s):

Azure Machine Learning, Azure SQL Database, Azure Data Factory

Azure Machine Learning, Azure Cosmos Database, Azure Data Factory

Azure Machine Learning, Azure Synapse Analytics, Azure Data Factory

Azure Cognitive Services, Azure Cosmos Mongo Database, Azure Analytics Services

Q31. You are working as a cloud architect for a big energy company. Storing energy is not cost-effective, so utilities and power generators need to forecast future power consumption so that they can efficiently balance the supply with the demand. During peak hours, short supply can result in power outages. Conversely, too much supply can result in a waste of resources. Advanced demand forecasting techniques detail hourly demand and peak hours for a particular day, allowing an energy provider to optimize the power generation process. You need to design a demand forecasting solution for your company as per the diagram below:

Which services would you recommend for data ingestion, real-time analytics and storing the reference data? Your solution should minimise the costs.

Select 1 option(s):

Event Hubs, Data Factory and Azure SQL Database

Event Hubs, Azure Stream Analytics and Blob Storage

IoT Hub, Data Factory and Azure SQL Database

IoT Hub, Azure Stream Analytics and Blob Storage

None

Q32. You are working as a cloud architect for a taxi company in London. The taxi company collects data about each taxi trip. You are asked to design a big data pipeline with the following stages: ingest, process, store, and analysis and reporting. The pipeline ingests data from two sources, performs a join on related records from each stream, enriches the result, and calculates an average in real-time. The results are stored for further analysis. You have concluded interviews with the key stakeholders and agreed that the design should look like (see the image below)

Which Azure service would you use to correlate the taxi ride and fare data, and also enrich the correlated data with neighbourhood data stored in the file system?

Select 1 option(s):

Azure Data Lake Storage Gen1

Azure Function

Azure SQL Database

Azure Databricks

Power BI

Q33. You are working as a cloud architect for a taxi company in London. The taxi company collects data about each taxi trip. You are asked to design a big data pipeline with the following stages: ingest, process, store, and analysis and reporting. The pipeline ingests data from two sources, performs a join on related records from each stream, enriches the result, and calculates an average in real-time. The results are stored for further analysis. You have concluded interviews with the key stakeholders and agreed that the design should look like (see the image below)

Which Azure service would you use for data visualisation and reporting purposes?

Select 1 option(s):

Azure Synapse

Apache Spark

Azure IoT Hub

Microsoft Power BI

Azure Event Hubs

Q34. You are working as a cloud architect for a taxi company in London. The taxi company collects data about each taxi trip. You are asked to design a big data pipeline with the following stages: ingest, process, store, and analysis and reporting. The pipeline ingests data from two sources, performs a join on related records from each stream, enriches the result, and calculates an average in real-time. The results are stored for further analysis. You have concluded interviews with the key stakeholders and agreed that the design should look like (see the image below)

Which Azure service would you use to store the output of Big Data Analytics Job (the data store and serve block on the image) which will be a series of records, for data visualisation and reporting purposes?

Select 1 option(s):

Azure Blob Storage

Azure HDInsight

Azure Databricks

Azure Cosmos DB

Azure File Storage

Q35. You are working as a cloud architect for a taxi company in London. The taxi company collects data about each taxi trip. You are asked to design a big data pipeline with the following stages: ingest, process, store, and analysis and reporting. The pipeline ingests data from two sources, performs a join on related records from each stream, enriches the result, and calculates an average in real-time. The results are stored for further analysis. You have concluded interviews with the key stakeholders and agreed that the design should look like (see the image below)

Which Azure service would you use for data ingestion?

Select 1 option(s):

Azure Event Hubs

Azure Logic Apps

Azure Blob Storage

Azure Function

Azure Databricks

Q36. You are working as a cloud architect helping an enterprise customer migrate their application portfolio to Azure. Their applications are spread across multiple different public clouds as well as hosted internally. What tool/service would allow you to migrate the data from these applications to Azure?

Select 1 option(s):

Apache Casandra

Data Migration Assistant

AzCopy

Data Factory

Power Shell

Q37. You are working as a cloud consultant for a big retailer company. Your client is considering to import the products reference data, which are stored in Azure Blob Storage, into Azure Synapse Analytics by using PolyBase. What are the steps that need to be done when moving the data from Blob Storage to Azure Synapse Analytics? Please select the all correct answers.

Select 5 option(s):

Define the import file format

Create an internal source connection

Create a destination table

Create an external source connection

Create a database scoped credential that secures the credentials to the blob storage

Create a temporary table

Q38. You are working as a cloud solutions architect for a global media company. Your team is working on the design of a data solution that will support the analysis of social networks data in real-time.

Which two Azure services would you include in the solution?

Select 2 option(s):

Azure Event Hubs

Azure Table Storage

Azure Data Lake Storage Gen1

Azure IoT Hub

Azure Databricks

Q39. You are working as a data architect for a big retailer. The retailer uses Azure Blob Storage to store the sales data in a raw form. You are asked to build a data pipeline using Azure Data Factory that would copy the data from blob storage every time the new data has been added. How should you configure the trigger for data pipeline?

Select 1 option(s):

Use manual trigger

None

Use event-based trigger

Use schedule trigger

Use tumbling window trigger

Q40. You are working as a data architect for a global insurance company. Your team needs to design a big data processing solution that meets the following requirements:

– Support for the following languages: R, Python, Java, Scala, Spark SQL
– User authentication with Azure Active Directory
– Fast cluster start times, auto termination and autoscaling
– Manages the Apache Spark cluster for you
What would you suggest?

Select 1 option(s):

Azure Analysis

Azure SQL Database

Azure Cosmos Database

Azure HDInsight

Azure Databricks

Q41. You are working as a data architect for a major insurance company. You need to ensure that the call centre agents are able to verify caller’s identity on a phone call, asking for the last 4 characters of Insurance Policy Number, while the remaining characters are hidden for security purpose. What technique you would apply to protect the customers’ data within the Azure SQL Database?

Select 1 option(s):

Security certificates

Geo-replication

Row-level security

Dynamic Data Masking (DDM)

Q42. You are working as a data architect for an oil & gas company. Company stores data in Azure Blob Storage account and wants to build a data pipeline that would run once a day and which would copy the data from Azure Blob Storage Account to Azure SQL Datawarehouse using Azure Data Factory. Which type of integration runtime this pipeline would use?

Select 1 option(s):

Azure-SSIS integration runtime

Self-hosted integration runtime

Azure Integration Runtime

Q43. You are working as a data engineer for a big energy corporation. Your company prefers IaaS deployment on Microsoft Azure and you are asked to recommend the most convenient solution for storing VM disks. What would you choose?

Select 1 option(s):

Azure SQL Database

Azure Block Blob

Azure Cosmos DB

Azure Table Storage

Azure Page Blob

Q44. You are working as a data engineer for a big fashion company. Your team is asked to work on designing a big data solution that will analyse streaming data (sentiment analysis) from twitter in order to improve customer satisfaction.

What would you use for data ingestion and running data analytics jobs?

Select 1 option(s):

Azure Data Lake Storage Gen 2 and Azure Databricks

Azure IoT Hubs and Blob Storage

Azure Event Hubs and Azure Databricks

Azure IoT Hubs

Azure Data Factory

Q45. You are working as a data engineer for a big fashion company. Your team needs to design big data processing solution on Microsoft Azure, that would meet the following criteria:

– managed Hadoop service
– support for languages: R, Python, Java, Scala, SQL
– authentication with Active Directory
What would you suggest?

Select 1 option(s):

Azure Cosmos DB

Azure HDInsight

Azure SQL DB

Azure Databricks

Q46. You are working as a data engineer for a big financial company. You need to design an application that would accept stock market information as an input and using the machine learning classification model classify the input data into two categories: stocks that you should sell and stocks that you should keep.

What would you recommend to train the model?

Select 1 option(s):

Power BI Models

Apache Spark MLlib

Text Analytics API

Computer Vision API

Q47. You are working as a data engineer for a company that has many regional branches. You are considering using Azure SQL elastic pool in order to make some costs savings. Which 2 (two) factors would you consider while determining the pool size? Please select the correct answers.

Select 2 option(s):

Storage space needed for the pool

Azure automation

Minimum number of transactions

Maximum resources utilized by all databases in the pool

Q48. You are working as a data engineer for a company that has on-prem and cloud-based infrastructure. You are asked to configure the data synchronisation between an on-prem SQL database hosted on Microsoft SQL Server and Azure SQL Database. The synchronisation process must perform the initial data synchronisation to Azure SQL database with minimal downtime and perform bi-directional synchronisation afterwards. Which service would you use?

Select 1 option(s):

Data Migration Assistant (DMA)

Data replication service

Agent Job

SQL Data Sync

Backup Service

Q49. You are working as a data engineer for a major global bank. You have 15TB of customers data stored in the Azure Data Lake Storage account and you need to load the data to Azure Synapse (SQL DW) staging table using PolyBase. Which kind of Distributed Table would you choose in Synapse SQL pool in order to load the data in the most efficient way?

Select 1 option(s):

Geo-distributed table

Hash - distributed table

Round-robin distributed table

Replicated table

None

Q50. You are working as a data engineer for a major insurance company. The company operates during normal working hours in many regions (branches) across the world. Each branch must be provided with its own Azure SQL database while maximising performance and minimize cost. The daily claims data for each branch must be stored in its Azure SQL database. How would you provision Azure SQL database instances?

Select 1 option(s):

Azure SQL Database Hyper-scale

Azure SQL Database premium

Azure SQL Database Elastic Pool

Azure SQL Database managed instance

Data Engineering on Microsoft Azure Test 2

Q2. You are considering to deploy an Azure Databricks interactive cluster. You need to ensure that the cluster configuration is kept, even if the cluster is inactive for more than 30 days.

Q3. You are designing a big data analytics solution that will use azure stream analytics to analyse real-time twitter data with hashtag #cloud. Which windowing function would you recommend to be used in your query, if you need to give every 5 seconds the count of tweets over the last 10 seconds?

Q4. You are designing a big data engineering solution on Microsoft Azure. Some of the key requirements that your solution needs to meet are the following:

Q5. You are designing a big data solution for leading healthcare provider that will use Azure Synapse. A health care provider allows only doctors and nurses to have access to sensitive medical records while not allowing members of the billing department to view this data.

Q6. You are designing a big data solution that will use Azure SQL Data Warehouse. You expect to load millions of rows of data into the data warehouse each day. You must ensure that staging tables are optimized for data loading. You need to design the staging tables.

Q7. You are designing a big data solution that will use Azure Synapse. The solution must be able to load millions of rows of data into the Azure Synapse once a week (on Friday) in the most efficient way possible. Which type of distributed table would you choose?

Q8. You are designing a data engineering solution for data stream processing. You need to recommend a solution for data ingestion, in order to meet the following requirements:

Q9. You are designing a data engineering solution that will use Azure Databricks. Which 2 capabilities are only available on premium service tier?

Q10. You are designing a data engineering solution to copy telemetry data from Azure Blob Storage to Azure Data Lake Storage Gen 2 using Azure Data Factory. There is no need to perform data integration securely in a private network environment. Which integration runtime would you suggest to use?

Q11. You are designing a data engineering solution to import the customers’ data from the SAP Hana database to Azure Data Lake Storage Gen 2 using Azure Data Factory. Which Integration runtime would you suggest to use?

Q12. You are designing a data engineering solution to import the customers’ data from the SAP Hana database to Azure Data Lake Storage Gen 2 using Azure Data Factory. Which type would you suggest to use?

Q13. You are designing a monitoring solution for Azure SQL Data Warehouse. You need to receive an alert when Azure SQL Data Warehouse consumes the maximum allotted resources. Which metric would you monitor?

Q15. You are designing a storage solution for a big data pipeline. The solution must meet the following requirements:

Q16. You are designing a storage solution for a big data workflow. The solution must the following requirements:

Q19. You are designing big data engineering solutions for a fashion company. The solution requires the analytics of a large amount of data and has the following requirements:

Q20. You are designing the access tier for a blob storage account that will store TBs of customer data for auditing purposes. The data needs to be kept for a few years and the rehydrating a blob from an archive can take several hours. Your solution should minimise the costs. What would you propose?

Q21. You are designing the access tier for a blob storage account that will store TBs of customer older media content which will be viewed frequently but is expected to be available immediately when accessed. Your solution should minimise the costs. What would you propose?

Q22. You are designing the access tier for a blob storage account that will store TBs of customer older media content which will not be viewed frequently but is expected to be available immediately when accessed. Your solution should minimise the costs. What would you propose?

Q23. You are developing a mission-critical IoT solution for real-time analysis of sensors data that will use Azure Stream Analytics. The solution must remain available even during Azure Stream Analytics service updates. How would you achieve this goal? Please select all the correct answers.

Q38. You are working as a cloud solutions architect for a global media company. Your team is working on the design of a data solution that will support the analysis of social networks data in real-time.

Q40. You are working as a data architect for a global insurance company. Your team needs to design a big data processing solution that meets the following requirements:

Q43. You are working as a data engineer for a big energy corporation. Your company prefers IaaS deployment on Microsoft Azure and you are asked to recommend the most convenient solution for storing VM disks. What would you choose?

Q44. You are working as a data engineer for a big fashion company. Your team is asked to work on designing a big data solution that will analyse streaming data (sentiment analysis) from twitter in order to improve customer satisfaction.

Q45. You are working as a data engineer for a big fashion company. Your team needs to design big data processing solution on Microsoft Azure, that would meet the following criteria:

Q47. You are working as a data engineer for a company that has many regional branches. You are considering using Azure SQL elastic pool in order to make some costs savings. Which 2 (two) factors would you consider while determining the pool size? Please select the correct answers.

(510) 550 - 7200

39141 Civic Center Dr, Suite 201, Fremont, CA 94539, US

Software Development

Tech Upskilling

IT Staffing Solutions

Data Engineering on Microsoft Azure Test 2

Q2. You are considering to deploy an Azure Databricks interactive cluster. You need to ensure that the cluster configuration is kept, even if the cluster is inactive for more than 30 days.

Q3. You are designing a big data analytics solution that will use azure stream analytics to analyse real-time twitter data with hashtag #cloud. Which windowing function would you recommend to be used in your query, if you need to give every 5 seconds the count of tweets over the last 10 seconds?

Q4. You are designing a big data engineering solution on Microsoft Azure. Some of the key requirements that your solution needs to meet are the following:

Q5. You are designing a big data solution for leading healthcare provider that will use Azure Synapse. A health care provider allows only doctors and nurses to have access to sensitive medical records while not allowing members of the billing department to view this data.

Q6. You are designing a big data solution that will use Azure SQL Data Warehouse. You expect to load millions of rows of data into the data warehouse each day. You must ensure that staging tables are optimized for data loading. You need to design the staging tables.

Q7. You are designing a big data solution that will use Azure Synapse. The solution must be able to load millions of rows of data into the Azure Synapse once a week (on Friday) in the most efficient way possible. Which type of distributed table would you choose?

Q8. You are designing a data engineering solution for data stream processing. You need to recommend a solution for data ingestion, in order to meet the following requirements:

Q9. You are designing a data engineering solution that will use Azure Databricks. Which 2 capabilities are only available on premium service tier?

Q10. You are designing a data engineering solution to copy telemetry data from Azure Blob Storage to Azure Data Lake Storage Gen 2 using Azure Data Factory. There is no need to perform data integration securely in a private network environment. Which integration runtime would you suggest to use?

Q11. You are designing a data engineering solution to import the customers’ data from the SAP Hana database to Azure Data Lake Storage Gen 2 using Azure Data Factory. Which Integration runtime would you suggest to use?

Q12. You are designing a data engineering solution to import the customers’ data from the SAP Hana database to Azure Data Lake Storage Gen 2 using Azure Data Factory. Which type would you suggest to use?

Q13. You are designing a monitoring solution for Azure SQL Data Warehouse. You need to receive an alert when Azure SQL Data Warehouse consumes the maximum allotted resources. Which metric would you monitor?

Q15. You are designing a storage solution for a big data pipeline. The solution must meet the following requirements:

Q16. You are designing a storage solution for a big data workflow. The solution must the following requirements:

Q19. You are designing big data engineering solutions for a fashion company. The solution requires the analytics of a large amount of data and has the following requirements:

Q20. You are designing the access tier for a blob storage account that will store TBs of customer data for auditing purposes. The data needs to be kept for a few years and the rehydrating a blob from an archive can take several hours. Your solution should minimise the costs. What would you propose?

Q21. You are designing the access tier for a blob storage account that will store TBs of customer older media content which will be viewed frequently but is expected to be available immediately when accessed. Your solution should minimise the costs. What would you propose?

Q22. You are designing the access tier for a blob storage account that will store TBs of customer older media content which will not be viewed frequently but is expected to be available immediately when accessed. Your solution should minimise the costs. What would you propose?

Q23. You are developing a mission-critical IoT solution for real-time analysis of sensors data that will use Azure Stream Analytics. The solution must remain available even during Azure Stream Analytics service updates. How would you achieve this goal? Please select all the correct answers.

Q38. You are working as a cloud solutions architect for a global media company. Your team is working on the design of a data solution that will support the analysis of social networks data in real-time.

Q40. You are working as a data architect for a global insurance company. Your team needs to design a big data processing solution that meets the following requirements:

Q43. You are working as a data engineer for a big energy corporation. Your company prefers IaaS deployment on Microsoft Azure and you are asked to recommend the most convenient solution for storing VM disks. What would you choose?

Q44. You are working as a data engineer for a big fashion company. Your team is asked to work on designing a big data solution that will analyse streaming data (sentiment analysis) from twitter in order to improve customer satisfaction.

Q45. You are working as a data engineer for a big fashion company. Your team needs to design big data processing solution on Microsoft Azure, that would meet the following criteria:

Q47. You are working as a data engineer for a company that has many regional branches. You are considering using Azure SQL elastic pool in order to make some costs savings. Which 2 (two) factors would you consider while determining the pool size? Please select the correct answers.

Contact Us