DRAG DROP -You administer a Microsoft SQL Server 2012 server along with a Microsoft Azure SQL Database database.For both servers, you need to grant users the ability to create logins and create databases.You need to determine which permission to grant users in each instance.Which permission or permissions should you choose? (To answer, drag the appropriate permission or permissions to their corresponding instance type or types in the answer area.Answer choices may be used once, more than once, or not at all. Answer targets may be used once or not at all. Additionally, you may need to drag the split bar between panes or scroll to view content.)Select and Place:
You administer a Microsoft Azure SQL Database database named Inventory that contains a stored procedure named p_AddInventory.Users need to be able to SELECT from all tables in the database and execute the stored procedure.You need to grant only the necessary permissions.What should you do?
You administer a SQL Server 2012 database instance.You need to configure the SQL Server Database Engine service on a failover cluster.Which user account should you use?
You administer a Microsoft Azure SQL Database database named Human_Resources. The database contains 2 tables named Employees and SalaryDetails.You add two Windows groups as logins for the server:✑ CORP\Employees - All company employees✑ CORP\HRAdmins - HR administrators only✑ HR Administrators are also company employees.You need to grant users access according to the following requirements:✑ CORP\Employees should have SELECT access to the Employees table.✑ Only users in CORP\HRAdmins should have SELECT access to the SalaryDetails table.Logins are based only on Windows security groups.What should you do?
You administer a Microsoft SQL Server database instance.You plan to migrate the database to Microsoft Azure SQL Database. You verify that all objects contained in the database are compatible with Microsoft Azure SQLDatabase.You need to ensure that database users and required server logins are migrated to Microsoft Azure SQL Database.What should you do?
Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.You administer all the deployments of Microsoft SQL Server in your company.You need to ensure that an OLTP database that uses a storage area network (SAN) remains available if any of the servers fail.You also need to minimize the amount of storage used by the database.Which configuration should you use?
