單項(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.

單項(xiàng)選擇題

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.

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

你可能感興趣的試題

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线