Weekend Sale - Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70dumps

1z0-908 Questions and Answers

Question # 6

You have an installation of MySQL 8 on Oracle Linux.

Consider the outputs:

Which statement is true about disk temporary tables for this installation?

A.

Only internal temporary tables from the optimizer will be created in tmpdir.

B.

Temporary tables will use the InnoDB temporary tablespace located in datadir.

C.

Temporary tables are created in tmpdir only if configured to use MyISAM.

D.

Temporary tables are created in tmpdir only after they reach tmp_tabie_size.

E.

Temporary tables will use the InnoDB temporary tablespace located in /tmp.

Full Access
Question # 7

You must run multiple instances of MySQL Server on a single host.

Which three methods are supported? (Choose three.)

A.

Run MySQL Server docker containers.

B.

Use systemd with different settings for each instance.

C.

Use system tools to lock each instance to its own CPU.

D.

Start mysqld or mysqld_safe using different option files for each instance.

E.

Run mysqld with --datadir defined for each instance.

F.

Use resource groups to lock different instances on separate CPUs.

Full Access
Question # 8

Examine this list of MySQL data directory binary logs:

binlog.000001 binlog.000002

.....

binlog.000289

binlog.000300

binlog.000301

binlog.index

Now examine this command, which executes successfully:

mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql

Which two are true? (Choose two.)

A.

All databases are backed up to the output file.

B.

All non-active binary logs are removed from the master.

C.

All binary logs are deleted from the master.

D.

All binary logs are backed up and then deleted.

E.

All databases, excluding master metadata, are backed up to the output file.

F.

All details regarding deleted logs and master metadata are captured in the output file.

Full Access
Question # 9

Which three are requirements for a secure MySQL Server environment? (Choose three.)

A.

Restrict the number of OS users that have access at the OS level.

B.

Ensure appropriate file system privileges for OS users and groups.

C.

Minimize the number of non-MySQL Server-related processes running on the server host.

D.

Encrypt the file system to avoid needing exact file-system permissions.

E.

Keep the entire software stack on one OS host.

F.

Run MySQL server as the root user to prevent incorrect sudo settings.

Full Access
Question # 10

Examine this statement, which executes successfully:

You want to improve the performance of this query:

Which change enables the query to succeed while accessing fewer rows?

A.

ALTER TABLE world.city ADD SPATIAL INDEX (Name);

B.

ALTER TABLE world.city ADD SPATIAL INDEX (Population);

C.

ALTER TABLE world.city ADD INDEX (Population);

D.

ALTER TABLE world.city ADD INDEX (Name);

E.

ALTER TABLE world.city ADD FULLTEXT INDEX (Name);

F.

ALTER TABLE world.city ADD FULLTEXT INDEX (Population);

Full Access
Question # 11

Which three are types of InnoDB tablespaces? (Choose three.)

A.

redo tablespaces

B.

encryption tablespaces

C.

schema tablespaces

D.

data tablespaces

E.

undo tablespaces

F.

temporary table tablespaces

Full Access
Question # 12

On examination, your MySQL installation datadir has become recursively world read/write/executable.

What are two major concerns of running an installation with incorrect file privileges? (Choose two.)

A.

Users could overwrite configuration files.

B.

Data files could be deleted.

C.

SQL injections could be used to insert bad data into the database.

D.

MySQL binaries could be damaged, deleted, or altered.

E.

Extra startup time would be required for the MySQL server to reset the privileges.

Full Access
Question # 13

Examine these statements, which execute successfully:

CREATE ROLE r_world_rd;

GRANT SELECT ON world.* TO r_world_rd;

CREATE USER john IDENTIFIED BY ‘P@ssw0rd’;

GRANT r_world_rd TO john;

Examine these statements issued by user John:

What is the reason for the error?

A.

The statement was blocked by MySQL Firewall.

B.

John has not activated the role.

C.

John needs to reconnect to the database.

D.

The DBA needs to execute FLUSH PRIVILEGES.

Full Access
Question # 14

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 # 15

Which two are valid uses for binary logs on a MySQL instance? (Choose two.)

A.

recording the order in which queries are issued

B.

audit of all queries

C.

point-in-time recovery

D.

replication

E.

logging the duration and locks for all queries

Full Access
Question # 16

Which three statements are true about MySQL replication? (Choose three.)

A.

Replication can use only TCP/IP connections.

B.

Any instance can have multiple slaves, but it can have only one master.

C.

Each instance in a replication topology must have a unique server ID.

D.

Binary logs contain only transactions originating from a single MySQL instance.

E.

Each slave must have its own MySQL user for replication.

F.

Binary logging must be enabled on the master in order to replicate to other instances.

G.

A replication user must have the SELECT privilege for all tables that need to be replicated.

Full Access
Question # 17

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 # 18

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.

Full Access
Question # 19

Which three requirements must be enabled for group replication? (Choose three.)

A.

slave updates logging

B.

semi-sync replication plugin

C.

primary key or primary key equivalent on every table

D.

binary log checksum

E.

binary log ROW format

F.

binary log MIXED format

G.

replication filters

Full Access
Question # 20

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.

F.

Tables are scanned and index statistics recalculated when an instance is restarted.

Full Access
Question # 21

Examine this command, which executes successfully on InnoDB Cluster: dba.dropMetadataSchema()

Which two statements are true? (Choose two.)

A.

Group Replication will be dissolved and all metadata purged.

B.

Group Replication is still operational, but InnoDB Cluster must be reimported under MySQL Shell.

C.

The mysql_innodb_cluster_metadata schema is dropped from the instance where the connection was established.

D.

The command drops the mysql_innodb_cluster_metadata schema and re-creates it.

E.

The mysql_innodb_cluster_metadata schema is dropped from all reachable members of the cluster.

F.

Connections driven by MySQL Router are not affected by the command.

Full Access