1Z0_908 questions • Exam prepare

Exam contains 143 questions

Page 20 of 24

Question 115 🔥

Your MySQL instance is capturing a huge amount of financial transactions every day in the finance database.Company policy is to create a backup every day.The main tables being updated are prefixed with transactions-.These tables are archived into tables that are prefixed with archives- each month. mysqlbackup --optimistic-busy-tables="^finance\.transactions-.*" backupWhich optimization process best describes what happens with the redo logs?

Which database solution meets these requirements?

A. The redo logs are backed up first, then the transaction and archive tables.

B. The redo logs are backed up only if there are changes showing for the transactions tables.

C. The redo logs are not backed up at all.

D. The archive tables are backed up first, then the transaction tables and redo logs.

Highly voted

E. The transaction tables are backed up first, then the archive tables and redo logs.

Discussion of the question

Question 116 🔥

You issue this command:SHOW SLAVE STATUS -In the output, there is a value for Seconds_behind_master.How is this time calculated?

Which database solution meets these requirements?

A. It is the time between the I/O thread receiving details of the master's last transaction and the time it was applied by the SQL thread.

Highly voted

B. It is the time between the most recent transaction written to the relay logs and the time it was committed on the master.

C. It is the time between the I/O thread receiving details of the master’s last transaction and the time it was written to the relay log on the slave.

D. It is the time between the most recent transaction applied by a SQL thread and the time it was committed on the master.

Discussion of the question

Question 117 🔥

All MySQL Server instances belonging to InnoDB Cluster have SSL configured and enabled.You must configure InnoDB Cluster to use SSL for group communication.Which two statements are true? (Choose two.)

Which database solution meets these requirements?

A. SSL group communication must be enabled at cluster creation time by specifying createCluster ({memberSslMode: 'REQUIRED'}).

Highly voted

B. Configuring SSL group communication also configures SSL distributed recovery.

C. An existing InnoDB Cluster must be dissolved and created from scratch to enable SSL for group communication.

Highly voted

D. SSL group communication can be enabled for an existing cluster, one instance at time, by setting group_replication_ssl_mode.

E. If only some InnoDB Cluster members are enabled for SSL group communication, and --ssl-mode=PREFERRED, communication will fall back to unencrypted connection.

F. SSL group communication requires the use of an additional set of parameters group_replication_recovery_*.

Discussion of the question

Question 118 🔥

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

Which database solution meets these requirements?

A. They take roughly twice as long as logical backups.

B. They allow direct copying of table rows with operating system copy commands.

C. They work best for transaction storage engines that can perform their own recovery when restored.

D. The backup window is almost zero from the perspective of the application.

Highly voted

E. They do not back up views, stored procedures, or configuration files.

F. There is a slight performance cost while the snapshot is active.

Highly voted

G. They do not use additional disk space.

Highly voted

Discussion of the question

Question 119 🔥

Examine this snippet from the binary log file named binlog.000036:The rental table was accidentally dropped, and you must recover the table.You have restored the last backup, which corresponds to the start of the binlog.000036 binary log.Which command will complete the recovery?

Which database solution meets these requirements?

A. mysqlbinlog --stop-position=500324 binlog.000036 | mysql

B. mysqlbinlog --stop-datetime='2019-ll-20 14:55:18' binlog.000036 | mysql

C. mysqlbinlog --stop-position=5004S3 binlog.000036 | mysql

D. mysqlbinlog --stop-datetime='2019-ll-20 14:55:16' binlog.000036 | mysql

Discussion of the question

Question 120 🔥

You want to dump all databases with names that start with "db".Which command will achieve this?

Which database solution meets these requirements?

A. mysqlpump --include-tables=db.% --result-file=all_db_backup.sql

B. mysqlpump > all_db_backup.sql

C. mysqlpump --include-databases=db --result-file=all_db_backup.sql

D. mysqlpump --include-databases=db% --result-file=all_db_backup.sql

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_908

Exam contains 143 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us