<< Prev Question Next Question >>

Question 54/127

You plan to ingest streaming social media data by using Azure Stream Analytics. The data will be stored in files in Azure Data Lake Storage, and then consumed by using Azure Datiabricks and PolyBase in Azure Synapse Analytics.
You need to recommend a Stream Analytics data output format to ensure that the queries from Databricks and PolyBase against the files encounter the fewest possible errors. The solution must ensure that the tiles can be queried quickly and that the data type information is retained.
What should you recommend?

LEAVE A REPLY

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

Question List (127q)
Question 1: You have an enterprise-wide Azure Data Lake Storage Gen2 acc...
Question 2: You have an Azure Data Factory pipeline that is triggered ho...
Question 3: You have an Azure Data Lake Storage Gen2 account named accou...
Question 4: You are planning the deployment of Azure Data Lake Storage G...
Question 5: You need to implement an Azure Synapse Analytics database ob...
Question 6: You have the following Azure Data Factory pipelines * ingest...
Question 7: You have an Azure subscription that contains an Azure Synaps...
Question 8: You have an Azure Synapse Analytics serverless SQL pool, an ...
Question 9: You have an Azure Data Lake Storage Gen2 account that contai...
Question 10: You are designing a sales transactions table in an Azure Syn...
Question 11: You are designing an Azure Data Lake Storage solution that w...
Question 12: From a website analytics system, you receive data extracts a...
Question 13: You have an Azure Stream Analytics job that receives clickst...
Question 14: You have an Apache Spark DataFrame named temperatures. A sam...
Question 15: You have an Azure Databricks workspace that contains a Delta...
Question 16: You need to build a solution to ensure that users can query ...
Question 17: You have an Azure Data Factory pipeline shown the following ...
Question 18: You have an activity in an Azure Data Factory pipeline. The ...
Question 19: You need to schedule an Azure Data Factory pipeline to execu...
Question 20: You have an Azure Synapse Analytics dedicated SQL pool that ...
Question 21: You plan to create a table in an Azure Synapse Analytics ded...
Question 22: You are designing an enterprise data warehouse in Azure Syna...
Question 23: You are implementing a batch dataset in the Parquet format. ...
Question 24: You have an Azure Data Factory pipeline that performs an inc...
Question 25: You are batch loading a table in an Azure Synapse Analytics ...
Question 26: You are developing an application that uses Azure Data Lake ...
Question 27: You have an Azure Synapse Analytics dedicated SQL pool that ...
Question 28: You are designing an Azure Synapse Analytics dedicated SQL p...
Question 29: You need to implement versioned changes to the integration p...
Question 30: You have an Azure event hub named retailhub that has 16 part...
Question 31: You are creating an Azure Data Factory data flow that will i...
Question 32: You plan to create a dimension table in Azure Synapse Analyt...
Question 33: You are designing the folder structure for an Azure Data Lak...
Question 34: You build a data warehouse in an Azure Synapse Analytics ded...
Question 35: You plan to create an Azure Synapse Analytics dedicated SQL ...
Question 36: You are designing an Azure Data Lake Storage Gen2 container ...
Question 37: You are planning a streaming data solution that will use Azu...
Question 38: You have an Azure subscription that is linked to a hybrid Az...
Question 39: You have an Azure Databricks resource. You need to log actio...
Question 40: You have an Azure data factory. You need to examine the pipe...
Question 41: You have an Azure Synapse Analystics dedicated SQL pool that...
Question 42: You are designing database for an Azure Synapse Analytics de...
Question 43: You need to design a data ingestion and storage solution for...
Question 44: You are designing an Azure Data Lake Storage Gen2 structure ...
Question 45: A company plans to use Platform-as-a-Service (PaaS) to creat...
Question 46: You are designing a dimension table in an Azure Synapse Anal...
Question 47: Note: This question is part of a series of questions that pr...
Question 48: You have two fact tables named Flight and Weather. Queries t...
Question 49: You are designing a slowly changing dimension (SCD) for supp...
Question 50: You have an Azure subscription that contains the following r...
Question 51: You need to ensure that the Twitter feed data can be analyze...
Question 52: You are building an Azure Analytics query that will receive ...
Question 53: You have an on-premises data warehouse that includes the fol...
Question 54: You plan to ingest streaming social media data by using Azur...
Question 55: You have two Azure Storage accounts named Storage1 and Stora...
Question 56: Note: This question is part of a series of questions that pr...
Question 57: You need to design a solution that will process streaming da...
Question 58: You have an Azure Synapse Analytics dedicated SQL pool named...
Question 59: You need to design an analytical storage solution for the tr...
Question 60: You have an Azure Synapse Analytics dedicated SQL pool named...
Question 61: You are designing an Azure Stream Analytics solution that re...
Question 62: You have an enterprise data warehouse in Azure Synapse Analy...
Question 63: You have a SQL pool in Azure Synapse. You discover that some...
Question 64: You have an Azure data solution that contains an enterprise ...
Question 65: You are designing 2 solution that will use tables in Delta L...
Question 66: You use Azure Stream Analytics to receive Twitter data from ...
Question 67: You are designing a highly available Azure Data Lake Storage...
Question 68: You have an Azure Synapse Analytics dedicated SQL pool named...
Question 69: You are designing an inventory updates table in an Azure Syn...
Question 70: A company has a real-time data analysis solution that is hos...
Question 71: You use Azure Data Factory to prepare data to be queried by ...
Question 72: You have a data model that you plan to implement in a data w...
Question 73: Note: This question is part of a series of questions that pr...
Question 74: You are designing an application that will use an Azure Data...
Question 75: Note: This question is part of a series of questions that pr...
Question 76: You are designing a streaming data solution that will ingest...
Question 77: You are monitoring an Azure Stream Analytics job by using me...
Question 78: You are implementing Azure Stream Analytics windowing functi...
Question 79: You need to create a partitioned table in an Azure Synapse A...
Question 80: You have an Azure Active Directory (Azure AD) tenant that co...
Question 81: You use PySpark in Azure Databricks to parse the following J...
Question 82: You are performing exploratory analysis of the bus fare data...
Question 83: You have an Azure subscription that contains an Azure Data L...
Question 84: You are designing an Azure Synapse Analytics dedicated SQL p...
Question 85: You have a SQL pool in Azure Synapse that contains a table n...
Question 86: You have the Azure Synapse Analytics pipeline shown in the f...
Question 87: You are building a data flow in Azure Data Factory that upse...
Question 88: You have an Azure Stream Analytics job. You need to ensure t...
Question 89: You have an Azure Synapse Analytics job that uses Scala. You...
Question 90: You plan to implement an Azure Data Lake Gen2 storage accoun...
Question 91: You have a Microsoft SQL Server database that uses a third n...
Question 92: You develop data engineering solutions for a company. A proj...
Question 93: Note: This question is part of a series of questions that pr...
Question 94: You configure version control for an Azure Data Factory inst...
Question 95: You have an Azure subscription that contains an Azure Data L...
Question 96: You are building an Azure Data Factory solution to process d...
Question 97: You have an Azure Storage account that generates 200,000 new...
Question 98: You have an Azure subscription. You plan to build a data war...
Question 99: You have a SQL pool in Azure Synapse. You plan to load data ...
Question 100: You are implementing a star schema in an Azure Synapse Analy...
Question 101: You haw an Azure data factory named ADF1. You currently publ...
Question 102: What should you recommend using to secure sensitive customer...
Question 103: You have an Azure subscription that contains an Azure Synaps...
Question 104: A company plans to use Apache Spark analytics to analyze int...
Question 105: You have an Azure Storage account that generates 200.000 new...
Question 106: You are developing a solution using a Lambda architecture on...
Question 107: You are monitoring an Azure Stream Analytics job. You discov...
Question 108: You have an Azure data factory. You need to ensure that pipe...
Question 109: You need to output files from Azure Data Factory. Which file...
Question 110: You are designing a security model for an Azure Synapse Anal...
Question 111: You have an Azure Data Lake Storage Gen2 account that contai...
Question 112: You are monitoring an Azure Stream Analytics job. The Backlo...
Question 113: You are designing a highly available Azure Data Lake Storage...
Question 114: You are designing a solution that will copy Parquet files st...
Question 115: You are designing an Azure Synapse Analytics workspace. You ...
Question 116: You plan to create a real-time monitoring app that alerts us...
Question 117: You need to design a data retention solution for the Twitter...
Question 118: You have two Azure Data Factory instances named ADFdev and A...
Question 119: You have an Azure Data Factory instance that contains two pi...
Question 120: You need to design a data storage structure for the product ...
Question 121: Note: This question is part of a series of questions that pr...
Question 122: You need to design a data retention solution for the Twitter...
Question 123: You have a C# application that process data from an Azure Io...
Question 124: You need to implement an Azure Databricks cluster that autom...
Question 125: You have an Azure Data Factory pipeline that has the activit...
Question 126: You are creating a new notebook in Azure Databricks that wil...
Question 127: You are designing an application that will store petabytes o...