單項選擇題

銷售部和財務(wù)部在兩棟不同的樓里。兩個部門由一個2兆位的網(wǎng)絡(luò)連接。并且都使用SQL Server 2005。銷售部在一個名為DB1的數(shù)據(jù)庫里記錄所有的銷售事務(wù)。DB1包含380張表，大小為10GB。財務(wù)部為做報表可以只讀方式訪問DB1里的4張表。財務(wù)部會全天進行查詢并需要盡可能最新的數(shù)據(jù)。財務(wù)部的用戶告訴你報表執(zhí)行非常緩慢。為優(yōu)化網(wǎng)絡(luò)容量，你的部門決定為財務(wù)部提供此四張表的副本。現(xiàn)在，你需要提供這些表的副本。因此，你想用一種占最小網(wǎng)絡(luò)帶寬的復(fù)制法達成此目標(biāo)，該怎樣做？（）

A.將DB1鏡像到財務(wù)部，以高有效性模式配置鏡像
B.建立DB1的每日事務(wù)日志傳輸?shù)截攧?wù)部
C.建立每日快照復(fù)制到財務(wù)部，定義一個只包含這四張表的發(fā)布
D.建立事務(wù)復(fù)制到財務(wù)部，定義一個只包含此四張表的發(fā)布

你可能感興趣的試題

單項選擇題

You work with a database named DB1， which is located on a SQL Server 2005 computer. You discover that a table scan on Table1 in DB1 causes a slow query. Table1 is a very large table that is used frequently. You ascertain that the query contains the following statement. SELECT col1， col2 FROM table1 WHERE col3 = You need to provide maximum query performance. Table1 must remain available to users.
What should you do？（）

A.Update all statistics on Table1 in DB1.
B.Use the CREATE STATISTICS statement in DB1 to create missing statistics on col3of Table1.
C.Set the priority boost server option to 1.
D.Execute the following statement.USE DB1GOCREATE INDEX index1 ON table1（col3）INCLUDE（col1， col2） WITH （ONLINE = ON）GO

單項選擇題

Your SQL Server 2005 database contains a table that has 500 million rows of data. Some of the data is historical and some is current. You need to partition the data on a single server to increase performance and optimize maintenance.
What should you do？（）

A.Implement horizontal partitioning.
B.Implement vertical partitioning.
C.Implement a raw partition.
D.Implement distributed partitioning.

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

你可能感興趣的試題

Your SQL Server 2005 database contains a table that has 500 million rows of data. Some of the data is historical and some is current. You need to partition the data on a single server to increase performance and optimize maintenance. What should you do？（）

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

Your SQL Server 2005 database contains a table that has 500 million rows of data. Some of the data is historical and some is current. You need to partition the data on a single server to increase performance and optimize maintenance.
What should you do？（）