Microsoft-TS Microsoft SQL Server 2008 - Implementation and Maintenance

You are a database administrator for your company. There are four automated testing areas for finished items in the company's manufacturing floor. SQL Server 2008 is used to reserve testing results for every testing area. You should create a replication method to make sure that test results flow from the testing areas to the SQL Server quickly. The results of testing will be used on reporting. Which is the correct answer?

SQL Server Agent can be used to run and schedule jobs that perform one or more tasks. How can you run a job using SQL Server Agent?

The tempbd plays an even more important role than in previous versions of SQL Server. This includes DBCC operations, event notifications, large object variables and parameters. Its important to ensure that certain settings are enabled for the tempdb database. Which two are likely settings that you should configure?

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 Enterprise Edition instance. There is a database named DB1 in the instance. A backup of DB1 is performed every day. You have to minimize the size of the full database backup files of DB1. In the options below, which Transact-SQL statement should you use?

You maintain a SQL Server 2008 Enterprise Edition instance that contains a database named Finance. You need to reduce the size of the full database backup files of the Finance database. Which Transact-SQL statement should you use?

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. You have set the recovery model of DB1 to Full. At 2:00 There is a full database backup of all the user databases every day. Every quarter the transaction log backup is performed. Every 4 hours a differential backup is occurred. You are going to perform a full backup of DB1 at 11:00. When you perform this back up, you must make sure that the overall backup will not be affected. What's more, you have to restore procedures for DB1. You must make sure that the backup files are restored in proper sequence. In the options below, which Transact-SQL statement should you use?

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?

You maintain a SQL Server 2008 instance. The SQL Server instance is configured to use the T1222 and T1204 trace flags during startup. You need to ensure that your failure recovery plan backs up the use of the trace flags. What should you do?

You administer a SQL Server 2008 instance. You use the SQL Server Import and Export Wizard to export data from SQL Server to a Microsoft Excel file. You save the package definition to a file. You need to reexecute the package from the command line. Which utility should you use?

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The company wants to export data from SQL Server to a Microsoft Excel file. The company assigns this task to you. You perform this by using the SQL Server Import and Export Wizard. After this, you save the package definition to a file. Now you have to reexecute the package from the command line. In the options below, which utility should you choose to use?