Note: This question is part of series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You are monitoring user queries to a Microsoft Azure SQL data warehouse that has six compute nodes.You discover that compute node utilization is uneven. The rows_processed column from sys.dm_pdw_dms_workers shows a significant variation in the number of rows being moved among the distributions. The variation occurs for the same table, using the same query.You need to ensure that the load is distributed evenly across the compute nodes.Solution: You configure joined tables to use a joined distribution column.Does this meet the goal?
Note: This question is part of series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You are monitoring user queries to a Microsoft Azure SQL data warehouse that has six compute nodes.You discover that compute node utilization is uneven. The rows_processed column from sys.dm_pdw_dms_workers shows a significant variation in the number of rows being moved among the distributions. The variation occurs for the same table, using the same query.You need to ensure that the load is distributed evenly across the compute nodes.Solution: You add a nonclustered columnstore index.Does this meet the goal?
You use Microsoft Azure Data Lake Store as the default storage for an Azure HDInsight cluster.You establish an SSH connection to the HDInsight cluster.You need to copy files from the HDInsight cluster to the Data Lake Store.Which command should you use?
DRAG DROP -You need to load data from Microsoft Azure Data Lake store to Azure SQL Data Warehouse by using Transact-SQL.In which sequence should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order.NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.Select and Place:
You are designing a solution that will use Microsoft Azure Data Lake Store.You need to recommend a solution to ensure that the storage service is available if a regional outage occurs. The solution must minimize costs.What should you recommend?
HOTSPOT -You have a Microsoft Azure Data Factory 2 (V2) service.You need to deploy a linked service to an existing database in Azure SQL Data Warehouse.How should you complete the JSON snippet? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
