70-453 Questions And Answers

1.You are the administrator of your company network. And you're in charge of a SQL Server 2008
infrastructure. Now you intend to design a maintenance strategy for a mission-critical database. And the
database has a large table named DPT. Index maintenance operations are also included in the design
plan. When designing the strategy, you must consider the following matters: The DPT table contains a
column of the xml data type and is constantly accessed. New rows are frequently added to the DPT table.
The average fragmentation for the clustered index of the Orders table is less than 2 percent. In order to
optimize the performance of the queries on the table, you have to run the strategy. So what action should
you perform?
A.You should drop the clustered index of the DPT table
B.You should rebuild the clustered index of the DPT table offline once a month
C.You should reorganize the clustered index of the DPT table by decreasing the fill factor.
D.You should exclude the clustered index of the Orders table from scheduled reorganizing or rebuilding
operations
Answer:D

2.You are the administrator of your company network. And you're in charge of SQL Server 2008 instance.
Now you deploy a new database named TCK which manages large documents. The documents will be
revised sometimes. Fast read access must be permitted by developing a table structure. Meanwhile, you
have to reduce storage space requirements. So what action should you perform? (Each correct answer
presents part of the solution. Choose two.)
A.You should use NTFS file system compression on the volume
B.You should use row-level compression on the document table
C.You should use varbinary(MAX) data type with FILESTREAM storage
D.You should enable row-level compression on all columns that use the vardecimal() data type.
Answer:A C

3.You are the administrator of your company network. There's a SQL Server 2008 instance which hosts a
new database application in your company. Now you want to develop the security requirements for the
application. Each application user has his own login to the SQL Server 2008 server. The application
database executes stored procedures in the MSDB database in which the stored procedures schedule
SQLAgent jobs. You must make sure that the the stored procedures in the MSDB database are executed
by using the security context of the application user. So what action should you perform?
A.You should add each user to the public role in the MSDB database
B.You should add each user to the dbdtsltduser database role in the MSDB database
C.You should configure the MSDB database to use the TRUSTWORTHY option, and then add each user
to the MSDB database
D.You should configure the new database to use the TRUSTWORTHY option, and then add each user to
the MSDB database.
Answer:D