多项选择题
You administer a SQL Server 2008 instance. You deploy a new database named Engineering. The Engineering database manages large documents that will be revised occasionally. You need to design a table structure that allows fast read access. You also need to minimize storage space requirements.
Which two actions should you perform?（）
A.Use NTFS file system compression on the volume.
B.Use row-level compression on the document table.
C.Use varbinary(MAX) data type with FILESTREAM storage.
D.Enable row-level compression on all columns that use the vardecimal() data type.
相关考题
-
单项选择题
You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-only reference data. You need to design the physical database structure for optimal backup performance. What should you do?（）
A.Create the database by using a single data file and a single log file.
B.Create the database by using a single data file and multiple log files.
C.Create the database by using a single log file and multiple filegroups.
D.Create the database by using a single log file and a filegroup that has multiple data files. -
单项选择题
You administer a SQL Server 2008 instance. The instance runs on a computer that has the following features: A 64-GB RAM Four quad-core processors Several independent physical raid volumes You plan to implement a transactional database on the instance. The database is expected to have a high volume of INSERT, UPDATE, and DELETE activities. The activities include creation of new tables. You need to optimize the performance of the database by maximizing disk bandwidth and reducing the contention in the storage allocation structures. What should you do?（）
A.Create multiple data files for the database.
B.Place database and log files on the same volume.
C.Configure the affinity mask option appropriately.
D.Configure the affinity I/O mask option appropriately. -
单项选择题
You administer a SQL Server 2008 infrastructure. An instance runs on a computer that has eight quad-core processors and 128-GB RAM. Four different applications use the instance. The instance experiences a low number of CXPACKET waits. The instance also experiences a large number of lazy writer waits. You need to optimize the performance of the instance. What should you do?（）
A.Configure the Resource Governor.
B.Configure the Windows System Resource Manager.
C.Configure software non-uniform memory access (soft-NUMA).
D.Configure an increase in the maximum degree of parallelism option.
