You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which is named Instance01. Instance01 contains a database which is named SellingHelp. There isthe Products table in the SellingHelp database. Now according to the company requirement, the Products table has to be replicated to the SQL Server instances installed in laptopscomputers. You have to create a Replication topology to perform this. The Products table is updated from Instance01 when the laptops reconnect to the corporate network. The Products table on Instance01 is frequently updated between reconnections. You must make sure that you can implement the Replication topology along with the Subscription type successfully and meanwhile reduce the bandwidth usage to the least. So what action should you perform to achieve this goal?（）
A: You should implement the Snapshot Replication topology along with a Push Subscription.
B: You should implement the Merge Replication topology along with a Pull Subscription.
C: You should implement the Snapshot Replication topology along with a Pull Subscription.
D: You should implement the Transactional Replication topology along with a Pull Subscription
A: You should implement the Snapshot Replication topology along with a Push Subscription.
B: You should implement the Merge Replication topology along with a Pull Subscription.
C: You should implement the Snapshot Replication topology along with a Pull Subscription.
D: You should implement the Transactional Replication topology along with a Pull Subscription
举一反三
- You administer a SQL Server 2008 instance. The instance is located on a four-processor, quad-core server. The server frequently experiences CPU pressure. The instance contains a very large mission-critical database that is used continuously. You need to ensure that online index rebuilds do not consume all available CPU cycles. Which configuration option should you use?（） A: affinity mask B: affinity I/O mask C: max degree of parallelism D: optimize for ad hoc workload
- You administer a SQL Server 2008 instance. The instance is located on a four-processor, quad-core server. The server frequently experiences CPU pressure. The instance contains a very large mission-critical database that is used continuously. You need to ensure that online index rebuilds do not consume all available CPU cycles. Which configuration option should you use?（） A: affinity mask B: affinity I/O mask C: max degree of parallelism D: optimize for ad hoc workloads
- You work as the IT professional in an international company which is named Wiikigo. You are experiencedin implementing and administering a network operating system. You are specialized in deploying servers，configuring Windows Server 2008 Terminal services and network application services，and configuring aweb services infrastructure. You have the Windows Deployment Services （WDS） role installed on a serverthat runs Windows Server 2008. You plan to install Windows Vista on a computer that does not supportPreboot Execution Environment （PXE）. You have a Windows Vista image that is stored on the WDSserver. You have to start the computer and install the image that is stored on the WDS server. What shouldyou create？（） A: You should create a discover image B: You should create an install image C: You should create a capture image D: You should create a CD-ROM that contains PXE drivers
- You administer a SQL Server 2008 instance. The instance hosts a database that is used by a Web-based application. The application processes 15,000 transactions every minute. A table in the database contains a column that is used only by the application. This column stores sensitive data. You need to store the sensitive data in the most secure manner possible. You also need to ensure thatyou minimize the usage of memory space and processor time. Which encryption type should you use?（） A: Symmetric key encryption B: Asymmetric key encryption C: Certificate-based encryption D: Transparent data encryption
- You are a database administrator for your company. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use？（） A: DBCC DBREINDEX B: SELECT * FROM sys.dm_db_index_physical_stats C: DBCC INDEXDEFRAG D: SELECT * FROM sys.indexe