[单选]
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A user database named Products is included by your SQL Server 2005 computer. SQL Server Integration Services （SSIS） packages are utilized to export data from the Products database to a text file. You deliver the text file to your company’s trading partners by utilizing FTP. You are required to make sure that your SSIS packages can be recovered from the occurrence of a disaster.
Which action should be performed to finish the task？（）

A . To finish the task，the Products database should be backed up.
B . To finish the task，your server should be set to utilize the full recovery model.
C . To finish the task，your server should be set to utilize the bulk-logged recovery model.
D . To finish the task， the msdb database should be backed up.

You need to ensure the Client dimension is able to support new orders and new client records. Which setting should you configure?（） ROLAP storage。 Lazy aggregations。 Write Enabled property。 Unknown Member functionality。大肠杆菌属于（）专性好氧菌。兼性厌氧菌。耐氧菌。厌氧菌。 Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command： LSNRCTL> STOP What would happen to the sessions that are presently connected to the database instance？（） The sessions are able to perform only queries.。 The sessions are not affected and continue to function normally.。 The active transactions are rolled back and the sessions get terminated.。 The sessions are not allowed to perform any operations till the listener is started.。 An administrator wants to mirror an important filesystem between two disks without mirroring the entire volume group. Which command should be used？（） cplv。 mirrorvg。 mklvcopy。 migratelv。随后策略

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A user database named Products is included by your SQL Server 2005 computer. SQL Server Integration Services （SSIS） packages are utilized to export data from the Products database to a text file. You deliver the text file to your company’s trading partners by utilizing FTP. You are required to make sure that your SSIS packages can be recovered from the occurrence of a disaster.
Which action should be performed to finish the task？（）

参考答案：

● 参考解析

本题暂无解析

当前位置：MCITP(70-447)题库

相关题目: