<< Prev Question Next Question >>

Question 91/95

You are creating an Azure Data Factory data flow that will ingest data from a CSV file, cast columns to specified types of data, and insert the data into a table in an Azure Synapse Analytics dedicated SQL pool. The CSV file contains columns named username, comment and date.
The data flow already contains the following:
* A source transformation
* A Derived Column transformation to set the appropriate types of data
* A sink transformation to land the data in the pool
You need to ensure that the data flow meets the following requirements;
* All valid rows must be written to the destination table.
* Truncation errors in the comment column must be avoided proactively.
* Any rows containing comment values that will cause truncation errors upon insert must be written to a file in blob storage.
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point

LEAVE A REPLY

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

Question List (95q)
Question 1: You plan to develop a dataset named Purchases by using Azure...
Question 2: You build an Azure Data Factory pipeline to move data from a...
Question 3: You have a C# application that process data from an Azure Io...
Question 4: You have an Azure Factory instance named DF1 that contains a...
Question 5: You have an Azure Synapse Analytics dedicated SQL pool that ...
Question 6: You are monitoring an Azure Stream Analytics job. You discov...
Question 7: You are monitoring an Azure Stream Analytics job by using me...
Question 8: The storage account container view is shown in the Refdata e...
Question 9: You have an Azure Databricks workspace named workspace! in t...
Question 10: You are designing a star schema for a dataset that contains ...
Question 11: You implement an enterprise data warehouse in Azure Synapse ...
Question 12: You have an Azure Storage account that generates 200.000 new...
Question 13: You are implementing a batch dataset in the Parquet format. ...
Question 14: You have an Azure Synapse Analytics dedicated SQL pool named...
Question 15: You develop data engineering solutions for a company. A proj...
Question 16: You have two Azure Storage accounts named Storage1 and Stora...
Question 17: You are creating a new notebook in Azure Databricks that wil...
Question 18: You have an enterprise data warehouse in Azure Synapse Analy...
Question 19: You build a data warehouse in an Azure Synapse Analytics ded...
Question 20: You have an Azure Synapse Analytics Apache Spark pool named ...
Question 21: You have an Azure Synapse Analytics dedicated SQL pool named...
Question 22: Note: This question is part of a series of questions that pr...
Question 23: Note: This question is part of a series of questions that pr...
Question 24: You have two fact tables named Flight and Weather. Queries t...
Question 25: You need to ensure that the Twitter feed data can be analyze...
Question 26: You are designing an Azure Stream Analytics job to process i...
Question 27: You are designing the folder structure for an Azure Data Lak...
Question 28: Which Azure Data Factory components should you recommend usi...
Question 29: You have an Azure Synapse workspace named MyWorkspace that c...
Question 30: You have an Azure Data lake Storage account that contains a ...
Question 31: You need to design a data retention solution for the Twitter...
Question 32: You have an Azure Data Lake Storage Gen2 account that contai...
Question 33: You have an Azure Databricks workspace named workspace1 in t...
Question 34: You are building an Azure Stream Analytics job that queries ...
Question 35: You have an Azure Synapse Analytics dedicated SQL pool named...
Question 36: You need to design an Azure Synapse Analytics dedicated SQL ...
Question 37: You are designing a partition strategy for a fact table in a...
Question 38: You have a SQL pool in Azure Synapse that contains a table n...
Question 39: You are planning the deployment of Azure Data Lake Storage G...
Question 40: You have an Azure Synapse Analytics serverless SQL pool name...
Question 41: Note: This question is part of a series of questions that pr...
Question 42: You have an Azure Data Lake Storage account that has a virtu...
Question 43: You have an Azure SQL database named Database1 and two Azure...
Question 44: You have an Azure Data Factory pipeline that contains a data...
Question 45: You need to collect application metrics, streaming query eve...
Question 46: You have an Azure Data Lake Storage Gen2 account that contai...
Question 47: You configure version control for an Azure Data Factory inst...
Question 48: You need to design a solution that will process streaming da...
Question 49: You have an Azure Data Lake Storage Gen2 container that cont...
Question 50: You have an Azure subscription. You need to deploy an Azure ...
Question 51: You have an Azure Data Lake Storage account that contains a ...
Question 52: You have an Azure Synapse Analytics workspace named WS1 that...
Question 53: A company uses Azure Stream Analytics to monitor devices. Th...
Question 54: You are building an Azure Stream Analytics job to identify h...
Question 55: You have a Microsoft SQL Server database that uses a third n...
Question 56: You are implementing a star schema in an Azure Synapse Analy...
Question 57: You are designing a security model for an Azure Synapse Anal...
Question 58: You are building a database in an Azure Synapse Analytics se...
Question 59: A company has a real-time data analysis solution that is hos...
Question 60: You have an Azure Data Lake Storage Gen2 container. Data is ...
Question 61: You use Azure Data Factory to prepare data to be queried by ...
Question 62: You have an Azure Active Directory (Azure AD) tenant that co...
Question 63: You are designing an enterprise data warehouse in Azure Syna...
Question 64: You plan to create an Azure Synapse Analytics dedicated SQL ...
Question 65: You have an enterprise data warehouse in Azure Synapse Analy...
Question 66: You are designing the folder structure for an Azure Data Lak...
Question 67: You are creating dimensions for a data warehouse in an Azure...
Question 68: You develop a dataset named DBTBL1 by using Azure Databricks...
Question 69: You are creating an Azure Data Factory data flow that will i...
Question 70: You are designing an Azure Stream Analytics solution that re...
Question 71: You have an Azure Data Factory version 2 (V2) resource named...
Question 72: A company purchases IoT devices to monitor manufacturing mac...
Question 73: You are building an Azure Data Factory solution to process d...
Question 74: You have an Azure Data Lake Storage Gen2 account that contai...
Question 75: You have an Azure subscription that is linked to a hybrid Az...
Question 76: You are designing a highly available Azure Data Lake Storage...
Question 77: You have an Azure Synapse Analytics dedicated SQL pool. You ...
Question 78: You have an Azure subscription that contains an Azure Synaps...
Question 79: You have a partitioned table in an Azure Synapse Analytics d...
Question 80: You have an Azure Synapse Analytics dedicated SQL Pool1. Poo...
Question 81: You are designing a real-time dashboard solution that will v...
Question 82: You need to design a data ingestion and storage solution for...
Question 83: You use Azure Data Lake Storage Gen2 to store data that data...
Question 84: Note: This question is part of a series of questions that pr...
Question 85: You need to implement an Azure Databricks cluster that autom...
Question 86: Note: This question is part of a series of questions that pr...
Question 87: You have an Azure Databricks resource. You need to log actio...
Question 88: You need to design a data retention solution for the Twitter...
Question 89: You are designing a streaming data solution that will ingest...
Question 90: You have an Azure subscription that contains an Azure Blob S...
Question 91: You are creating an Azure Data Factory data flow that will i...
Question 92: You are designing an Azure Databricks interactive cluster. T...
Question 93: You need to implement versioned changes to the integration p...
Question 94: You have data stored in thousands of CSV files in Azure Data...
Question 95: You need to schedule an Azure Data Factory pipeline to execu...