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

September 12, 2021 No Comments READ MORE +

Which type of library and workspace should you implement?

HOTSPOT You need to collect application metrics, streaming query events, and application log messages for an Azure Databrick cluster. Which type of library and workspace should you implement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: You...

September 12, 2021 No Comments READ MORE +

What should you do?

HOTSPOT You need to implement an Azure Synapse Analytics database object for storing the sales transactions data. The solution must meet the sales transaction dataset requirements. What solution must meet the sales transaction dataset requirements. What should you do? To answer, select the appropriate options in the answer area. NOTE:...

September 12, 2021 No Comments READ MORE +

What should you recommend to prevent users outside the Litware on-premises network from accessing the analytical data store?

What should you recommend to prevent users outside the Litware on-premises network from accessing the analytical data store?A . a server-level virtual network ruleB . a database-level virtual network ruleC . a database-level firewall IP ruleD . a server-level firewall IP ruleView AnswerAnswer: A Explanation: Virtual network rules are one...

September 12, 2021 No Comments READ MORE +

Which type of integration runtime should you use?

You need to integrate the on-premises data sources and Azure Synapse Analytics. The solution must meet the data integration requirements. Which type of integration runtime should you use?A . Azure-SSIS integration runtimeB . self-hosted integration runtimeC . Azure integration runtimeView AnswerAnswer: C

September 11, 2021 No Comments READ MORE +

What should you do to improve high availability of the real-time data processing solution?

What should you do to improve high availability of the real-time data processing solution?A . Deploy identical Azure Stream Analytics jobs to paired regions in Azure.B . Deploy a High Concurrency Databricks cluster.C . Deploy an Azure Stream Analytics job and use an Azure Automation runbook to check the status...

September 11, 2021 No Comments READ MORE +

Which two columns should you add to the table?

You need to implement a Type 3 slowly changing dimension (SCD) for product category data in an Azure Synapse Analytics dedicated SQL pool. You have a table that was created by using the following Transact-SQL statement. Which two columns should you add to the table? Each correct answer presents part...

September 11, 2021 No Comments READ MORE +

Which windowing function should you use for each requirement?

HOTSPOT You are implementing Azure Stream Analytics windowing functions. Which windowing function should you use for each requirement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer:

September 10, 2021 No Comments READ MORE +

Which type of replication should you use for the storage account?

You plan to implement an Azure Data Lake Gen2 storage account. You need to ensure that the data lake will remain available if a data center fails in the primary Azure region. The solution must minimize costs. Which type of replication should you use for the storage account?A . geo-redundant...

September 10, 2021 No Comments READ MORE +

What should you create first?

You have an Azure Synapse Analytics serverless SQL pool named Pool1 and an Azure Data Lake Storage Gen2 account named storage1. The AllowedBlobpublicAccess porperty is disabled for storage1. You need to create an external data source that can be used by Azure Active Directory (Azure AD) users to access storage1...

September 10, 2021 No Comments READ MORE +