- All Exams Instant Download
Which two configurations should you include in the design?
You are designing a solution that will copy Parquet files stored in an Azure Blob storage account to an Azure Data Lake Storage Gen2 account. The data will be loaded daily to the data lake and will use a folder structure of {Year}/{Month}/{Day}/. You need to design a daily Azure...
Which statement accurately describes the dbo,FactInternetSales table?
You have an Azure Synapse Analytics dedicated SQL pool. You run PDW_SHOWSPACEUSED (dbo,FactInternetSales’); and get the results shown in the following table. Which statement accurately describes the dbo,FactInternetSales table?A . The table contains less than 1,000 rows.B . All distribution contain data.C . The table is skewed.D . The table...
Approximately how many rows will there be for each combination of distribution and partition?
You are designing a sales transactions table in an Azure Synapse Analytics dedicated SQL pool. The table will contains approximately 60 million rows per month and will be partitioned by month. The table will use a clustered column store index and round-robin distribution. Approximately how many rows will there be...
What should you include in the solution?
You are designing an Azure Synapse Analytics dedicated SQL pool. You need to ensure that you can audit access to Personally Identifiable information (PII). What should you include in the solution?A . dynamic data maskingB . row-level security (RLS)C . sensitivity classificationsD . column-level securityView AnswerAnswer: C Explanation: Data Discovery...
What should you include in the solution?
HOTSPOT You need to design a data storage structure for the product sales transactions. The solution must meet the sales transaction dataset requirements. What should you include in the solution? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer:...
Which technology should you use?
You implement an enterprise data warehouse in Azure Synapse Analytics. You have a large fact table that is 10 terabytes (TB) in size. Incoming queries use the primary key SaleKey column to retrieve data as displayed in the following table: You need to distribute the large fact table across multiple...
Which windowing function should you use?
You use Azure Stream Analytics to receive Twitter data from Azure Event Hubs and to output the data to an Azure Blob storage account. You need to output the count of tweets from the last five minutes every minute. Which windowing function should you use?A . SlidingB . SessionC ....
How should you complete the rode?
HOTSPOT You plan to develop a dataset named Purchases by using Azure databricks Purchases will contain the following columns: • ProductID • ItemPrice • lineTotal • Quantity • StorelD • Minute • Month • Hour • Year • Day You need to store the data to support hourly incremental load...
In which order should you perform the actions?
DRAG DROP You need to implement versioned changes to the integration pipelines. The solution must meet the data integration requirements. In which order 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. View...
How should you complete the Transact-SQL statement?
DRAG DROP You have an Azure Synapse Analytics workspace named WS1. You have an Azure Data Lake Storage Gen2 container that contains JSON-formatted files in the following format. You need to use the serverless SQL pool in WS1 to read the files. How should you complete the Transact-SQL statement? To...
