You develop data engineering solutions for a company. You must migrate data from Microsoft Azure Blob storage to an Azure SQL Data Warehouse for further transformation. You need to implement the solution.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:
- Provision an azure SQL Data Warehouse Instance
- Connect to the Blob Storage container by using SQL Server Management Studio
- Provision an Azure Blob Storage container
- Run Transact-SQL statement to load data
- connect to the Azure SQL Data Warehouse by using SQL Server Management studio
- Build external tables by using Azure Portal
- Build external tables by using SQL server Management Studio
- Provision an azure SQL Data Warehouse Instance
- Connect to the Blob Storage container by using SQL Server Management Studio
- Build external tables by using SQL server Management Studio
- Run Transact-SQL statement to load data
You are developing the data platform for a global retail company. The company operates during normal working hours in each region. The analytical database is used once a week for building sales projections.
Each region maintains its own private virtual network.
Building the sales projections is very resource intensive are generates upwards of 20 terabytes (TB) of data.
Microsoft Azure SQL Databases must be provisioned.
-> Database provisioning must maximize performance and minimize cost
-> The daily sales for each region must be stored in an Azure SQL Database instance
-> Once a day, the data for all regions must be loaded in an analytical Azure SQL Database instance
You need to provision Azure SQL database instances.
How should you provision the database instances? To answer, drag the appropriate Azure SQL products to the correct databases. Each Azure SQL product may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:
Azure SQL Product
- Azure SQL Database elastic pools
- Azure SQL Database premium
- Azure SQL Database Management Instance
- Azure SQL Database Hyperscale
Daily Sales???
Weekly Analysis???
Daily Sales???
-Azure SQL Database elastic pools
Weekly Analysis???
-Azure SQL Database Hyperscale
You are developing a solution to visualize multiple terabytes of geospatial data.
The solution has the following requirements:
-> Data must be encrypted.
-> Data must be accessible by multiple resources on Microsoft Azure.
You need to provision storage for the solution.
Which four actions should you perform in sequence? To answer, move the appropriate action from the list of actions to the answer area and arrange them in the correct order.
Select and Place:
- Enable encryption on the Azure Data Lake using the Azure Portal
- Add an access policy for the new Azure Data Lake account to the key storage container
- Create a new Azure Data Lake Storage account with Azure data lake managed encryptions keys
- select and configure and encryptions key storage container
- Create a new Azure Data Lake Storage account with azure key vault manage encryptions keys
- Create a new Azure Data lake Storage account with encryption disable
- Create a new Azure Data Lake Storage account with azure key vault manage encryptions keys
- select and configure and encryptions key storage container
- Add an access policy for the new Azure Data Lake account to the key storage container
- Enable encryption on the Azure Data Lake using the Azure Portal
Your company has on-premises Microsoft SQL Server instance.
The data engineering team plans to implement a process that copies data from the SQL Server instance to Azure Blob storage. The process must orchestrate and manage the data lifecycle.
You need to configure Azure Data Factory to connect to the SQL Server instance.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:
- Configure a linked service to connect to the SQL server instance
- From the on-premise network, install and configure a self-hosted runtime
- from the SQL server, backup the database and then copy the database to Azure Blob storage
- Deploy an Azure Data Factory
- From the SQL server, create a database master key.
- Deploy an Azure Data Factory
- From the on-premise network, install and configure a self-hosted runtime
- Configure a linked service to connect to the SQL server instance
DRAG DROP -
You are responsible for providing access to an Azure Data Lake Storage Gen2 account.
Your user account has contributor access to the storage account, and you have the application ID and access key.
You plan to use PolyBase to load data into an enterprise data warehouse in Azure Synapse Analytics.
You need to configure PolyBase to connect the data warehouse to the storage account.
Which three components should you create in sequence? To answer, move the appropriate components from the list of components to the answer are and arrange them in the correct order.
Select and Place:
- a database encryption key
- an asymmetric key
- an external data source
- an external file format
- a database scoped credential
- a database scoped credential
- an external data source
- an external file format
DRAG DROP -
You have a table named SalesFact in an enterprise data warehouse in Azure Synapse Analytics. SalesFact contains sales data from the past 36 months and has the following characteristics:
-> Is partitioned by month
-> Contains one billion rows
-> Has clustered columnstore indexes
At the beginning of each month, you need to remove data from SalesFact that is older than 36 months as quickly as possible.
Which three actions should you perform in sequence in a stored procedure? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:
- Create an empty table named salesfact_work that has the same schema as salesfact
- Drop the SalesFact_Work table
- Copy the data to a new table by using Create Table as Select (CTAS)
- Truncate the partition containing the stale data
- Switch the partition containing the stale data from SalesFact to SalesFact_Work.
- Execute a Delete statement where the value in the Date colimn is more than 36 months Ago.
- Create an empty table named salesfact_work that has the same schema as salesfact
- Switch the partition containing the stale data from SalesFact to SalesFact_Work.
- Drop the SalesFact_Work table
