PDF Download Free of 1Z0-908 Valid Practice Test Questions [Q84-Q107] : Latest Exam Prep : http://certify.vceprep.com

This page was exported from Latest Exam Prep [ http://certify.vceprep.com ]
Export date: Sat Sep 21 12:36:35 2024 / +0000 GMT

PDF Download Free of 1Z0-908 Valid Practice Test Questions [Q84-Q107]

PDF Download Free of 1Z0-908 Valid Practice Test Questions

1Z0-908 Test Engine files, 1Z0-908 Dumps PDF

QUESTION 84
Your MySQL server is running on the Microsoft Windows platform.
Which three local connection protocols are available to you? (Choose three.)

named pipes

shared memory

SOCKET

X Protocol

UDP

TCP/IP

QUESTION 85
Examine this query and its output:

Which two statements are true? (Choose two.)

The root user had the largest number of modified rows for a SELECT statement.

User bob had the largest total time waiting for locks.

The root user had the largest single wait time.

The app user had the highest total number of rows read from storage engines.

User bob had a significantly higher ratio of SELECT + INSERT statements to QUIT than both app and root users.

QUESTION 86
Examine Joe’s account:
CREATE USER ‘joe’@’%’ IDENTIFIED BY ‘*secret*’
GRANT ALL PRIVILEGES ON *.* TO ‘joe’@’%’
All existing connections for joe are killed.
Which two commands will stop joe establishing access to the MySQL instance? (Choose two.)

ALTER USER ‘joe’@’%’ ACCOUNT LOCK

ALTER USER ‘joe’@’%’ SET password=’*invalid*’

REVOKE ALL PRIVILEGES ON *.* FROM ‘joe’@’%’

ALTER USER ‘joe’@’%’ PASSWORD HISTORY 0

ALTER USER ‘joe’@’%’ IDENTIFIED BY ‘*invalid*’ PASSWORD EXPIRE

REVOKE USAGE ON *.* FROM ‘joe’@’%’

QUESTION 87
An attempt to recover an InnoDB Cluster fails.
Examine this set of messages and responses:
host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage() Reconfiguring the default cluster from complete outage…
The instance ‘host1:3377” was part of the cluster configuration. Would you like to rejoin it to the cluster?
[y/N]: y
The instance ‘host2:3377’ was part of the cluster configuration. Would you like to rejoin it to the cluster?
[y/N]: y
Dba.rebootClusterFromCompleteOutage: The active session instance isn’t the most updated in comparison with the ONLINE instances of the Cluster’s metadata. Please use the most up to date instance: ‘host1:3377’.
(RuntimeError)
Which statement is true?

The instance deployed on host3 must be rebuilt with a backup from the primary instance.

The cluster is running and there is at least one ONLINE instance.

The instance deployed on host3 must be synchronized from a donor deployed on host1 by using the command cluster.addInstance(‘host1:3377’).

It is possible to determine the most up-to-date instance by comparing different global transaction identifier (GTID) sets with GTID_SUBSET(set1,set2).

The active session instance is invalid and must be re-created by using the command shell.connect (‘host3:3377’).

QUESTION 88
Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)

dba.configureInstance()

cluster.setPrimaryInstance()

dba.configureLocalInstance()

cluster.forceQuorumUsingPartitionOf()

cluster.addInstance()

dba.createCluster()

dba.checkInstanceConfiguration()

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

mysqlbinlog –rewrite-db=’mydb1->mydb2’ | mysql

mysqlbinlog –datebase=mydb1 –database=mydb2 | mysql

mysqlbinlog –rewrite-db=’mydb1’ –rewrite-db=’mydb2’ | mysql

mysqlbinlog –read-from-remote-server –raw | sed ‘s/mydb1/mydb2/g’ | mysql

QUESTION 90
You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)

The mysqlcheck –check –all-databases command takes table write locks while performing a series of checks.

The mysqlcheck –optimize –all-databases command reclaims free space from table files.

The mysqlcheck –repair –all-databases command can repair an InnoDB corrupted table.

The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.

The mysqlcheck –analyze –all-databases command performs a series of checks to spot eventual table corruptions.
Section: (none)
Explanation

QUESTION 91
User account baduser@hostname on your MySQL instance has been compromised.
Which two commands stop any new connections using the compromised account? (Choose two.)

ALTER USER baduser@hostname PASSWORD DISABLED;

ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;

ALTER USER baduser@hostname ACCOUNT LOCK;

ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;

ALTER USER baduser@hostname DEFAULT ROLE NONE;

QUESTION 92
Examine this SQL statement:
mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)

Mark can grant the privileges assigned to the r_read@localhost role to another user.

ADMIN OPTION causes the role to be activated by default.

Mark can grant the r_read@localhost role to another user.

Mark can revoke the r_read@localhost role from another role.

ADMIN OPTION allows Mark to drop the role.

Mark must connect from localhost to activate the r_read@localhost role.

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

They are converted to a highly compressible binary format.

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

They are required to obtain FIPS security compliance.

The resulting files are easily human readable.

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

