What should you do first?

You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool named SQLPool1. SQLPool1 is currently paused. You need to restore the current state of SQLPool1 to a new SQL pool. What should you do first?A . Create a workspace. B. Create a user-defined restore point. C. Resume SQLPool1. D. Create...

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 answer a question in...

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 rule B. a database-level virtual network rule C. a database-level firewall IP rule D. a server-level firewall IP rule View Answer Answer: A Explanation: Virtual network rules are one firewall security...

Which statement accurately describes the dbo,FactInternetSales table?

You have an Azure Synapse Analytics dedicated SQL pool. You run PDW_SHOWSPACEUSED(dbo,FactInternetSales’); and get the results shown in the following table. Which statement accurately describes the dbo,FactInternetSales table?A . The table contains less than 1,000 rows. B. All distributions contain data. C. The table is skewed. D. The table uses round-robin distribution. View Answer...

What should you recommend?

A company purchases IoT devices to monitor manufacturing machinery. The company uses an IoT appliance to communicate with the IoT devices. The company must be able to monitor the devices in real-time. You need to design the solution. What should you recommend?A . Azure Stream Analytics cloud job using Azure PowerShell B. Azure Analysis...

What should you include in the solution?

Topic 1, Contoso Case Study Transactional Date Contoso has three years of customer, transactional, operation, sourcing, and supplier data comprised of 10 billion records stored across multiple on-premises Microsoft SQL Server servers. The SQL server instances contain data from various operational systems. The data is loaded into the instances by using SQL server integration...