You use a contained database named ContosoDb within a domain.You need to create a user who can log on to the ContosoDb database. You also need to ensure that you can port the database to different database servers within the domain without additional user account configurations.Which type of user should you create?
You administer a Microsoft SQL Server 2012 database.You configure Transparent Data Encryption (TDE) on the Orders database by using the following statements:CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'MyPassword1!'CREATE CERTIFICATE TDE_Certificate WITH SUBJECT = 'TDE Certificate';BACKUP CERTIFICATE TDE_Certificate TO FILE = ''d:\TDE_Certificate.cer'WITH PRIVATE KEY (FILE = 'D:\TDE_Certificate.key', ENCRYPTION BY PASSWORD ='MyPassword1!');CREATE DATABASE ENCRYPTION KEY -WITH ALGORITHM = AES_256 -ENCRYPTION BY SERVER CERTIFICATE TDE_Certificate;ALTER DATABASE Orders SET ENCRYPTION ON;You attempt to restore the Orders database and the restore fails. You copy the encryption file to the original location.A hardware failure occurs and so a new server must be installed and configured.After installing SQL Server to the new server, you restore the Orders database and copy the encryption files to their original location. However, you are unable to access the database.You need to be able to restore the database.Which Transact-SQL statement should you use before attempting the restore?
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 a SQL Server 2012 server that contains a database named SalesDB. SalesDb contains a schema named Customers that has a table namedRegions. A user named UserA is a member of a role named Sales.UserA is granted the Select permission on the Regions table. The Sales role is granted the Select permission on the Customers schema.You need to ensure that the Sales role, including UserA, is disallowed to select from any of the tables in the Customers schema.Which Transact-SQL statement should you use?
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 a SQL 2012 server that contains a database named SalesDB. SalesDb contains a schema named Customers that has a table named Regions. A user named UserA is a member of a role named Sales.UserA is granted the Select permission on the Regions table. The Sales role is granted the Select permission on the Customers schema.You need to remove the Select permission for UserA on the Regions table. You also need to ensure that UserA can still access all the tables in the Customers schema, including the Regions table, through the Sales role permissions.Which Transact-SQL statement should you use?
You administer a single server that contains a Microsoft SQL Server 2012 default instance on which several production databases have been deployed.You plan to install a new ticketing application that requires the deployment of a database on the server. The SQL login for this application requires sysadmin permissions.You need to ensure that the login for the ticketing application cannot access other production databases.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?
