You administer a Windows 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 2016 database instance.You plan to migrate the database to Windows Azure SQL Database.You verify that all objects contained in the database are compatible with Windows Azure SQL Database.You need to ensure that database users and required server logins are migrated to Windows Azure SQL Database.What should you do?
You administer a Microsoft SQL Server 2016 database.The database is currently configured to log ship to a secondary server.You are preparing to cut over to the secondary server by stopping log-shipping and bringing the secondary database online.You want to perform a tail-log backup. You need to leave the primary database in a restoring state.Which option of the BACKUP LOG command should you use?
You administer a Microsoft SQL Server 2016 database.You want to make a full backup of the database to a file on disk.In doing so, you need to output the progress of the backup.Which backup option should you use?
You administer two Microsoft SQL Server 2016 servers named ProdSrv1 and ProdSrv2. ProdSrv1 is configured as a Distributor.Both servers are configured to use the Windows NT Service virtual accounts for all SQL Services.You are configuring snapshot replication from ProdSrv1 to ProdSrv2 by using ProdSrv2 as a pull subscriber.The distribution agent on ProdSrv2 regularly fails, displaying the following error message:"Cannot access the file. Operating system error code 5 (Access is denied.)."You need to configure the distribution agent by granting only the minimum required access to all accounts.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 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 this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You need to configure a Microsoft SQL Server instance to ensure that a user named Mail1 can send mail by using Database Mail.Solution: You add the DatabaseMailUserRole to Mail1 in the tempdb database.Does the solution meet the goal?
