Microsoft 70-453 Real Exam Questions
Upgrade: Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008
1: You administer a SQL Server 2008 instance. A user named Mary reports that she is waiting for a query to complete. You need to ascertain whether the query is blocked. Which tool should you use?
A.The Windows System Monitor tool
B.The Database Engine Tuning Advisor tool
C.The Activity Monitor tool in Microsoft SQL Server Management Studio
D.The Job Activity Monitor tool in Microsoft SQL Server Management Studio
Correct Answers: C
2: You maintain a SQL Server 2008 instance that runs on a computer that hosts several applications. You configure the SQL Server Agent service to run by using the SERVER1\AGENT account. You create a job named MailingList that requires a file to be written to a file server. The job fails to run because it does not have appropriate access to the file server. You plan to configure the SQL Server Agent service. You need to perform the configuration such that only the SQL Server Agent service has read and write access to the file server. Which account type should you use?
A.Domain account
B.Local System account
C.Local Service account
D.Network Service account
Correct Answers: A
3: You configure a SQL Server 2008 instance that contains a database named AdventureWorks. The AdventureWorks database experiences deadlock problems. You need to capture the deadlock information to the SQL Server error log. What should you do?
A.Enable Server Auditing for the AdventureWorks database.
B.Configure the data collector to capture the deadlock graphs.
C.Configure a SQL Profiler trace to capture the deadlock graphs.
D.Set the appropriate trace flags as a startup parameter and restart the SQL Server instance.
Correct Answers: D
4: You maintain a SQL Server 2008 instance that contains a database named Finance.
The backup strategy for the Finance database specifies the following requirements:
Full database backup to a file named finance.bak is performed at 08:00 hours daily.
A transaction log backup to a file named finance_HHMM.trn is performed every 15 minutes starting at 08:15 hours.
The Finance database is being used in single-user mode.
At 08:40 hours, a user reports that some important data was accidentally deleted by a query that was executed at 08:23 hours.
You need to restore the database to its original state.
Which Transact-SQL statement(s) should you use?
A.RESTORE DATABASE Finance FROM DISK = ‘t:\backups\finance.bak’ WITH NORECOVERY;RESTORE LOG Finance FROM ‘t:\backups\finance_0830.trn’ WITH RECOVERY, STOPAT = ‘Mar 17, 2008 08:23 AM’;
B.RESTORE DATABASE Finance FROM DISK = ‘t:\backups\finance.bak’ WITH NORECOVERY;RESTORE LOG Finance FROM ‘t:\backups\finance_0815.trn’ WITH NORECOVERY;RESTORE LOG Finance FROM ‘t:\backups\finance_0830.trn’ WITH RECOVERY, STOPAT = ‘Mar 17, 2008 08:23 AM’;
C.RESTORE DATABASE Finance FROM DISK = ‘t:\backups\finance.bak’;RESTORE LOG Finance FROM ‘t:\backups\finance_0815.trn’ WITH NORECOVERY;RESTORE LOG Finance FROM ‘t:\backups\finance_0830.trn’ WITH RECOVERY, STOPAT = ‘Mar 17, 2008 08:23 AM’;
D.RESTORE DATABASE Finance FROM DISK = ‘t:\backups\finance.bak’;RESTORE LOG Finance FROM ‘t:\backups\finance_0815.trn’ WITH NORECOVERY;RESTORE LOG Finance FROM ‘t:\backups\finance_0830.trn’ WITH RECOVERY;
Correct Answers: B
5: You maintain a SQL Server 2008 instance that contains a database named Finance. The most recent full backup was taken at 13:00 hours, a differential backup was taken at 15:00 hours, and database snapshots were created at 16:00 hours and at 17:00 hours. The backups and the database snapshots are stored on a different disk from the database files. The hard disk that contains the database files fails at 17:02 hours. You need to restore the Finance database by ensuring minimal data loss. What should you do?
A.Restore the full backup.
B.Restore the database snapshot from 16:00 hours.
C.Restore the database snapshot from 17:00 hours.
D.Restore the full backup and the differential backup.
Correct Answers: D
6: You maintain a SQL Server 2008 instance that contains a database named Finance. Minimally logged operations are performed on the Finance database. You need to verify that the database can be restored to a specific point in time. What should you do?
A.Verify that the database uses the full recovery model.
B.Verify that the database uses the simple recovery model.
C.Verify that the database uses the bulk-logged recovery model.
D.Verify that the database uses the checksum page verify option.
Correct Answers: A
7: You maintain an instance of Microsoft SQL Server 2008. The instance contains a database named Finance. The recovery model of the Finance database is set to Full. A full database backup of all the user databases is performed at 02:00 hours daily. The transaction log backup occurs every 15 minutes. A differential backup is performed every 4 hours. You plan to perform a full backup of the Finance database at 11:00 hours. You need to ensure that the backup is performed without affecting the overall backup and restore procedures for the Finance database. You also need to ensure that the backup files are restored in proper sequence. Which Transact-SQL statement should you use?
A.BACKUP LOG FINANCE TO DISK = ‘t:\backups\finance.trn’;
B.BACKUP DATABASE FINANCE TO DISK = ‘t:\backups\finance.bak’ WITH NOUNLOAD;
C.BACKUP DATABASE FINANCE TO DISK = ‘t:\backups\finance.bak’ WITH COPY_ONLY;
D.BACKUP DATABASE FINANCE TO DISK = ‘t:\backups\finance.bak’ WITH DIFFERENTIAL;
Correct Answers: C
8: You administer a SQL Server 2008 instance. You need to configure the instance to use a single thread for queries that have an estimated execution cost less than 3. Which sp_configure configuration option should you set?
A.priority boost
B.precompute rank
C.max worker threads
D.query governor cost limit
E.cost threshold for parallelism
Correct Answers: E
9: You maintain a default SQL Server 2008 instance.
You plan to configure FILESTREAM data to meet the following requirements:
Enable FILESTREAM for file I/O streaming access.
Allow remote client computers to have streaming access to FILESTREAM data.
You need to ensure that FILESTREAM data is enabled.
Which service should you configure?
A.SQL Server
B.SQL Server Full Text
C.SQL Server VSS Writer
D.Distributed File System
Correct Answers: A
10: You need to install a SQL Server 2008 instance for a new application on an existing server that contains a default SQL Server 2005 instance.
You need to ensure that both database instances are available for their respective certified third-party applications. You need to achieve this goal by complying with the following constraints:
Minimal database administrative effort.
The existing application environments remain unchanged.
What should you do?
A.Upgrade the SQL Server 2005 application to use SQL Server 2008.
B.Upgrade the SQL Server 2005 instance to a SQL Server 2008 instance.
C.Install SQL Server 2008 as a named instance, and configure the new application to use the new instance.
D.Install SQL Server 2008 as the default instance, and configure the new application to use the default instance.
Correct Answers: C
Download | Password: certificatexam.com