题目内容

You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security,troubleshooting, deployment and optimization. A SQL Server 2008 infrastructure is managed by you. A database is included by the instance, and a table named EmployeeData is contained by the database. There is a column named Profile in the EmployeeData table. Microsoft Office Word 2003 documents are stored in the column. The space utilized by the Profile column should be cut to the least. In addition, a reasonable performance should be maintained to retrieve the content of the column. Which action will you perform?()

A. ROW compression should be utilized for the EmployeeData table.
B. The Profile column should be stored by utilizing filestream storage, and the NTFS file system Compression should be utilized.
C. PAGE LEVEL compression should be utilized for the EmployeeData table.
D. The Profile column should be implemented as a CLR user-defined type.

查看答案
更多问题

素有“植物中的肉类”美称的是以下哪种食物()

A. 大豆
B. 土豆
C. 玉米
D. 大米

水闸消能防冲的主要措施有消力池、()、防冲槽等。

登杆塔巡视必须有专人进行监护,以防止触电伤人

A. 正确
B. 错误

通过投资来实现基金的保值增值就成为年金管理的关键问题。

A. 正确
B. 错误

答案查题题库