What should you create?

You need to implement the surrogate key for the retail store table. The solution must meet the sales transaction dataset requirements. What should you create?A . a table that has an IDENTITY propertyB . a system-versioned temporal tableC . a user-defined SEQUENCE objectD . a table that has a FOREIGN...

January 11, 2022 No Comments READ MORE +

Which storage tier should you use for each time frame?

HOTSPOT You are designing an application that will store petabytes of medical imaging data When the data is first created, the data will be accessed frequently during the first week. After one month, the data must be accessible within 30 seconds, but files will be accessed infrequently. After one year,...

January 10, 2022 No Comments READ MORE +

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...

January 10, 2022 No Comments READ MORE +

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...

January 10, 2022 No Comments READ MORE +

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...

January 10, 2022 No Comments READ MORE +

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...

January 9, 2022 No Comments READ MORE +

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:...

January 8, 2022 No Comments READ MORE +

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...

January 8, 2022 No Comments READ MORE +

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 ....

January 8, 2022 No Comments READ MORE +

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...

January 8, 2022 No Comments READ MORE +