Pass Your MySQL Database Administration 1z1-908 Exam on Dec 06, 2021 with 86 Questions

1z1-908 Free Exam Study Guide! (Updated 86 Questions)

NEW QUESTION 17
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 details regarding deleted logs and master metadata are captured in the output file.
• D. All binary logs are deleted from the master.
• E. All databases, excluding master metadata, are backed up to the output file.
• F. All binary logs are backed up and then deleted.

Answer: D,E

 

NEW QUESTION 18
Examine these entries from the general query log:

All UPDATE statements reference existing rows.
Which describes the outcome of the sequence of statements?

• A. Connection 25 experiences a lock wait timeout.
• B. A deadlock occurs after innodb_lock_wait_timeout seconds.
• C. Connection 24 experiences a lock wait timeout.
• D. All statements execute without error.
• E. A deadlock occurs immediately.

Answer: B

 

NEW QUESTION 19
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 is not necessary because innodb_data_home_dir is already defined.
• B. It defines all innodb tablespace options relative to a starting parent directory.
• C. It adds more temporary workspace in addition to the innodb_tmpdir location.
• D. It allows scanning of other locations to discover more innodb tablespaces.
• E. It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.

Answer: A

 

NEW QUESTION 20
Which two MySQL Server accounts are locked by default? (Choose two.)

• A. any user created without a password
• B. any internal system accounts
• C. any new ROLE accounts
• D. any user created with a username, but missing the host name
• E. any user set as DEFINER for stored programs

Answer: B,E

 

NEW QUESTION 21
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 is not necessary because innodb_data_home_diris already defined.
• B. It defines all innodb tablespace options relative to a starting parent directory.
• C. It adds more temporary workspace in addition to the innodb_tmpdirlocation.
• D. It allows scanning of other locations to discover more innodb tablespaces.
• E. It moves all innodb tablespaces to the /innodb_extrasdirectory to enable a new innodb_data_home_dirto be defined.

Answer: A

 

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

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

Answer: B,E

Explanation:
Explanation/Reference: https://zetcode.com/mysql/storageengines/

 

NEW QUESTION 23
Examine this statement:
mysql> DROP ROLE r_role1, r_role2;
Which two are true? (Choose two.)

• A. It fails if you do not have the ADMIN OPTION of the roles r_role1 and r_role2.
• B. It fails if any of the roles is specified in the mandatory_roles variable.
• C. It fails if at least one of the roles does not exist.
• D. You must revoke all privileges from r_role1 and r_role2 before dropping the roles.
• E. Existing connections can continue to use the roles' privileges until they reconnect.
• F. You must revoke r_role1 and r_role2 from all users and other roles before dropping the roles.

Answer: A,E

 

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

• A. A separate physical copy must be made before releasing 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. There is no need for InnoDB tables to perform its own recovery when restoring from the snapshot backup.
• E. The frozen file system can be cloned to another virtual machine immediately into active service.

Answer: A,C

 

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

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

Answer: A,C,F

Explanation:
Explanation/Reference:

 

NEW QUESTION 26
Examine this SQL statement:

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

• A. GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT 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 ALL PRIVILEGES ON 'world'.'city' TO 'tom'@'%';
  GRANT SELECT ('code') ON 'world'.'country' TO 'tom'@'%';

Answer: A

 

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

• A. mysqlpump --all-databases > full-backup-$(date +%Y%m%d).sql
• B. mysqldump --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: B

 

NEW QUESTION 28
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?
RESET MASTER;

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

Answer: C

 

NEW QUESTION 29
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 has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.
• B. The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.
• C. The cluster will shut down to preserve data consistency.
• 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.

Answer: A,C

 

NEW QUESTION 30
You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTER command are correct. Examine the GTID information from both master and slave:

Which statement is true?

• A. Replication will work.
• B. Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-cccccccccccc GTIDs.
• C. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
• D. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
• E. Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbb GTIDs in its binary logs.

Answer: C

 

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

Answer: B

 

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

• A. It is possible to import data into the Query Analyzer from heterogeneous sources, such as CSV.
• B. It is possible to list and analyze statements in an arbitrary graph range selection from timeseries graphs.
• C. It is possible to configure the Query Analysis built-in advisor to get notified about slow query execution.
• D. It is possible to retrieve a normalized statement, but never the exact statement that was executed.
• E. The single query QRTi pie chart in the Query Analyzer view is based on the average execution of all statements.

Answer: B,C

 

NEW QUESTION 33
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. mysql
• C. employee
• D. world
• E. sys

Answer: A,E

 

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

