[Feb 16, 2024] 1z1-908 Sample with Accurate & Updated Questions [Q24-Q45]

[Feb 16, 2024] 1z1-908 Sample with Accurate & Updated Questions

1z1-908 Exam Info and Free Practice Test | Pass4Leader

NEW QUESTION # 24
Examine this query and its output:

Which two statements are true? (Choose two.)

• A. The root user had the largest single wait time.
• B. The root user had the largest number of modified rows for a SELECT statement.
• C. The app user had the highest total number of rows read from storage engines.
• D. User bob had the largest total time waiting for locks.
• E. User bob had a significantly higher ratio of SELECT + INSERT statements to QUIT than both app and root users.

Answer: C,E

NEW QUESTION # 25
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 logical backup of the MySQL system.
• B. Use the Clone Plugin to copy the data to another MySQL system.
• C. Take a physical backup of the MySQL system.
• D. Take your backup from a slave of the MySQL system.

Answer: A

NEW QUESTION # 26
You have replication configured, which consists of one master and one slave on different hosts with an asynchronous replication channel between them.
Your goal is to decrease the amount of data that is transferred between these two hosts.
It is confirmed that the slave instance does not need to have data from the example database.
Which replication filter contributes to your goal?

• A. on master: --replicate-ignore-db=example
• B. on slave: --replicate-ignore-db=example
• C. on slave: --binlog-ignore-db=example
• D. on master: --binlog-ignore-db=example
• E. on slave: --replicate-wild-ignore=example.%

Answer: A

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

• A. Mark can revoke the r_read@localhost role from another role.
• B. Mark can grant the privileges assigned to the r_read@localhost role to another user.
• C. Mark can grant the r_read@localhost role to another user.
• D. ADMIN OPTION allows Mark to drop the role.
• E. ADMIN OPTION causes the role to be activated by default.
• F. Mark must connect from localhost to activate the r_read@localhost role.

Answer: B,D

NEW QUESTION # 28
Which two storage engines provide a view of the data consistent with the storage system at any moment? (Choose two.)

• A. MyISAM
• B. NDB
• C. ARCHIVE
• D. MEMORY
• E. InnoDB

Answer: A,D

NEW QUESTION # 29
Your my.cnf file contains these settings:

You want to log queries that looked at a minimum of 5000 records and either took longer than 5 seconds to run or did not use indexes.
Which contains all the settings that you need to add to or modify the slow log configuration?

• A. long_query_time=5
  log_throttle_queries_not_using_indexes=5
• B. min_examined_row_limit=5000
• C. log_throttle_queries_not_using_indexes=5
  min_examined_ row_limit=5000
• D. log_throttle_queries_not_using_indexes=5
• E. long_query_time=5
• F. long_query_time=5
  min_examined_row_limit=5000
• G. long_query_time=5
  log_throttle_queries_not_using_indexes=5
  min_examined_row_limit=5000

Answer: C

NEW QUESTION # 30
Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?

• A. /etc/my.cnf
• B. /usr
• C. /usr/mysql
• D. /usr/bin
• E. /var/lib/mysql

Answer: E

NEW QUESTION # 31
Examine this statement and output:

You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)

• A. QN = 5
• B. QN = 4
• C. QN = 3
• D. QN = 1
• E. QN = 2

Answer: D,E

NEW QUESTION # 32
Which command enables rule-based MySQL Auditing capabilities?

• A. shell> mysql < audit_log_filter_linux_install.sql
• B. mysql> INSTALL PLUGIN audit_log;
• C. shell> mysqld --initialize --log-raw=audit.log
• D. mysql> INSTALL COMPONENT audit_log;

Answer: A

Explanation:
Explanation/Reference: https://dev.mysql.com/doc/mysql-security-excerpt/5.7/en/audit-log-filtering.html

NEW QUESTION # 33
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.)

• A. SSL group communication requires the use of an additional set of parameters group_replication_recovery_*.
• B. An existing InnoDB Cluster must be dissolved and created from scratch to enable SSL for group communication.
• C. Configuring SSL group communication also configures SSL distributed recovery.
• D. SSL group communication must be enabled at cluster creation time by specifying createCluster ({memberSslMode: 'REQUIRED'}).
• 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 can be enabled for an existing cluster, one instance at time, by setting group_replication_ssl_mode.

Answer: A,D

NEW QUESTION # 34
Which three are characteristics of a newly created role? (Choose three.)

• A. It is stored in the mysql.role table.
• B. It can be dropped using the DROP ROLE statement.
• C. It can be granted to user accounts.
• D. It is created as a locked account.
• E. It can be protected with a password.
• F. It can be renamed using the RENAME ROLE statement.

Answer: B,C,E

Explanation:
Explanation
https://dev.mysql.com/doc/refman/8.0/en/roles.html
https://www.mysqltutorial.org/mysql-roles/

NEW QUESTION # 35
You have configured GTID-based asynchronous replication with one master and one slave.
A user accidentally updated some data on the slave.
To fix this, you stopped replication and successfully reverted the accidental changes. Examine the current GTID information:

You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover. Which set of actions would allow the slave to continue replicating without erroneous transactions?

