Microsoft TS:MS SQL Server 2008,Implementation and Maintenance Sample Questions:
1. DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database instance.
You plan to automate maintenance tasks.
What task types are included in a SQL Maintenance Plan? (To answer, drag the component to the correct task or tasks in the answer area. The component may be used once or more than once. Each task may be used once or not at all. Additionally, you may need to drag the split bar between panes or scroll to view content.)
2. You administer a SQL Server 2008 instance. You use an internal application based on SQL Server 2008. The application uses Analysis Services and Reporting Services. Company security policy requires that the surface area for all the deployed components of SQL Server 2008 be configured.
You need to implement the security policy and devise a method to evaluate the security policy against other database servers.
What should you do?
A) Use the SQL Server Best Practices Analyzer (BPA) to analyze your database servers. Implement the recommendations of the BPA.
B) Edit the RSReportServer.config configuration file. Distribute the file to all database servers that need to be configured
C) Create a Transact-SQL script based on the sp_configure stored procedure. Use a configuration server to rim the script against a server group that includes the database servers that need to be configured
D) Create policies based on the appropriate facets. Apply the policies against a server group that includes the database servers that need to be configured.
3. DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database instance.
You need to identify the purpose of each Dynamic Management Views (DMVs).
What should you do? (To answer, drag the appropriate purpose to the correct DMV in the answer area. Each purpose may be used once, more than once, or not at all. Each DMV may be used once or not at all. Additionally, you may need to drag the split bar between panes or scroll to view content.)
4. ---
You administer a SQL Server 2008 instance that contains a very large database named FinanceDB.
You plan to create a maintenance plan that meets the following objectives for the FinanceDB database:
It executes the DBCC CHECKDB statement.
It rebuilds all the indexes.
It updates all index statistics.
You need to ensure that the maintenance plan is executed in the minimum amount of time.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A) Use the Shrink Database task.
B) Use the Check Database Integrity task.
C) Use the Rebuild index task.
D) Use the Reorganize Index task.
E) Use the Update Statistics task.
5. You maintain a SQL Server 2008 instance that contains a database named DB1. DB1 stores customer data for the company. The customers use a Web application to access their profile data. You need to protect the customer data such that data files, log files, and subsequent backups are as secure as possible even if the backup media is lost. Your solution must not affect the Web application or impact performance.
What should you do?
A) Encrypt the customer data at the folder level by using Encrypted File System (EFS) and then back up the transaction logs.
B) Encrypt the customer data at the cell level and then back up DB1.
C) Configure access to DB1 to only use stored procedures and functions.
D) Enable Transparent Database Encryption for DB1 and then back up the transaction logs.
Solutions:
| Question # 1 Answer: Only visible for members | Question # 2 Answer: D | Question # 3 Answer: Only visible for members | Question # 4 Answer: C,D | Question # 5 Answer: D |
1225 Customer Reviews
Quality and ValueITCertKing Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITCertKing testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITCertKing offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.
