DRAG DROP You have a Microsoft Azure virtual machine that hosts a Microsoft SQL Server database. You need to configure firewall rules to meet the following requirements: • Access the database remotely. • Manage the server remotely by using Windows…

DRAG DROP You plan to implement row-level security for the CWDB database. You create the fn_limitusers function under the restriction schema. You need to create the policy. How should you complete the policy? To answer, drag the appropriate elements to…

HOTSPOT You are evaluating the migration of the databases from Host1 and WebData1 to Azure. You need to recommend the most cost-effective solution for storing the database in Azure. The solution must meet the business requirements. In the table below,…

You have a Microsoft Azure SQL data warehouse. During peak usage, you discover that the data warehouse fails to meet performance expectations. You need to provide additional resources to the data warehouse, What should you do? A. Create an additional…