Note: This questions is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.You deploy Microsoft SQL Server to a virtual machine in Azure. You distribute the database files and filegroups across multiple Azure storage disks.You must be able to manage the databases as individual entities by using SQL Server Management Studio. All data in the databases must be stored encrypted.Backups must be encrypted by using the same key as the live copy of the database.You need to secure the data.What should you implement?
DRAG DROP -You deploy a new Microsoft Azure SQL Database instance to support a variety of mobile applications and public websites. You plan to create a new security principal named User1.The principal must have access to select all current and future objects in a database named Reporting. The activity and authentication of the database user must be limited to the Reporting database.You need to create the new security principal.Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.Select and Place:
DRAG DROP -A new Azure Active Directory security principal named[email protected]should have access to select all current and future objects in theReporting database. You should not grant the principal any other permissions. You should use your Active Directory Domain Services (AD DS) account to authenticate to the Azure SQL database.You need to create the new security principal.Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.Select and Place:
You are deploying a Microsoft SQL Server database that will support a mixed OLTP and OLAP workload. The target virtual machine has four CPUs.You need to ensure that reports do not use all available system resources.What should you do?
A company has an on-premises Microsoft SQL Server 2014 environment. The company has a main office in Seattle, and remote offices in Amsterdam and Tokyo.You plan to deploy a Microsoft Azure SQL Database instance to support a new application. You expect to have 100 users from each office.In the past, users at remote sites reported issues when they used applications hosted at the Seattle office.You need to optimize performance for users running reports while minimizing costs.What should you do?
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 stated goals.Your company plans to use Microsoft Azure Resource Manager templates for all future deployments of SQL Server on Azure virtual machines.You need to create the templates.Solution: You use Visual Studio to create a XAML template that defines the deployment and configuration settings for the SQL Server environment.Does the solution meet the goal?
