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

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

相关考题:

Which is true when describing a connection replication in Cisco ACE?()A、 It is not supported for SSL connections.B、 It is not supported for non-SSL connections.C、 It can only be configured manually.D、 It has a maximum limit of 50,000 replicated connections.

The customer has both AIX and Windows hosts and is complaining that their storage infrastructureis complex and distributed. They need to simplify backup and restore operations. What productshould the storage specialist be prepared to discuss with them?()A、Softek B、Tivoli Storage Manager FastBack C、Tivoli Storage Manager D、Tivoli Storage Productivity Center for Replication

A customer has two sites located 500 kilometers apart. The customer has both a high-speedInternet link and dark fiber between the sites. The customer wants to utilize storage resources ateither site leveraging replication for disaster recovery implementations. The customer wants to linkthese two sites together. Which option provides the highest performance and is most reliable?()A、iFCP routerB、FCIP routerC、DWDM and CWDMD、LC multi-mode 50 micron fiber

As part of a Business Continuance project, a customer has established replication from 3 spokesto a DR hub with ProtecTIER 7610 appliances. Each of the 3 spokes is backing up 500 GB ofnominal data daily with an average deduplication ratio of 10:1. The replication window is 12 hours.The data change rate is 15%. What is the approximate minimum required bandwidth for eachWAN connection?()A、1.2MB/sB、7.5MB/sC、12MB/sD、75MB/s

A customer needs to implement a Highly Available solution for JMS that has a primary data center  and a backup. Which three steps would you perform when designing your solution?()A、Store Transaction Logs in a database and use Database stores for JMS to make replication between sites easier.B、Use file based Transaction Logs and JMS stores and implement a separate replication solution  for files in addition to database in case database replication fails.C、Implement Oracle RAC at each site to provide a highly available solution within each datacenter.D、Configure Whole Server Migration to migrate WebLogic Managed Servers from the primary to the secondary site.E、Configure Automatic Service Migration for JMS high availability within a datacenter.

A customer has a web application with HTTP Sessions that need to be replicated to a backup site that is more than 100 miles away from the primary site, connected over the Internet.    Which type of session replication in WebLogic is recommended?()A、MAN ReplicationB、WAN Replication  C、Synchronous ReplicationD、Asynchronous ReplicationE、Database Replication

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 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.

单选题A customer has a critical, performance-sensitive web application that connects to a multinode  Oracle RAC database. Which feature of WebLogic can provide significant performance benefit?()AThe Web Session Affinity feature of Active GridLink for RACBWebLogic Clustering  CThe Transaction Affinity feature of Active GridLink for RACDCoherence*Web Session Replication

单选题A customer has purchased a new IBM Storwize V7000 storage array and is considering an IPbased DR replication solution that is cost-optimized and provides a near instant recovery option fortheir Microsoft Exchange application and server. The backup site is 30 kilometers away. Whatwould be the best choice for replication?()AStorwize V7000 Metro MirrorBTivoli Storage ManagerFastBackCStorwize V7000 Reverse FlashCopyDTivoli Storage Productivity Center for Replication

单选题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.

单选题Which is true when describing a connection replication in Cisco ACE?()A It is not supported for SSL connections.B It is not supported for non-SSL connections.C It can only be configured manually.D It has a maximum limit of 50,000 replicated connections.

多选题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.

单选题A customer has a critical, performance-sensitive web application that connects to a multimode  Oracle RAC database. Which feature of WebLogic can provide signification benefit?()AThe Web Session Affinity feature of Active GridLink for RACBWebLogic ClusteringCThe Transaction Affinity feature of Active GridLink for RACDCoherence*Web Session Replication

单选题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

单选题A customer has a web application with HTTP Sessions that need to be replicated to a backup site that is more than 100 miles away from the primary site, connected over the Internet.    Which type of session replication in WebLogic is recommended?()AMAN ReplicationBWAN Replication  CSynchronous ReplicationDAsynchronous ReplicationEDatabase Replication

单选题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

多选题A customer needs to implement a Highly Available solution for JMS that has a primary data center  and a backup. Which three steps would you perform when designing your solution?()AStore Transaction Logs in a database and use Database stores for JMS to make replication between sites easier.BUse file based Transaction Logs and JMS stores and implement a separate replication solution  for files in addition to database in case database replication fails.CImplement Oracle RAC at each site to provide a highly available solution within each datacenter.DConfigure Whole Server Migration to migrate WebLogic Managed Servers from the primary to the secondary site.EConfigure Automatic Service Migration for JMS high availability within a datacenter.

单选题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.