March Special Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: buysanta

Exact2Pass Menu

Question # 4

Your MySQL environment has asynchronous position based-replication with one master and one slave.

The slave instance had a disk I/O problem, so it was stopped.

You determined that the slave relay log files were corrupted and unusable, but no other files are damaged.

You restart MySQL Server.

How can replication be restored?

A.

The slave relay logs should be deleted; then execute START SLAVE;

B.

The relay logs from the master should be used to replace the corrupted relay logs.

C.

The slave relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;

D.

The slave needs to be restored from backup.

Full Access
Question # 5

Examine this MySQL Shell command:

dba.rebootClusterFromCompleteOutage()

Which two statements are true? (Choose two.)

A.

It reconfigures InnoDB Cluster if the cluster was stopped.

B.

It performs InnoDB Cluster instances rolling restart.

C.

It only starts all InnoDB Cluster instances.

D.

It is not mandatory that all instances are running and reachable before running the command.

E.

It stops and restarts all InnoDB Cluster instances and initializes the metadata.

F.

It only stops and restarts all InnoDB Cluster instances.

G.

It picks the minimum number of instances necessary to rebuild the quorum and reconfigures InnoDB Cluster.

Full Access
Question # 6

Which two statements are true about raw binary backups? (Choose two.)

A.

They are converted to a highly compressible binary format.

B.

The data format is identical to how MySQL stores the data on disk.

C.

They are required to obtain FIPS security compliance.

D.

The resulting files are easily human readable.

E.

They are faster than logical backups because the process is a simple file or file system copy.

Full Access
Question # 7

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-.*" backup

Which optimization process best describes what happens with the redo logs?

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.

E.

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

Full Access
Question # 8

You have a MySQL system with 500 GB of data that needs frequent backups.

You use a mix of MyISAM and InnoDB storage engines for your data. Examine your backup requirement:

  • The MySQL system being backed up can never be unavailable or locked to the client applications.
  • The recovery from the backup must work on any system.
  • Only 1 hour of data can be lost on recovery of the backup.

Which option fulfills all backup requirements?

A.

Take a physical backup of the MySQL system.

B.

Use the Clone Plugin to copy the data to another MySQL system.

C.

Take a logical backup of the MySQL system.

D.

Take your backup from a slave of the MySQL system.

Full Access
Question # 9

You wish to protect your MySQL database against SQL injection attacks.

Which method would fail to do this?

A.

installing and configuring the Connection Control plugin

B.

avoiding concatenation of SQL statements and user-supplied values in an application

C.

using stored procedures for any database access

D.

using PREPARED STATEMENTS

Full Access
Question # 10

You are having performance issues with MySQL instances. Those servers are monitored with MySQL Enterprise Monitor.

Using Query Analyzer, where do you begin to look for problem queries?

A.

Sort the “Exec" column and check for SQL queries with low Query Response Time index (QRTi) values.

B.

Look for queries with low total latency times in the Latency section in the times series graph.

C.

Look for queries with big prolonged spikes in row activity/access graph in the times series graph.

D.

Sort the “Exec" column and check for SQL queries with high Query Response Time index (QRTi) values.

Full Access
Question # 11

You wish to store the username and password for a client connection to MySQL server in a file on a local file system.

Which is the best way to encrypt the file?

A.

Use the AES_ENCRYPT() MySQL function on the option file.

B.

Use mysql_secure_installation to encrypt stored login credentials.

C.

Use a text editor to create a new defaults file and encrypt it from Linux prompt.

D.

Use mysql_config_editor to create an encrypted file.

Full Access
Question # 12

Which four are types of information stored in the MySQL data dictionary? (Choose four.)

A.

performance metrics

B.

table definitions

C.

access control lists

D.

view definitions

E.

server runtime configuration

F.

server configuration rollback

G.

stored procedure definitions

Full Access
Question # 13

MySQL is installed on a Linux server with this configuration:

Which method sets the default authentication to SHA-256 hashing for authenticating user account passwords?

A.

Set validate-user-plugins=caching_sha2_password in the configuration file.

B.

Define CREATE USER ''@'%' IDENTIFIED WITH sha256_password in the MySQL instance.

C.

Add default_authentication_plugin=mysql_native_password in the configuration file.

D.

Add default_authentication_plugin=sha256_password in the configuration file.

Full Access
Question # 14

You want to log only the changes made to the database objects and data on the MySQL system.

Which log will do this by default?

A.

general query log

B.

audit log

C.

slow query log

D.

binary log

E.

error log

Full Access
Question # 15

You are upgrading a MySQL instance to the latest 8.0 version.

Examine this output:

You plan to add this parameter to the configuration: innodb_directories=’/innodb_extras’ Which statement is true?

A.

It defines all innodb tablespace options relative to a starting parent directory.

B.

It is not necessary because innodb_data_home_dir is already defined.

C.

It allows scanning of other locations to discover more innodb tablespaces.

D.

It moves all innodb tablespaces to the /innodb_extras directory to enable a new

innodb_data_home_dir to be defined.

E.

It adds more temporary workspace in addition to the innodb_tmpdir location.

Full Access
Question # 16

Which two are use cases of MySQL asynchronous replication? (Choose two.)

A.

You can scale writes by creating a replicated mesh.

B.

It guarantees near real-time replication between a master and a slave.

C.

You can scale reads by adding multiple slaves.

D.

MySQL Enterprise Backup will automatically back up from an available slave.

E.

It allows backup to be done on the slave without impacting the master.

Full Access
Question # 17

A MySQL server is monitored using MySQL Enterprise Monitor’s agentless installation.

Which three features are available with this installation method? (Choose three.)

A.

MySQL Replication monitoring

B.

network-related information and network characteristics

C.

MySQL Query Analysis data

D.

CPU utilization

E.

security-related advisor warnings

F.

operating system memory utilization

G.

disk usage and disk characteristics including disk advisors warnings

Full Access
Question # 18

Which statement is true about displaying and retrieving data with MySQL Enterprise Monitor Query Analyzer?

A.

The Query Analyzer graph view range selector can extend to cover the same hour over multiple days.

B.

It is possible to filter a Query Analyzer view graph by database and by table.

C.

The Query Analyzer can plot a CPU utilization graph for remote hosts with a MySQL Enterprise Service Manager's built-in Agent installation.

D.

It is possible to export statements included in a graph selection in CSV format.

Full Access
Question # 19

You want to dump all databases with names that start with "db".

Which command will achieve this?

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

Full Access
Question # 20

Examine this command, which executes successfully:

mysqlpump -–user=root --password > full_backup.sql

Which two databases will be excluded from this dump? (Choose two.)

A.

information_schema

B.

world

C.

employee

D.

sys

E.

mysql

Full Access
Question # 21

Which statement is true about InnoDB persistent index statistics?

A.

Updating index statistics is an I/O expensive operation.

B.

Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.

C.

Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.

D.

Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.

E.

Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.

Full Access