DRAG DROP -You need to create a linked service in Microsoft Azure Data Factory. The linked service must use an Azure Database for MySQL table named Customers.How should you complete the JSON snippet? To answer, drag the appropriate values to the correct targets. Each value 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:
You are designing a Microsoft Azure analytics solution. The solution requires that the data be copied from Azure Blob storage to Azure Data Lake Store.The data will be copied on a recurring schedule. Occasionally, the data will be copied manually.You need to recommend a solution to copy the data.Which tool should you include in the recommendation? To answer, drag the appropriate tools to the correct requirements. Each tool may be used once, or not at all. You may need to frag the split bar between panes or scroll to view content.NOTE: Each correct selection is worth one point.Select and Place:
DRAG DROP -You plan to use U-SQL to run federated queries to join data from a Microsoft Azure SQL data warehouse, an Azure SQL database, and a Microsoft Server database on an Azure virtual machine.You need to ensure that you can use a U-SQL query that joins all three data sources. The solution must ensure that the three data sources appear as tables in U-SQL without having to move the data from external sources.Which three statements should you execute in sequence? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.Select and Place:
You have a Microsoft Azure Data Lake Analytics service.You need to write a U-SQL query to extract from a CSV file all the users who live in Boston, and then to save the results in a new CSV file.Which U-SQL script should you use?A.B.C.D.
You have a Microsoft Azure Data Lake Analytics service and an Azure Data Lake Store.You need to use Python to submit a U-SQL job.Which Python module should you install?
You are implementing a solution by using Microsoft Azure Data Lake Analytics.You have a dataset that contains data-related to website visits.You need to combine overlapping visits into a single entry based on the timestamp of the visits.Which type of U-SQL interface should you use?
