题目

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

答案
查看答案
相关试题

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. There is a database named DB1 in the instance. TheDB1 database includes spatial data types. On DB1 databse, you have to perform a database consistency check to include the spatial indexes. Besides this, you must make sure that you can reduce the effect on the database concurrency to the least.  So which Transact-SQL statement should you run? () 

A、DBCC CHECKCATALOG (DB1); 

B、DBCC CHECKALLOC (DB1) WITH TABLOCK; 

C、DBCC CHECKDB (DB1) WITH TABLOCK, PHYSICAL_ONLY; 

D、DBCC CHECKDB (DB1) WITH EXTENDED_LOGICAL_CHECKS; 

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. There are queries that have an estimated execution cost less than 3. You intend to configure the instance, make it use a single thread for these queries. In the options below, which sp_configure configuration option should you set?()

A、You should set query governor cost limit

B、You should set cost threshold for parallelism

C、You should set priority boost 

D、You should set precompute rank

下列各项,主要概括药物药性和作用的是()

A、归经

B、四气五味

C、升降浮沉

D、有毒无毒

E、配伍七情

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. There is a stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this, you must make sure that after it is completed successfully, the job is removed.  What should you do? ()

A、You should create a job which is assigned to the Database Maintenance category

B、You should create an Alert which will run another to delete the maintenance job.

C、You should create a job. You schedule the job to run only once.

D、You should create a job. The job uses the Automatically delete job option

下列各项中符合方剂组成要求的是()

A、每方必须君、臣、佐、使俱全

B、方中诸药均须有相应的针对症状

C、方中必有一药专作引经之用

D、君药的用量必须在全方总药量中所占比例最大

E、方中诸药既须主次有序,各司其职,又须密切配合,相与宣摄

最新解答的试题
提出现代生物-心理-社会医学模式是()

A.恩格尔B.波特C.托马斯·帕茨瓦尔D.比彻尔E.桑德斯
付款人在进行付款时无()

A.形式审查义务

B.实质审查义务

C.附带审查义务

D.票据外有关事项的审查义务
根据《公司法》的规定,有限责任公司下列人员中,可以提议召开股东会临时会议的是()。
A.总经理B.人数过半数的股东C.监事会主席D.人数为半数的董事
关于股份有限公司中的监事会,下列说法错误的是()

A.监事会负责提议聘请或更换外部审计机构B.监事会主席和副主席由全体监事过半数选举产生C.监事会中的职工代表的比例不得低于三分之一D.监事会应至少每6个月召开一次会议
三北精神的科学内涵