单选题ROW-based replication has stopped working. You investigate the error log file and find the following entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1; Can't find record in 't1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log 56_master-bin. 000003, end_log_pos 851, Error_code: 1032 2013-08-27 14:15:47 9056 [warning] Slave: Can't find record in 't1' Error_code: 1032 2013-08-27 14:15:47 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log '56_masterbin. 000003' position 684 Why did you receive this error?（）AThe slave SQL thread does not have DELETE privileges to execute on test.t1 table.sBThe table definition on the slave -litters from the masterCMulti-threaded replication slaves can have temporary errors occurring for cross database updatesDThe slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist
单选题
ROW-based replication has stopped working. You investigate the error log file and find the following entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1; Can't find record in 't1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log 56_master-bin. 000003, end_log_pos 851, Error_code: 1032 2013-08-27 14:15:47 9056 [warning] Slave: Can't find record in 't1' Error_code: 1032 2013-08-27 14:15:47 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log '56_masterbin. 000003' position 684 Why did you receive this error?（）
A
The slave SQL thread does not have DELETE privileges to execute on test.t1 table.s
B
The table definition on the slave -litters from the master
C
Multi-threaded replication slaves can have temporary errors occurring for cross database updates
D
The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist
参考解析
解析：
暂无解析
相关考题：
–What’s the time by your watch? –____________________. (A) Sorry, my watch has stopped(B) Yes, I can tell you(C) It’s ten fifteen(D) Both A) and C)
2． You_________ make the dishes if you don t like to．A． have not toB． has not toC． don't have toD． doesn’t have to
If you ______ my advice, you wouldn’t be in such trouble now.A. tookB. takesC. has takenD. had taken
－ Sally, could you lend me your calculator Mine is not working. －() A、No, I can’t.B、It doesn’t matter.C、Sure, why do you need it
Most insurance agents would rather you don t do anything about collecting claims until they investigate the situation.() 此题为判断题(对，错)。
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 is named Wiikigo Corp. The company 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 Dworks in the instance. The Dworks database has the Products table. Now you have to replicate the Products table to the SQL Server instances at remote locations, so you create a Merge Replication topology and a Publication to do this. The Publication has a 21-day retention period. There is a user who goes on a business trip, 30 days later he comes back and finds that data in his database is not the latest. The Windows Event log states the following error message: "Replication: expired subscription dropped." You must get the latest data in the user's database and make sure that future data changes are appropriately replicated. So what action should you perform to achieve this goal? （） A、You should recreate the publication B、You should upload unsynchronized changes. C、You should reinitialize the publication and generate a new snapshot at once. D、You should upload unsynchronized changes, and then reinitialize the publication
A customers has asked you to investigate their current x86 server environment to determinate if they can achieve a reduction in power and rack consumption. They plan to implement VMware and the local storage shared. Which of the following consolidation proposals meets these needs？（）A、BladeCenter SB、BladeCenter HC、BladeCenter ED、BladeCenter HT
To increase the availability of an Advanced Replication environment， you can add a new master to a replication group without quiescing the group. This is achieved（）.A、Only when the new master site already has existing replication groups. B、By issuing a single command to create, populate, and activate the new master. C、When the master definition site is not the same for all of the master groups. D、Without impacting end users who are executing data manipulation language (DML) commands on the replicated tables.
ROW-based replication has stopped working. You investigate the error log file and find the following entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1; Can't find record in 't1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log 56_master-bin. 000003, end_log_pos 851, Error_code: 1032 2013-08-27 14:15:47 9056 [warning] Slave: Can't find record in 't1' Error_code: 1032 2013-08-27 14:15:47 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log '56_masterbin. 000003' position 684 Why did you receive this error?（）A、The slave SQL thread does not have DELETE privileges to execute on test.t1 table.sB、The table definition on the slave -litters from the masterC、Multi-threaded replication slaves can have temporary errors occurring for cross database updatesD、The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist
You are designing the DNS topology to meet the business and technical requirements. Which DNS structure should you use？（）A、 one primary zoneB、 two primary zonesC、 one Active Directory-integrated zone that has the replication scope set to all DNS servers in the forest.D、 two Active Directory-integrated zones that have the replication scopes set to all DNS servers in the forest.E、 one Active Directory-integrated zone that has the replication scope set to all domain controllers in the domain.F、 two Active Directory-integrated zones that have the replication scopes set to all domain controllers in the domain.
Your company has a main office and a branch office You deploy a read-only domain controller （RODC） that runs Microsoft Windows Server 2008 to the branch office You need to ensure that users at the branch office are able to log on to the domain by using the RODC What should you do（）A、Add another RODC to the branch officeB、Configure a new bridgehead server in the main officeC、Configure the Password Replication Policy on the RODCD、Decrease the replication interval for all connection objects by using the Actrve Directory Sites and Services console
Your organization has 5 Mailbox servers and 5 Active directory servers.You need to install a new Mailbox server.During the installation you notice the mailbox database will not mount. What should you do to make sure you can install the mailbox server：（）A、Configure all domain controllers as Global Catalog Servers.B、Install the Exchange Server 2010 Administration Tools on a domain controller.C、Force the replication of the AD domain partition between all domain controllers.D、Force the replication of the AD configuration partition between all domain controllers.
Your company has three Active Directory domains in a single forest. You install a new Active Directory enabled application. The application ads new user attributes to the Active Directory schema. You discover that the Active Directory replication traffic to the Global Catalogs has increased. You need to prevent the new attributes from being replicated to the Global Catalog. You must achieve this goal without affecting application functionality. What should you do（）A、Change the replication interval for the DEFAULTIPSITELINK object to 9990.B、Change the cost for the DEFAULTIPSITELINK object to 9990.C、Make the new attributes in the Active Directory as defunct.D、Modify the properties in the Active Directory schema for the new attributes.
Your company has a main office and three branch offices. The company has an Active Directory forest that has a single domain. Each office has one domain controller. Each office is configured as an Active Directory site. All sites are connected with the DEFAULTIPSITELINK object. You need to decrease the replication latency between the domain controllers. What should you do（）A、Decrease the cost between the connection objects.B、Decrease the replication interval for all connection objects.C、Decrease the replication interval for the DEFAUL TIPSITELINK object.D、Decrease the replication schedule for the DEFAUL TIPSITELINK object.
单选题You are designing the DNS topology to meet the business and technical requirements. Which DNS structure should you use?（）Aone primary zoneBtwo primary zones Cone Active Directory-integrated zone that has the replication scope set to all DNS servers in the forest.Dtwo Active Directory-integrated zones that have the replication scopes set to all DNS servers in the forest.Eone Active Directory-integrated zone that has the replication scope set to all domain controllers in the domain.Ftwo Active Directory-integrated zones that have the replication scopes set to all domain controllers in the domain.
单选题The agent has probably already handed over you the stowage plan,（）?Aisn't heBdoesn't heChasn't heDdidn't he
多选题Certkiller.com has an active directory forest on a single domain. Certkiller needs a distributed application that employs a custom application. The application is directory partition software named PARDAT. You need to implement this application for data replication. Which two tools should you use to achieve this task（）ADnscmd.BNtdsutil.CIpconfigDDnsutilEAll of the above
单选题A customer states their computer was fine until yesterday when they heard a pop noise and thecomputer stopped working. Which of the following components should the technician test FIRST?（）AMain system boardBProcessorCHard disk driveDPower supply
多选题A MySQL replication slave is set up as follows: User all InnoDB tables Receives ROW-based binary logs Has the read-only option The replication slave has been found in an error state. You check the MySQL error log file and find the following entries: 2013-08-27 13:55:44 9056 [ERROR] Slave SQL: Could not execute Write_rows event on table test.tl; Duplicate entry ‘3’ for key’PRIMARY’ , Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event’s master log 56_master-bin.000003, end_log_pas 653, Error_code: 1062 2013-08-27 13:55:44 9056 [Warning] Salve: Duplicate entry ‘3’ for key ‘PRIMARY’ Error_code: 1062 2013-08-27 13:55:44 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with “SLAVE START”, We stopped at log ‘56_masterbin.000003’ position 496 What are two possible causes for this error to occur?（）AThe slave was created with mysqldump –u root –p – skip-lock-table—all-databases /data/data.sqlBThe slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows functionCFor tables with UNIQUE keys, statement-based replication must be used maintain integrityDThe root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewriteEThe applications have the SUPER privilege, which allows them to update rows
单选题ROW-based replication has stopped working. You investigate the error log file and find the following entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1; Can't find record in 't1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log 56_master-bin. 000003, end_log_pos 851, Error_code: 1032 2013-08-27 14:15:47 9056 [warning] Slave: Can't find record in 't1' Error_code: 1032 2013-08-27 14:15:47 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log '56_masterbin. 000003' position 684 Why did you receive this error?（）AThe slave SQL thread does not have DELETE privileges to execute on test.t1 table.sBThe table definition on the slave -litters from the masterCMulti-threaded replication slaves can have temporary errors occurring for cross database updatesDThe slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist
单选题To increase the availability of an Advanced Replication environment， you can add a new master to a replication group without quiescing the group. This is achieved（）.AOnly when the new master site already has existing replication groups. BBy issuing a single command to create, populate, and activate the new master. CWhen the master definition site is not the same for all of the master groups. DWithout impacting end users who are executing data manipulation language (DML) commands on the replicated tables.
单选题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?（）AYou should implement the Snapshot Replication topology along with a Push Subscription. BYou should implement the Merge Replication topology along with a Pull Subscription. CYou should implement the Snapshot Replication topology along with a Pull Subscription. DYou should implement the Transactional Replication topology along with a Pull Subscription
单选题Certkiller has an Active Directory forest with six domains. The company has 5 sites. The company requires a new distributed application that uses a custom application directory partition named ResData for data replication. The application is installed on one member server in five sites. You need to configure the five member servers to receive the ResData application directory partition for data replication. What should you do（）ARun the Dcpromo utility on the five member servers.BRun the Regsvr32 command on the five member serversCRun the Webadmin command on the five member serversDRun the RacAgent utility on the five member servers
单选题At sea，you are approaching a small vessel and see that it has the signal flag P hoisted. What should you do?（）.AProceed on present course and speed since the vessel is stopped and making no way through the waterBKeep clear of the vessel because it has a diver downCAttempt to call the vessel on VHF radiotelephone because someone on board requires medical assistanceDApproach with caution because the vessel is a fishing vessel and its nets are fouled on an obstruction
单选题A: What a pleasant surprise! I haven’t seen you for a long time. B: ______ANice to meet you.BPretty good. Thanks. And you?CI just stopped by to say hello.DWell, how have you been?
单选题Certkiller .com has a main office and branch office in another city. You are assigned to deploy and implement a Read-only Domain Controller （RODC） at the branch office. You deploy a RODC that runs Windows Server 2008. What should you do to ensure that the users at the branch office can log on to the domain using RODC（）AUse Password Replication Policy on the RODCBAdd RODC to the main officeCDeploy and configure a new bridgehead server in the branch officeDDeploy and configure a Password Replication Policy on the RODC in the main office
单选题Your company， Contoso， Ltd ， has offices in North America and Europe. Contoso has an Active Directory forest that has three domains. You need to reduce the time required to authenticate users from the labs.eu. contoso.com domain when they access resources in the eng.na.contoso.com domain. What should you do（）ADecrease the replication interval for all Connection objects.BDecrease the replication interval for the DEFAULTIPSITELINK site link.CSet up a one-way shortcut trust from eng.na.contoso.com to labs.eu.contoso.com.DSet up a one-way shortcut trust from labs.eu.contoso.com to eng.na.contoso.com.