QUESTION 94
An attempt to recover an InnoDB Cluster fails.
Examine this set of messages and responses:
host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage()
Reconfiguring the default cluster from complete outage…
The instance ‘host1:3377’’ was part of the cluster configuration.
Would you like to rejoin it to the cluster? [y/N]: y
The instance ‘host2:3377’ was part of the cluster configuration.
Would you like to rejoin it to the cluster? [y/N]: y
Dba.rebootClusterFromCompleteOutage: The active session instance isn’t the most updated in comparison with the ONLINE instances of the Cluster’s metadata. Please use the most up to date instance: ‘host1:3377’. (RuntimeError) Which statement is true?

The instance deployed on host3must be rebuilt with a backup from the primary instance.

The cluster is running and there is at least one ONLINEinstance.

The instance deployed on host3must be synchronized from a donor deployed on host1by using the command cluster.addInstance(‘host1:3377’).

It is possible to determine the most up-to-date instance by comparing different global transaction identifier (GTID) sets with GTID_SUBSET(set1,set2).

The active session instance is invalid and must be re-created by using the command shell.connect (‘host3:3377’).

QUESTION 95
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?

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

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

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

The slave needs to be restored from backup.

QUESTION 96
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.)

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

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

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

Remove the group replication plugin from each instance before restoring.

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

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

QUESTION 97
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.)

All databases are backed up to the output file.

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

All binary logs are deleted from the master.

All binary logs are backed up and then deleted.

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

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

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

Replication can use only TCP/IP connections.

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

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

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

Each slave must have its own MySQL user for replication.

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

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

QUESTION 99
Examine this command, which executes successfully on InnoDB Cluster: dba.dropMetadataSchema() Which two statements are true? (Choose two.)

Group Replication will be dissolved and all metadata purged.

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

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

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

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

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

QUESTION 100
You have upgraded the MySQL binaries from 5.7.28 to 8.0.18 by using an in-place upgrade.
Examine the message sequence generated during the first start of MySQL 8.0.18:

Which step or set of steps will resolve the errors?

Remove the redo logs. Replace the MySQL binaries with the 5.7.28 binaries. Prepare the tables for upgrade. Upgrade to 8.0.18 again.

Execute: mysqlcheck –check-upgrade mysql columns_priv event proc proxies_priv tables_priv.

Start mysqld again using the –upgrade=FORCE option.

Execute: mysqlcheck –repair mysql columns_priv event proc proxies_priv tables_priv.

Go to the <datadir>/mysql directory and execute: myisamchk –update-state columns_priv event proc proxies_priv tables_priv.

QUESTION 101
A valid raw backup of the shop.customers MyISAM table was taken.
You must restore the table. You begin with these steps:
1. Confirm that secure_file_priv=’/var/tmp’
2. mysql> DROP TABLE shop.customers;
3. shell> cp /backup/customers.MY* /var/lib/mysql/shop/
Which two actions are required to complete the restore? (Choose two.)

shell> cp /backup/customers.sdi /var/tmp

shell> cp /backup/customers.sdi /var/lib/mysql/shop/

mysql> SOURCE ‘/var/tmp/customers.sdi’

mysql> IMPORT TABLE FROM /var/tmp/customers.sdi

shell> cp /backup/customers.frm /var/lib/mysql/shop/

mysql> IMPORT TABLE FROM /var/lib/mysql/shop/customers.sdi

mysql> ALTER TABLE shop.customers IMPORT TABLESPACE

mysql> ALTER TABLE shop.customers DISCARD TABLESPACE

QUESTION 102
Which command enables rule-based MySQL Auditing capabilities?

shell> mysql < audit_log_filter_linux_install.sql

shell> mysqld –initialize –log-raw=audit.log

mysql> INSTALL PLUGIN audit_log;

mysql> INSTALL COMPONENT audit_log;

QUESTION 103
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?

general query log

audit log

slow query log

binary log

error log

QUESTION 104
Your MySQL installation is running low on space due to binary logs. You need to reduce your log space usage urgently.
Which two sets of actions when completed will accomplish this? (Choose two.)

Use SET GLOBAL binlog_expire_logs_seconds=<value> and restart the server.

Set binlog_expire_logs_seconds in my.cnf.

Set binlog_expire_logs_seconds = 0 in my.cnf and restart the server.

Use SET PERSIST binlog_expire_logs_seconds=<value>.

Use PURGE BINARY LOGS to <binlog_name>.

Use SET GLOBAL binlog_expire_logs_seconds=<value> and run the FLUSH BINARY LOGS command.

QUESTION 105
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?

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

It is not necessary because innodb_data_home_dir is already defined.

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

It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.

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

QUESTION 106
Which three actions are effective in capacity planning? (Choose three.)

buying more RAM

monitoring OS resources for patterns

adding circular replication nodes for increased DML capability

buying more CPU

buying more disk

basing expected growth on an average of the last 3 years

consulting the application team about any future projects and use

upgrading to the latest application version

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

performance metrics

table definitions

access control lists

view definitions

server runtime configuration

server configuration rollback

stored procedure definitions

InnoDB buffer pool LRU management data

Pass Your MySQL Database Administration 1Z0-908 Exam on Jul 20, 2023 with 142 Questions: https://www.vceprep.com/1Z0-908-latest-vce-prep.html

Post date: 2023-07-20 13:59:50
Post date GMT: 2023-07-20 13:59:50
Post modified date: 2023-07-20 13:59:50
Post modified date GMT: 2023-07-20 13:59:50