- All Exams Instant Download
Which three Transaction-SQL DDL commands should you run in sequence?
DRAG DROP You need to ensure that the Twitter feed data can be analyzed in the dedicated SQL pool. The solution must meet the customer sentiment analytics requirements. Which three Transaction-SQL DDL commands should you run in sequence? To answer, move the appropriate commands from the list of commands to...
Which Azure Storage functionality should you include in the solution?
You need to design a data retention solution for the Twitter feed data records. The solution must meet the customer sentiment analytics requirements. Which Azure Storage functionality should you include in the solution?A . change feedB . soft deleteC . time-based retentionD . lifecycle managementView AnswerAnswer: D Explanation: Scenario: Purge...
Which three components should you create in sequence?
DRAG DROP You are responsible for providing access to an Azure Data Lake Storage Gen2 account. Your user account has contributor access to the storage account, and you have the application ID and access key. You plan to use PolyBase to load data into an enterprise data warehouse in Azure...
What should you enable?
You have a data warehouse in Azure Synapse Analytics. You need to ensure that the data in the data warehouse is encrypted at rest. What should you enable?A . Advanced Data Security for this databaseB . Transparent Data Encryption (TDE)C . Secure transfer requiredD . Dynamic Data MaskingView AnswerAnswer: B...
What should you use?
You need to design a solution that will process streaming data from an Azure Event Hub and output the data to Azure Data Lake Storage. The solution must ensure that analysts can interactively query the streaming data. What should you use?A . event triggers in Azure Data FactoryB . Azure...
Which distribution type should you recommend to minimize data movement?
You are designing a date dimension table in an Azure Synapse Analytics dedicated SQL pool. The date dimension table will be used by all the fact tables. Which distribution type should you recommend to minimize data movement?A . HASHB . REPLICATEC . ROUND ROBINView AnswerAnswer: B Explanation: A replicated table...
How should you complete the Transact-SQL statement?
CORRECT TEXT You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and an Azure Data Lake Storage Gen2 account named Account 1. You plan to access the files in Accoun1l by using an external table. You need to create a data source in Pool1 that you can reference...
Which three actions should you perform in sequence?
DRAG DROP You plan to monitor an Azure data factory by using the Monitor & Manage app. You need to identify the status and duration of activities that reference a table in a source database. Which three actions should you perform in sequence? To answer, move the actions from the...
What should you use?
You have an Azure Synapse Analytics dedicated SQL pool mat contains a table named dbo.Users. You need to prevent a group of users from reading user email addresses from dbo.Users. What should you use?A . row-level securityB . column-level securityC . Dynamic data maskingD . Transparent Data Encryption (TDDView AnswerAnswer:...
Does this meet the goal?
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you...
