Which action will you perform first?
You are a professional level SQL Sever 2008 Database Administrator. A thirdparty
database application will be deployed to the instance. Stored procedures are utilized by the
application, and the procedures are developed by utilizing SQL CLR integration. You should
set the application to have the EXTERNAL_ACCESS code access security setting enabled.
Since you are the technical support of the company, you should deploy the application to
the instance with no loss of functionality. Which action will you perform first?
You need to grant the necessary permission to the developers to test the policies
You administer a SQL Server 2008 infrastructure. Developers in your company have rights
to author policies. A test server is used to develop and test the policies. The Policy-Based
Management feature generates SQL Server Agent alerts when a policy is violated. The
developers are able to create and modify policies, but are unable to test policy violation
alerts. You need to grant the necessary permission to the developers to test the policies.
You also need to comply with the least privilege principle when you grant the permission.
What should you do?
Which solution should you implement?
You administer a SQL Server 2008 infrastructure. The infrastructure contains SQL Server
2008 servers across four sites. All sites are connected via a WAN link. All sites use the
same database application. Your company has the following business requirements: All
sites maintain data related to their site. Each site has access to data related to other sites.
In the event of any site failure, database activity is redirected to another site. You need to
implement a replication topology that meets the business requirements. Which solution
should you implement?
You need to configure a strategy that will provide the minimum amount of latency for committed transactions
You administer a SQL Server 2008 instance. You plan to design a high-availability solution
by using database mirroring. The current application includes programming logic that will
retry transactions if a failover occurs. You need to configure a strategy that will provide the
minimum amount of latency for committed transactions. What should you do?
You need to ensure that the database backups can be restored on another SQL Server 2008 instance if the origin
You administer a SQL Server 2008 infrastructure. Several production databases use
Transparent database encryption. You perform full database backups of the production
databases as part of your backup strategy. You need to ensure that the database backups
can be restored on another SQL Server 2008 instance if the original host server fails. What
should you do?
Which two objects should you transfer from the production environment to the development environment?
You administer a SQL Server 2008 instance that hosts a database solution in a production
environment. The database solution uses several SQL Server Agent jobs to periodically
transfer data from heterogeneous data sources to the production environment. You also
have a separate development environment that is used by several development teams. You
design a test recovery plan for the database. You plan to test the recovery plan by
performing the following tasks: Restoring the database on a separate SQL Server 2008
instance in a development environment Running a number of unit tests. You need to ensure
that all database dependencies are included in the recovery plan. Which two objects should
you transfer from the production environment to the development environment? (Each
correct answer presents part of the solution. Choose two.)
Which two actions should you perform?
You administer a SQL Server 2008 infrastructure. You plan to design an infrastructure for a
new application. The application has the following requirements: Users can connect to an
instance named SQLSERVER1. SQLSERVER1 is linked to a server named
SQLSERVER2. SQLSERVER1 and SQLSERVER2 run on different computers. The
SQL Server instances use only Windows authentication. You need to configure the
infrastructure to ensure that the distributed queries are executed in the Windows security
context of the login. Which two actions should you perform? (Each correct answer presents
part of the solution. Choose two.)
You need to choose an encryption strategy that has the minimum effect on the performance of the server
You are designing a database solution by using SQL Server 2008. The database has a
large number of tables that have columns that contain sensitive data. The sensitive data
must be protected. You need to choose an encryption strategy that has the minimum effect
on the performance of the server. What should you do? (More than one answer choice may
achieve the goal. Select the BEST answer.)
You need to minimize the surface area for potential attacks on the server
You are configuring a new SQL Server installation. The SQL Server instance will be used
for both online analytical processing (OLAP) and relational data. The data in the server is
accessed frequently. You can configure the services, startup type, and accounts used by
the services that run on the server according to the following table. You want to raise the
level of security on the server. You need to minimize the surface area for potential attacks
on the server. What should you do? (More than one answer choice may achieve the goal.
Select the BEST answer.)
You need to be able to identify and resolve any violation of the rule by using the minimum amount of administr
Your organization has many servers that run SQL Server 2008. You define a rule to ensure
that all database servers have Database Mail disabled. You need to be able to identify and
resolve any violation of the rule by using the minimum amount of administrative effort. What
should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)