多項(xiàng)選擇題

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.

你可能感興趣的試題

單項(xiàng)選擇題

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.

單項(xiàng)選擇題

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.

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

你可能感興趣的試題

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精