What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 database that makes use of the Analysis Services and Reporting Services. However,
installed components at Domain.com adhere to the Domain.com security policy.
You have received instruction to ensure that you adhere to the Domain.com security policy.
What should you do?
What should you do?
You work as a database administrator at Domain.com. Domain.com is using SQL Server 2008.
Domain.com contains a SQL Server 2008 server named CERTKILLER-DB04.
CERTKILLER-DB04 will be used to run the Reporting Services. However,
the Reporting Services must be able to run the database backups and other maintenance job automatically.
Because Domain.com has no other SQL systems, you need to make use of the SQL’s DNS name.
What should you do?
What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server 2008 instance. The SQL Server 2008 instance contains a database named CK_DB. Management wants CK_DB to have the following characteristics.
* I/O streaming access should be enabled on CK_DB.
* The data on CK_DB should be accessible to remote clients.
* Ensure that CK_DB is enabled.
What should you do?
What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. You have received instruction from management to move a web application from
Microsoft SQL Server 2005 to Microsoft SQL Server 2008. Be reminded that when a web
application is moved then the features will be stopped and you need to control the SQL Server
sample to remember the use of features.
What should you do?
What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. Because of a new application, you installed a second SQL Server 2008 instance
that will work with the new application. However, these two instances should be functional with
their respective applications without changing the environment of the application and with the
minimal amount of cost.
What should you do? (Each correct answer presents part of the solution. Choose TWO.)
What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server 2008 instance.
You have received instructions from management to allow the users at
Domain.com on the SQL Server sample to use the OPENROWSET() function to search remote information sources.
What should you do?
which do not include this prefix.What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. Management wants the prefix usp_ on all instances using all user-defined stored
procedures; however, they do not want you to develop stored procedures which do not include this prefix.
What should you do?
What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server 2008 instance.
The SQL Server 2008 instance contains a database named CK_DB.
CK_DB has its data file and the transaction log file on drive D. You have received instructions to move both the
data file and the transaction log file to drive G.
What should you do?
What should you do?
You work as the network administrator at Domain.com. Domain.com has acquired an enterprise application that runs SQL Server 2008.
The stored procedures that the application uses make use of the EXECUTE AS clause that makes use of the Microsoft Windows accounts.
A new Domain.com security policy requires that all enterprise applications must run under the
context of a service account. It is imperative that this account complies with the company policy
that states all accounts must have the least amount of privileges whilst allowing duties to be
carried out. Consequently this service account must have as little privileges as possible. You have
received instructions to configure the SQL Server service to be used in a suitable context for the
installation of the new enterprise application.
What should you do?