• A. mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql
• B. mysqlbinlog --rewrite-db=’mydb1’ --rewrite-db=’mydb2’ | mysql
• C. mysqlbinlog --read-from-remote-server --raw | sed ‘s/mydb1/mydb2/g’ | mysql
• D. mysqlbinlog --rewrite-db=’mydb1->mydb2’ | mysql

Answer: C

 

NEW QUESTION 35
Examine this MySQL Shell command:
dba.rebootClusterFromCompleteOutage()
Which two statements are true? (Choose two.)

• A. It picks the minimum number of instances necessary to rebuild the quorum and reconfigures InnoDB Cluster.
• B. It stops and restarts all InnoDB Cluster instances and initializes the metadata.
• C. It reconfigures InnoDB Cluster if the cluster was stopped.
• D. It only starts all InnoDB Cluster instances.
• E. It is not mandatory that all instances are running and reachable before running the command.
• F. It performs InnoDB Cluster instances rolling restart.
• G. It only stops and restarts all InnoDB Cluster instances.

Answer: E,F

 

NEW QUESTION 36
Which two statements are true about using backups of the binary log? (Choose two.)

• A. Multiple binary logs can be applied in parallel for faster data restoration.
• B. Binary logs can always be used to unapply unwanted schema changes.
• C. They allow for point-in-time recovery of the data.
• D. Binary logs are relatively small, and therefore, excellent for long-term storage and disaster recovery.
• E. Multiple binary logs can be used to restore data.

Answer: B,C

 

NEW QUESTION 37
Examine this command, which executes successfully:
$ mysqlrouter --bootstrap user@hostname:port --directory=directory_path Which activity is performed?

• A. MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.
• B. MySQL Router is configured based on the information in files in directory_path.
• C. MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.
• D. MySQL Router is restarted.

Answer: A

 

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

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

Answer: D,E

 

NEW QUESTION 39
The data in this instance is transient; no backup or replication will be required. It is currently under performing.
* The database size is static and including indexes is 19G.
* Total system memory is 32G.
After profiling the system, you highlight these MySQL status and global variables:

The OS metrics indicate that disk is a bottleneck.
Other variables retain their default values.
Which three changes will provide the most benefit to the instance? (Choose three.)

• A. innodb_log_file_size=1G
• B. innodb_flush_log_at_trx_commit=1
• C. sync_binlog=0
• D. innodb_undo_directory=/dev/shm
• E. max_connections=10000
• F. buffer_pool_size=24G
• G. innodb_doublewrite=0

Answer: A,B,E

Explanation:
Explanation/Reference: https://aws.amazon.com/blogs/database/best-practices-for-configuring-parameters-for-amazon- rds-for-mysql-part-1-parameters-related-to-performance/

 

NEW QUESTION 40
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. *.sdifiles
• B. *.ibdfiles
• C. *.CSMfiles
• D. ib_logfile*files
• E. ibbackupfiles

Answer: B,D

Explanation:
Explanation/Reference:
Reference: https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/innodb-backup.html

 

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

• A. MySQL Enterprise Backup will automatically back up from an available slave.
• B. It guarantees near real-time replication between a master and a slave.
• C. You can scale writes by creating a replicated mesh.
• D. You can scale reads by adding multiple slaves.
• E. It allows backup to be done on the slave without impacting the master.

Answer: D,E

 

NEW QUESTION 42
......

Average Salary for Oracle 1Z0-908: MySQL 8.0 Database Exam Certified Professional

Oracle Database administrator roles are in great demand nowadays. The average salaries of Oracle 1Z0-908 Exam Certified professional in:

• United State - 94,000 USD
• India - 69,96,000 16,42,330 INR
• Europe - 80,000 Euro
• England - 71,000 POUND

How to Study the Oracle 1Z0-908: MySQL 8.0 Database Exam

There are many ways to prepare for the Oracle 1Z0-908 exam. Various strategies can be developed if you are planning to take this exam. Candidates can refer to various PDFs available online and even refer to online videos to prepare for the exam. Various websites are offering practice exams to help you prepare for the exam. Certificate questions provide the most up to date 1Z0-908 exam dumps and we recommend taking the 1Z0-908 practice tests after studying. The candidates must have to take a certification course or training before giving Oracle 1Z0-908 exam, which will also help them prepare for the exam. Candidates can also take the following recommended courses to prepare for the exam:

• Oracle Database 12c: Clusterware Administration and
• Oracle Database 12c: ASM Administration and
• Oracle Database Learning Subscription
• Oracle Database 12c: RAC Administration

 

1z1-908 Dumps for MySQL Database Administration Certified Exam Questions & Answer: https://www.testsimulate.com/1z1-908-study-materials.html