<< Prev Question Next Question >>

Question 7/41

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 A?\ire Synapse Analytics dedicated SQI 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.

LEAVE A REPLY

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

Question List (41q)
Question 1: You need to implement the surrogate key for the retail store...
Question 2: You have an Azure subscription that contains a logical Micro...
Question 3: You are designing the folder structure for an Azure Data Lak...
Question 4: Note: This question is part of a series of questions that pr...
Question 5: You implement an enterprise data warehouse in Azure Synapse ...
Question 6: You have a table named SalesFact in an enterprise data wareh...
Question 7: You have a Microsoft SQL Server database that uses a third n...
Question 8: You have an Azure Synapse Analytics serverless SQL pool name...
Question 9: Note: This question is part of a series of questions that pr...
Question 10: You have an Azure Stream Analytics job that is a Stream Anal...
1 commentQuestion 11: You need to implement an Azure Synapse Analytics database ob...
Question 12: You are planning a streaming data solution that will use Azu...
Question 13: You are developing a solution using a Lambda architecture on...
Question 14: You are designing an enterprise data warehouse in Azure Syna...
Question 15: You plan to implement an Azure Data Lake Gen2 storage accoun...
Question 16: You have an Azure data factory. You need to examine the pipe...
1 commentQuestion 17: You are designing a slowly changing dimension (SCD) for supp...
Question 18: You have a partitioned table in an Azure Synapse Analytics d...
Question 19: You are monitoring an Azure Stream Analytics job. The Backlo...
1 commentQuestion 20: You are designing a partition strategy for a fact table in a...
Question 21: What should you do to improve high availability of the real-...
Question 22: Note: This question is part of a series of questions that pr...
Question 23: You have an Azure Databricks workspace named workspace1 in t...
Question 24: You are designing an Azure Databricks interactive cluster. T...
1 commentQuestion 25: You are implementing Azure Stream Analytics windowing functi...
Question 26: You need to schedule an Azure Data Factory pipeline to execu...
2 commentQuestion 27: You have an Azure Synapse Analytics dedicated SQL pool that ...
Question 28: You are developing a solution that will stream to Azure Stre...
1 commentQuestion 29: You have an Azure Synapse Analytics dedicated SQL pool that ...
Question 30: You build an Azure Data Factory pipeline to move data from a...
Question 31: You have an on-premises data warehouse that includes the fol...
Question 32: You have an Azure SQL database named Database1 and two Azure...
Question 33: You plan to ingest streaming social media data by using Azur...
Question 34: You are creating an Azure Data Factory data flow that will i...
Question 35: You have a data model that you plan to implement in a data w...
1 commentQuestion 36: You have the following table named Employees. (Exhibit) You ...
Question 37: You plan to implement an Azure Data Lake Storage Gen2 contai...
Question 38: You have an Azure Active Directory (Azure AD) tenant that co...
Question 39: You plan to create an Azure Synapse Analytics dedicated SQL ...
1 commentQuestion 40: You are designing a statistical analysis solution that will ...
Question 41: You have an Azure Stream Analytics query. The query returns ...