1Z0-908 Online Practice Questions and Answers

Examine this command, which executes successfully:

Which statement is true?

A. Only files for MySQL or Its built-in storage engines are backed

B. Only non-encrypted files are backed up.

C. The backup includes only data files and their metadata.

D. Only InnoDB data and log files are backed up.

E. Only tables stored in their own tablespaces are backed up.

Examine this statement and output: Which two SQL statements can jsmith execute? (Choose two.)

A. UPDATE world.country SET Name='all';

B. UPDATE world.country SET Name='one' LIMIT 1;

C. UPDATE world.country SET Name='new' WHERE Name='old';

D. UPDATE world.country SET Name=CONCAT('New ',Name);

E. UPDATE world.country SET Name='first' ORDER BY Name LIMIT

Examine this MySQL client command to connect to a remote database:

mysql -h remote.example.org -u root -p --protocol=TCP --ssl-mode=

Which two --ssl-mode values will ensure that an X.509-compliant certificate will be used to establish the

SSL/TLS connection to MySQL?

A. REQUIRED

B. VERIFY_CA

C. VERIFY_IDENTITY

D. PREFERRED

E. DISABLED

Examine these statements, which execute successfully: TRUNCATE test; BEGIN;

INSERT INTO test(id, name) VALUES(1, "Hello"); ROLLBACK;

SELECT id FROM test;

Which three storage engines would return a nonempty recordset for the test table when executing the statements? (Choose three.)

A. NDB

B. ARCHIVE

C. InnopB

D. BLACKHOLE

E. MEMORY

F. MyISAM

MySQL programs look for option files in standard locations.

Which method will show the option files and the order in which they are read?

A. shell> mysqladmin --debug

B. shell> mysql --print-defaults

C. shell> mysqld --help --verbose

D. mysql> SHOW GLOBAL VARIABLES;

You have an InnoDB Cluster configured with three servers.

Examine this command, which executes successfully:

mysqldump -uroot -p -d mydatabase > mydatabase_backup.sql

Due to data loss, the cluster is initialized and a restore is attempted resulting in this error:

ERROR 13176 (HY000) at line 23: Cannot update GTID_PURGED with the Group Replication plugin running

Which two actions, either one of which, can fix this error and allow a successful restore of the cluster? (Choose two.)

A. Stop all instances except the primary read/write master instance and run the restore.

B. Remove the @@GLOBAL.gtid_purged statement from the dump file.

C. Create the backup by using the --set-gtid-purged=OFF option.

D. Remove the group replication plugin from each instance before restoring.

E. Remove the @@GLOBAL.gtid_executed statement from the dump file.

F. Restore using the --set-gtid-purged=OFF option.

There are five MySQL instances configured with a working group replication. Examine the output of the group members:

Which two statements are true about network partitioning in the cluster? (Choose two.)

A. The cluster will shut down to preserve data consistency.

B. The cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.

C. The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.

D. There could be both a 2 node and 3 node group replication still running, so shutting down group replication and diagnosing the issue is recommended.

E. A manual intervention to force group members to be only the working two instances is required.

Which two statements are true about using MySQL Enterprise Monitor Query Analyzer? (Choose two.)

A. The single query QRTi pie chart in the Query Analyzer view is based on the average execution of all statements.

B. It is possible to retrieve a normalized statement, but never the exact statement that was executed.

C. It is possible to configure the Query Analysis built-in advisor to get notified about slow query execution.

D. It is possible to list and analyze statements in an arbitrary graph range selection from timeseries graphs.

E. It is possible to import data into the Query Analyzer from heterogeneous sources, such as CSV.

Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)

A. It supports only non-blob datatypes.

B. It does not support the transportable tablespaces feature.

C. It supports all indexes transparently.

D. It decrypts data for use in memory.

E. It enforces encryption from disk to memory and over network transmission.

You are backing up raw InnoDB files by using mysqlbackup.

Which two groups of files will be backed up during a full backup? (Choose two.)

A. ibbackup files

B. *.CSM files

C. *.sdi files

D. *.ibd files

E. ib_logfile* files