<< Prev Question Next Question >>

Question 76/97

You use Azure Data Factory to prepare data to be queried by Azure Synapse Analytics serverless SQL pools.
Files are initially ingested into an Azure Data Lake Storage Gen2 account as 10 small JSON files. Each file contains the same data attributes and data from a subsidiary of your company.
You need to move the files to a different folder and transform the data to meet the following requirements:
Provide the fastest possible query times.
Automatically infer the schema from the underlying files.
How should you configure the Data Factory copy activity? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (97q)
Question 1: Which Azure Data Factory components should you recommend usi...
Question 2: You need to design a data storage structure for the product ...
Question 3: You have the following Azure Stream Analytics query. (Exhibi...
Question 4: You are designing a date dimension table in an Azure Synapse...
Question 5: You have an Azure Synapse Analytics dedicated SQL pool named...
Question 6: You have an Azure subscription linked to an Azure Active Dir...
Question 7: You use Azure Stream Analytics to receive Twitter data from ...
Question 8: You have an Azure Synapse Analytics dedicated SQL pool that ...
Question 9: Note: This question is part of a series of questions that pr...
Question 10: You have an Azure Data Lake Storage Gen2 account named adls2...
Question 11: You haw an Azure data factory named ADF1. You currently publ...
Question 12: You have an Azure Data Lake Storage Gen2 account named accou...
Question 13: You have an Azure subscription that contains a logical Micro...
Question 14: You are designing an Azure Synapse solution that will provid...
Question 15: Note: This question is part of a series of questions that pr...
Question 16: You have an Apache Spark DataFrame named temperatures. A sam...
Question 17: You are designing an Azure Databricks interactive cluster. T...
Question 18: You are designing a data mart for the human resources (MR) d...
Question 19: You store files in an Azure Data Lake Storage Gen2 container...
Question 20: You need to output files from Azure Data Factory. Which file...
Question 21: You are implementing an Azure Stream Analytics solution to p...
Question 22: You need to design an Azure Synapse Analytics dedicated SQL ...
Question 23: You are designing an Azure Synapse Analytics workspace. You ...
Question 24: You use Azure Data Lake Storage Gen2. You need to ensure tha...
Question 25: You have an Azure Synapse Analytics dedicated SQL pool named...
Question 26: You are implementing a batch dataset in the Parquet format. ...
Question 27: You configure monitoring for a Microsoft Azure SQL Data Ware...
Question 28: You have an Azure Synapse Analytics serverless SQL pool name...
Question 29: You are monitoring an Azure Stream Analytics job by using me...
Question 30: You need to design a data ingestion and storage solution for...
Question 31: You are designing a solution that will copy Parquet files st...
Question 32: You have an Azure data factory. You need to examine the pipe...
Question 33: You are building an Azure Stream Analytics job that queries ...
Question 34: You have an Azure Data Factory instance that contains two pi...
Question 35: You have an Azure subscription that is linked to a hybrid Az...
Question 36: You have an Azure subscription that contains the following r...
Question 37: You plan to create an Azure Synapse Analytics dedicated SQL ...
Question 38: You are designing a streaming data solution that will ingest...
Question 39: You are designing an Azure Data Lake Storage Gen2 structure ...
Question 40: You plan to create an Azure Data Lake Storage Gen2 account Y...
Question 41: You need to design a data retention solution for the Twitter...
Question 42: You are designing a star schema for a dataset that contains ...
Question 43: A company uses Azure Stream Analytics to monitor devices. Th...
Question 44: You are monitoring an Azure Stream Analytics job. You discov...
Question 45: You need to integrate the on-premises data sources and Azure...
Question 46: You need to create an Azure Data Factory pipeline to process...
Question 47: You have an Azure Active Directory (Azure AD) tenant that co...
Question 48: You have a table named SalesFact in an enterprise data wareh...
Question 49: You have an Azure Data Factory instance named ADF1 and two A...
Question 50: Note: This question is part of a series of questions that pr...
Question 51: You build an Azure Data Factory pipeline to move data from a...
Question 52: You manage an enterprise data warehouse in Azure Synapse Ana...
Question 53: You are designing an Azure Synapse Analytics dedicated SQL p...
Question 54: You have an Azure Factory instance named DF1 that contains a...
Question 55: A company purchases IoT devices to monitor manufacturing mac...
Question 56: You have an Azure Data lake Storage account that contains a ...
Question 57: You are designing the folder structure for an Azure Data Lak...
Question 58: You are building an Azure Synapse Analytics dedicated SQL po...
Question 59: You have an Azure Databricks workspace named workspace1 in t...
Question 60: You are planning a solution to aggregate streaming data that...
Question 61: You have an Azure SQL database named Database1 and two Azure...
Question 62: You implement an enterprise data warehouse in Azure Synapse ...
Question 63: You are designing an Azure Databricks table. The table will ...
Question 64: You have an Azure subscription. You need to deploy an Azure ...
Question 65: You are designing an enterprise data warehouse in Azure Syna...
Question 66: You have two fact tables named Flight and Weather. Queries t...
Question 67: Which Azure Data Factory components should you recommend usi...
Question 68: You have an Azure Synapse Analytics dedicated SQL pool that ...
Question 69: You have an Azure Stream Analytics job that receives clickst...
Question 70: You are designing an Azure Synapse Analytics workspace. You ...
Question 71: You need to implement an Azure Databricks cluster that autom...
Question 72: You plan to create a table in an Azure Synapse Analytics ded...
Question 73: You have data stored in thousands of CSV files in Azure Data...
Question 74: You have an Azure Synapse Analytics workspace named WS1 that...
Question 75: You have an enterprise data warehouse in Azure Synapse Analy...
Question 76: You use Azure Data Factory to prepare data to be queried by ...
Question 77: You have an Azure Data Lake Storage account that has a virtu...
Question 78: You have an Azure Synapse Analytics dedicated SQL pool named...
Question 79: You are designing an enterprise data warehouse in Azure Syna...
Question 80: You are designing a financial transactions table in an Azure...
Question 81: You build a data warehouse in an Azure Synapse Analytics ded...
Question 82: You have an Azure subscription that contains an Azure Data L...
Question 83: You configure version control for an Azure Data Factory inst...
Question 84: You plan to monitor an Azure data factory by using the Monit...
Question 85: You have an Azure Synapse workspace named MyWorkspace that c...
Question 86: You have an Azure Synapse Analytics dedicated SQL pool that ...
Question 87: You have an Azure Data Factory pipeline that has the activit...
Question 88: You have the following Azure Stream Analytics query. (Exhibi...
Question 89: You have an Azure Synapse Analytics dedicated SQL pool that ...
Question 90: You are designing a partition strategy for a fact table in a...
Question 91: You are designing a security model for an Azure Synapse Anal...
Question 92: You plan to ingest streaming social media data by using Azur...
Question 93: What should you do to improve high availability of the real-...
Question 94: You are planning a streaming data solution that will use Azu...
Question 95: Note: This question is part of a series of questions that pr...
Question 96: You have an Azure Data Factory version 2 (V2) resource named...
Question 97: You are designing an Azure Databricks cluster that runs user...