HOTSPOT -You have an Azure Synapse Analytics dedicated SQL pool that contains the users shown in the following table.User1 executes a query on the database, and the query returns the results shown in the following exhibit.User1 is the only user who has access to the unmasked data.Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.NOTE: Each correct selection is worth one point.Hot Area:
Note: This question is a part of series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.You develop a data ingestion process that will import data to an enterprise data warehouse in Azure Synapse Analytics. The data to be ingested resides in parquet files stored in an Azure Data Lake Gen 2 storage account.You need to load the data from the Azure Data Lake Gen 2 storage account into the Data Warehouse.Solution:1. Create an external data source pointing to the Azure storage account2. Create a workload group using the Azure storage account name as the pool name3. Load the data using the INSERT`¦SELECT statementDoes the solution meet the goal?
You develop data engineering solutions for a company.You must integrate the company's on-premises Microsoft SQL Server data with Microsoft Azure SQL Database. Data must be transformed incrementally.You need to implement the data integration solution.Which tool should you use to configure a pipeline to copy data?
HOTSPOT -A company runs Microsoft Dynamics CRM with Microsoft SQL Server on-premises. SQL Server Integration Services (SSIS) packages extract data from DynamicsCRM APIs, and load the data into a SQL Server data warehouse.The datacenter is running out of capacity. Because of the network configuration, you must extract on premises data to the cloud over https. You cannot open any additional ports. The solution must implement the least amount of effort.You need to create the pipeline system.Which component should you use? To answer, select the appropriate technology in the dialog box in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
DRAG DROP -You develop data engineering solutions for a company.A project requires analysis of real-time Twitter feeds. Posts that contain specific keywords must be stored and processed on Microsoft Azure and then displayed by using Microsoft Power BI. You need to implement the solution.Which five 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:
You are a data engineer implementing a lambda architecture on Microsoft Azure. You use an open-source big data solution to collect, process, and maintain data.The analytical data store performs poorly.You must implement a solution that meets the following requirements:✑ Provide data warehousing✑ Reduce ongoing management activities✑ Deliver SQL query responses in less than one secondYou need to create an HDInsight cluster to meet the requirements.Which type of cluster should you create?