• A. RESET SLAVE;
  SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• B. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb- bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9; SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• C. RESET MASTER;
  SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• D. RESET MASTER;
  SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
  SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• E. RESET SLAVE;
  SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
  SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10300;

Answer: D

NEW QUESTION # 36
Which two methods allow a DBA to reset a user's password? (Choose two.)

• A. GRANT statement
• B. ALTER USER statement
• C. mysql_secure_installation utility
• D. mysqladmin client program
• E. SET PASSWORD statement

Answer: B,E

NEW QUESTION # 37
Which two are true about differences between logical and physical upgrades of MySQL databases? (Choose two.)

• A. Post-upgrade table storage requirements after physical upgrades are usually smaller than that after logical upgrades.
• B. Post-upgrade table storage requirements after logical upgrades are usually smaller than that after physical upgrades.
• C. Physical upgrades are much faster because they do not require restarting the mysqld process.
• D. Physical upgrades are performed for current instances on bare metal deployments, whereas logical upgrades are used for virtual machines or containerized instances.
• E. Logical upgrades are much faster because they do not require restarting the mysqld process.
• F. Physical upgrades leave data in place, whereas logical upgrades require data to be restored from mysqldump-type backups taken before the upgrades.

Answer: E,F

NEW QUESTION # 38
Examine this SQL statement:

Which set of privileges will allow Tom to execute this SQL statement?

• A. GRANT ALL PRIVILEGES ON 'world'.'city' TO 'tom'@'%';
  GRANT SELECT ('code') ON 'world'.'country' TO 'tom'@'%';
• B. GRANT UPDATE ON 'world'.* TO 'tom'@'%';
  GRANT ALL PRIVILEGES ON 'world'.'country' TO 'tom'@'%';
• C. GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.* TO 'tom'@'%';
• D. GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.'country' TO
  'tom'@'%';

Answer: D

NEW QUESTION # 39
You have configured GTID-based asynchronous replication with one master and one slave.
A user accidentally updated some data on the slave.
To fix this, you stopped replication and successfully reverted the accidental changes. Examine the current GTID information:

You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover. Which set of actions would allow the slave to continue replicating without erroneous transactions?

• A. RESET SLAVE;
  SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• B. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb- bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9; SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• C. RESET MASTER;
  SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• D. RESET MASTER;
  SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
  SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• E. RESET SLAVE;
  SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
  SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10300;

Answer: D

NEW QUESTION # 40
You plan to take daily full backups, which include the ndbinfoand sys (internal) databases.
Which command will back up the databases in parallel?

• A. mysqldump --all-databases > full_backup-$(date +%Y%m%d).sql
• B. mysqlpump --all-databases > full-backup-$(date +%Y%m%d).sql
• C. mysqldump --single-transaction > full-backup-$(date +%Y%m%d).sql
• D. mysqlpump --include-databases=% > full-backup-$(date +%Y%m$d).sql

Answer: A

Explanation:
Explanation/Reference: https://mysqlserverteam.com/introducing-mysqlpump/

NEW QUESTION # 41
Examine this command, which executes successfully:

Which two statements are true? (Choose two.)

• A. The --backup-dir option holds temporary output, status, and metadata files.
• B. The backup operation will finish only when apply-log is executed.
• C. A raw backup is created.
• D. The backup operation will finish only when backup-and-apply-log is executed.
• E. A single-file backup is created.

Answer: A,B

NEW QUESTION # 42
Which two are characteristics of snapshot-based backups? (Choose two.)

• A. There is no need for InnoDB tables to perform its own recovery when restoring from the snapshot backup.
• B. Snapshot-based backups greatly reduce time during which the database and applications are unavailable.
• C. Snapshot backups can be used only in virtual machines.
• D. The frozen file system can be cloned to another virtual machine immediately into active service.
• E. A separate physical copy must be made before releasing the snapshot backup.

Answer: C,E

NEW QUESTION # 43
Which three are characteristics of a newly created role? (Choose three.)

• A. It can be dropped using the DROP ROLEstatement.
• B. It can be renamed using the RENAME ROLEstatement.
• C. It can be granted to user accounts.
• D. It is created as a locked account.
• E. It can be protected with a password.
• F. It is stored in the mysql.roletable.

Answer: A,C,E

Explanation:
Explanation/Reference:

NEW QUESTION # 44
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?

• A. The instance deployed on host3 must be rebuilt with a backup from the primary instance.
• B. The active session instance is invalid and must be re-created by using the command shell.connect ('host3:3377').
• C. The cluster is running and there is at least one ONLINE instance.
• D. The instance deployed on host3 must be synchronized from a donor deployed on host1 by using the command cluster.addInstance('host1:3377').
• E. It is possible to determine the most up-to-date instance by comparing different global transaction identifier (GTID) sets with GTID_SUBSET(set1,set2).

Answer: D

NEW QUESTION # 45
......

Pass Oracle 1z1-908 Premium Files Test Engine pdf - Free Dumps Collection: https://www.pass4leader.com/Oracle/1z1-908-exam.html

New 2024 Realistic 1z1-908 Dumps Test Engine Exam Questions in here: https://drive.google.com/open?id=1r2jL2aNVLfgQdaCudZPRMbhhBlnLR8tk