1Z0-908 무료 덤프문제 온라인 액세스

You have semi-synchronous replication configured and working with one slave.
rpl_semi_sync_master_timeout has never been reached.
You find that the disk system on the master has failed and as a result, the data on the master is completely unrecoverable.
Which two statements are true? (Choose two.)

• A.The slave automatically identifies that the master is unreachable and performs any required actions so that applications can start using the slave as the new master.
• B.Reads from the slave can return outdated data until the value of the rpi_semi_sync_master_timeout variable is reached.
• C.As soon as the incident happens, application can read data from the slave and rely on it to return a full and current set of data.
• D.Reads from the slave can return outdated data for some time, until it applies all transactions from its relay log.
• E.A small amount of committed transactions may be lost in case they were committed just before the disk failure.
• F.No committed transactions are lost.

You are considering using file-system snapshots to back up MySQL.
Which three statements are true? (Choose three.)

• A.They do not use additional disk space.
• B.The backup window is almost zero from the perspective of the application.
• C.They do not back up views, stored procedures, or configuration files.
• D.They allow direct copying of table rows with operating system copy commands.
• E.They take roughly twice as long as logical backups.
• F.There is a slight performance cost while the snapshot is active.
• G.They work best for transaction storage engines that can perform their own recovery when restored.

You wish to protect your MySQL database against SQL injection attacks.
Which method would fail to do this?

• A.avoiding concatenation of SQL statements and user-supplied values in an application
• B.using PREPARED STATEMENTS
• C.installing and configuring the Connection Control plugin
• D.using stored procedures for any database access

Examine this query and output:

Which two statements are true? (Choose two.)

• A.35 rows from the city table are included in the result.
• B.The query returns exactly 125 rows.
• C.It takes more than 8 milliseconds to sort the rows.
• D.The optimizer estimates that 51 rows in the country table have Continent = 'Asia'.
• E.The country table is accessed as the first table, and then joined to the city table.

Binary log events for the 'mydb1' schema must be copied to a different schema name 'mydb2'.
Which command will do this?

• A.mysqlbinlog --rewrite-db='mydb1->mydb2' | mysql
• B.mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql
• C.mysqlbinlog --rewrite-db='mydb1' --rewrite-db='mydb2' | mysql
• D.mysqlbinlog --read-from-remote-server --raw | sed 's/mydb1/mydb2/g' | mysql