Load the data using the CREATE TABLE AS SELECT statement. Does the solution meet the goal?

Topic 3, Misc Questions Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals. You develop a data ingestion process that will import data to a Microsoft Azure...

September 28, 2019 No Comments READ MORE +

Solution: Create an Azure Automation runbook to copy events. Does the solution 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 27, 2019 No Comments READ MORE +

Which integration runtime should you use?

You need to set up Azure Data Factory pipelines to meet data movement requirements. Which integration runtime should you use?A . self-hosted integration runtimeB . Azure-SSIS Integration RuntimeC . .NET Common Language Runtime (CLR)D . Azure integration runtimeView AnswerAnswer: A Explanation: The following table describes the capabilities and network support...

September 26, 2019 No Comments READ MORE +

Does the solution meet the goal?

Validate configuration results and deploy the solution Does the solution meet the goal?A . YesB . NoView AnswerAnswer: B Explanation: Use the Azure Key Vault, not the Windows Certificate Store, to store the master key. Note: The Master Key Configuration page is where you set up your CMK (Column Master...

September 24, 2019 No Comments READ MORE +

Does the solution meet the goal?

Validate configuration results and deploy the solution Does the solution meet the goal?A . YesB . NoView AnswerAnswer: B Explanation: Use the Azure Key Vault, not the Windows Certificate Store, to store the master key. Note: The Master Key Configuration page is where you set up your CMK (Column Master...

September 24, 2019 No Comments READ MORE +

Which three actions should you perform in sequence?

DRAG DROP You need to set up access to Azure SQL Database for Tier 7 and Tier 8 partners. Which three actions should you perform in sequence? To answer, move the appropriate three actions from the list of actions to the answer area and arrange them in the correct order....

September 24, 2019 No Comments READ MORE +

Does the solution meet the goal?

Validate configuration results and deploy the solution Does the solution meet the goal?A . YesB . NoView AnswerAnswer: B Explanation: Use the Azure Key Vault, not the Windows Certificate Store, to store the master key. Note: The Master Key Configuration page is where you set up your CMK (Column Master...

September 24, 2019 No Comments READ MORE +

Which integration runtime should you use?

You need to set up Azure Data Factory pipelines to meet data movement requirements. Which integration runtime should you use?A . self-hosted integration runtimeB . Azure-SSIS Integration RuntimeC . .NET Common Language Runtime (CLR)D . Azure integration runtimeView AnswerAnswer: A Explanation: The following table describes the capabilities and network support...

September 17, 2019 No Comments READ MORE +

Does the solution meet the goal?

Validate configuration results and deploy the solution Does the solution meet the goal?A . YesB . NoView AnswerAnswer: B Explanation: Use the Azure Key Vault, not the Windows Certificate Store, to store the master key. Note: The Master Key Configuration page is where you set up your CMK (Column Master...

September 16, 2019 No Comments READ MORE +

Which components should you use for each Elastic pool job services task?

DRAG DROP Your company uses Microsoft Azure SQL Database configure with Elastic pool. You use Elastic Database jobs to run queries across all databases in the pod. You need to analyze, troubleshoot, and report on components responsible for running Elastic Database jobs. You need to determine the component responsible for...

September 15, 2019 No Comments READ MORE +