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 Databricks 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 files can be queried quickly and that the data type information is retained.What should you recommend?
You have an Azure Synapse Analytics dedicated SQL pool named Pool1. Pool1 contains a partitioned fact table named dbo.Sales and a staging table named stg.Sales that has the matching table and partition definitions.You need to overwrite the content of the first partition in dbo.Sales with the content of the same partition in stg.Sales. The solution must minimize load times.What should you do?
You are designing a slowly changing dimension (SCD) for supplier data in an Azure Synapse Analytics dedicated SQL pool.You plan to keep a record of changes to the available fields.The supplier data contains the following columns.Which three additional columns should you add to the data to create a Type 2 SCD? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.
HOTSPOT -You have a Microsoft SQL Server database that uses a third normal form schema.You plan to migrate the data in the database to a star schema in an Azure Synapse Analytics dedicated SQL pool.You need to design the dimension tables. The solution must optimize read operations.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.Hot Area:
HOTSPOT -You plan to develop a dataset named Purchases by using Azure Databricks. Purchases will contain the following columns:✑ ProductID✑ ItemPrice✑ LineTotal✑ Quantity✑ StoreID✑ Minute✑ Month✑ HourYear -✑ DayYou need to store the data to support hourly incremental load pipelines that will vary for each Store ID. The solution must minimize storage costs.How should you complete the code? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
You have a table in an Azure Synapse Analytics dedicated SQL pool. The table was created by using the following Transact-SQL statement.You need to alter the table to meet the following requirements:✑ Ensure that users can identify the current manager of employees.✑ Support creating an employee reporting hierarchy for your entire company.✑ Provide fast lookup of the managers' attributes such as name and job title.Which column should you add to the table?
