Which two permissions will you require to perform this task?
You are the database administrator of your company. The network contains an instance of SQL Server 2008. Thenetwork also contains a Web server that hosts a Web application to provide product information to customers.The product information is stored in a database named Products on the SQL server. You want to create a stored procedure for use by the Web application that will return information about productsfrom the Products database that matches the search criteria specified by the customer.
Which two permissions will you require to perform this task? (Choose two. Each correct answer represents a partof the solution.)
What should you use to perform this task?
You are the SQL administrator of your company. The network contains a default instance of SQL Server 2008that was upgraded from SQL Server 2005.
You discover that several unwanted settings and features are configured on the SQL server.
You want to reducethe SQL server surface area to prevent the server from attacks by malicious users.
To achieve this, you want toconfigure the connection, protocols, and startup options for the SQL server.
What should you use to perform this task?
which theaudit log files are being saved. You want to restart SQL1 . What should you do?
You are the database administrator of your company. The network contains a default instance of SQL Server 2008 named SQL1.
You configure the C2 auditing mode on SQL1 to audit all successful and failed attempts toaccess databases stored on the server. The auditing is configured to start automatically.
After several days, you discover that SQL1 has shut down due to lack of space in the data directory in which theaudit log files are being saved.
You want to restart SQL1 . What should you do?
What should you do?
You have been hired as the database administrator for your company.
The previous database administrator hasconfigured automatic auditing on an instance of SQL Server 2008 by using SQL Server Audit.
The ON_FAILURE=SHUTDOWN parameter for the SQL Server Audit is configured on the server to ensure thatthe server shuts down if an audit failure occurs.
You want to bypass the shutdowns caused by audit failures. What should you do?
which fixed server role should you add the other administrator?
You are a SQL administrator for your company. You manage all of your company’s SQL Server 2008 computers.An administrator for another department needs access to the SQL Server 2008 computers that you manage. Youwant to allow the other administrator to add and remove linked servers without granting the administratorunnecessary permissions.
To which fixed server role should you add the other administrator?
What should you do?
You are the database administrator of the Verigon corporation. Your network contains a SQL Server 2005computer running on Windows 2000 Server with Mixed Mode authentication in the verigon.com domain. You want to upgrade the SQL server to SQL Server 2008 and enforce the domain password policy for the users of the verigon.com domain on the SQL Server. In addition, you want to use Kerberos authentication to provide bettersecurity. What should you do? (Choose all that apply. Each correct answer represents part of the solution.)
What should you do?
You are the database administrator of your company. The network contains an instance of SQL Server 2008 thatis accessed by all users on the network. The company’s policy states that users must not have direct permission to create database triggers on the SQLserver. Any user that needs to create triggers must use the execution context of a different user or login that hasthe appropriate permissions. To achieve this, you create a new login that has appropriate permissions to createtriggers.
You want to ensure that users are able to use this login with the EXECUTE AS statement.
What should you do?
What should you do?
You are a database administrator for your company. Your company stores all its product data in a SQL Server2005 database named Products. You upgrade the Products database to SQL Server 2008. After the upgrade,you create the respective logins and users in the new database on SQL Server 2008. Eric, a user in your database, complains that since the upgrade he is not able to access the tables created byanother user, Adam, through a stored procedure. However, Adam is able to access the tables through the storedprocedure.
You need to ensure that Eric is able to access the data while minimizing excessive permissions. What should you do?
Which code should you execute?
You are the database administrator of your company. The network contains two instances of SQL Server 2008 named SQL1 and SQL2 . You move a database named ProdDB from SQL1 to SQL2 . A database user in the ProdDB database reports that he is unable to log in to SQL2 . You investigate anddiscover that the user has become orphaned. You want to detect all orphaned users in the ProdDB database on SQL2 . Which code should you execute?
Which Transact-SQL should you run first?
You are the database administrator of your company. The network contains an instance of SQL Server 2008 named SQL1.
SQL1 contains a database named CorpData that contains confidential information.
You want to encrypt the CorpData database. Which Transact-SQL should you run first?