[2021] 1z1-908 All-in-One Exam Guide Practice To your 1z1-908 Exam! [Q11-Q33]

[2021] 1z1-908 All-in-One Exam Guide Practice To your 1z1-908 Exam!

Preparations of 1z1-908 Exam 2021 MySQL Database Administration Unlimited 86 Questions

NEW QUESTION 11
You made some table definition changes to a schema in your MySQL Server.
Which two statements reflect how MySQL Server handles the table definition changes? (Choose two.)

• A. MySQL keeps InnoDB metadata changes in .sdi files in datadir.
• B. MySQL Server stores a copy of the serialized data in the InnoDB user tablespace.
• C. MySQL writes SDI to the binary log for distributed backups.
• D. The metadata is serialized in JSON format in Serialized Dictionary Information (SDI).
• E. MySQL implicitly executes FLUSH TABLES and stores a snapshot backup of the metadata.

Answer: B,D

 

NEW QUESTION 12
Which two commands will display indexes on the parts table in the manufacturing schema? (Choose two.)

• A. SELECT * FROM information_schema.statistics WHERE table_schema='manufacturing' AND TABLE_NAME='parts';
• B. SELECT * FROM information_schema.COLUMN_STATISTICS;
• C. EXPLAIN SELECT INDEXES FROM manufacturing.parts;
• D. DESCRIBE manufacturing.parts;
• E. SHOW INDEXES FROM manufacturing.parts;

Answer: A,B

 

NEW QUESTION 13
Examine this command, which executes successfully:
cluster.addInstance('<user>@<host>:<port>', {recoveryMethod: 'clone'})
Which three statements are true? (Choose three.)

• A. InnoDB tablespaces outside the datadir are able to be cloned.
• B. InnoDB redo logs must not rotate for the duration of the execution; otherwise, the recovery will fail.
• C. It is always slower than {recoveryMethod: 'incremental'}.
• D. A target instance must exist, then it will be provisioned with data from an instance already in the cluster and joined to the cluster.
• E. A new instance is installed, initialized, and provisioned with data from an instance already in the cluster and joined to the cluster.
• F. The account used to perform this recovery needs the BACKUP_ADMIN privilege.

Answer: B,C,F

 

NEW QUESTION 14
Examine these commands and output:

Which connection ID is holding the metadata lock?

• A. 0
• B. 1
• C. 2
• D. 3
• E. 4
• F. 5

Answer: B

 

NEW QUESTION 15
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 24 experiences a lock wait timeout.
• B. A deadlock occurs after innodb_lock_wait_timeout seconds.
• C. A deadlock occurs immediately.
• D. All statements execute without error.
• E. Connection 25 experiences a lock wait timeout.

Answer: B

 

NEW QUESTION 16
An existing asynchronous replication setup is running MySQL 8.
Which two steps are a part of implementing GTID replication? (Choose two.)

• A. Enable GTID by executing this on the master and the slave:
  SET GLOBAL GTID_ENABLED=on;
• B. Execute this on the slave to enable GTID:
  START SLAVE IO_THREAD WITH GTID;
• C. Execute this on the slave to enable GTID:
  RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC;
• D. On the slave, alter the MySQL master connection setting with:
  ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1;
• E. Restart MySQL (master and slave) with these options enabled:
  --gtid_mode=ON
  --log-bin
  --log-slave-updates
  --enforce-gtid-consistency
• F. On the slave, alter the MySQL master connection setting with:
  CHANGE MASTER TO MASTER_AUTO_POSITION = 1;

Answer: E,F

 

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

Which statement is true?

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

Answer: D

Explanation:
Explanation/Reference: https://bugs.mysql.com/bug.php?id=86643

 

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

• A. Use SET GLOBAL binlog_expire_logs_seconds=<value> and run the FLUSH BINARY LOGS command.
• B. Use SET GLOBAL binlog_expire_logs_seconds=<value> and restart the server.
• C. Set binlog_expire_logs_seconds in my.cnf.
• D. Set binlog_expire_logs_seconds = 0 in my.cnf and restart the server.
• E. Use PURGE BINARY LOGS to <binlog_name>.
• F. Use SET PERSIST binlog_expire_logs_seconds=<value>.

Answer: B,F

 

NEW QUESTION 19
Which two are features of MySQL Enterprise Firewall? (Choose two.)

• A. automatic locking of user accounts who break your firewall
• B. modifying SQL statement dynamically with substitutions
• C. provides stateless firewall access to TCP/3306
• D. blocking of potential threats by configuring pre-approved whitelists
• E. recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands

Answer: B,D

 

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

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

Answer: A

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

 

NEW QUESTION 21
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 your backup from a slave 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 a physical backup of the MySQL system.

Answer: C

 

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

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

Answer: D

 

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

Answer: A,E

 

NEW QUESTION 24
Examine this command and output:

Which two options will improve the security of the MySQL instance? (Choose two.)

• A. Remove world read privileges from the public_key.pemfile.
• B. Change the parent directory owner and group to mysql.
• C. Remove world read privileges from the server-cert.pemcertificate file.
• D. Remove group read/write privileges from the private_key.pemfile.
• E. Change the group ownership of the mysqldirectory to the mysqluser group.
• F. Remove the world read/execute privilege from the accountingdirectory.

Answer: B,E

 

NEW QUESTION 25
Which three settings control global buffers shared by all threads on a MySQL server? (Choose three.)

• A. sort_buffer_size
• B. innodb_buffer_pool_size
• C. key_buffer_size
• D. tmp_table_size
• E. table_open_cache
• F. read_buffer_size

Answer: A,C,D

 

NEW QUESTION 26
Examine this query and output:

Which two statements are true? (Choose two.)

• A. The country table is accessed as the first table, and then joined to the city table.
• B. The optimizer estimates that 51 rows in the country table have Continent = 'Asia'.
• C. 35 rows from the city table are included in the result.
• D. It takes more than 8 milliseconds to sort the rows.
• E. The query returns exactly 125 rows.

Answer: B,C

 

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

Answer: D

 

NEW QUESTION 28
You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation.
Examine the output:

What statement is true about the start attempt?

• A. MySQL server continued to start up even though another process existed.
• B. MySQL server was not started due to a problem while executing process 2732.
• C. systemd found the mysqld service disabled and failed to start it.
• D. systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.
• E. systemd waited for 30 seconds before timing out and start up failed.

Answer: D

 

NEW QUESTION 29
Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?

• A. Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQL configuration file.
• B. TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.
• C. Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.
• D. MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.

Answer: C

 

NEW QUESTION 30
Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)

• A. InnoDB Data Dictionary
• B. change buffer
• C. table data
• D. primary indexes
• E. doublewrite buffer
• F. user privileges

Answer: A,E

 

NEW QUESTION 31
Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)

• A. It supports only non-blob datatypes.
• B. It supports all indexes transparently.
• C. It enforces encryption from disk to memory and over network transmission.
• D. It decrypts data for use in memory.
• E. It does not support the transportable tablespaces feature.

Answer: B,D

 

NEW QUESTION 32
Examine these statements and output:

Which statement is true?

• A. The user is authorized as the rsmith@localhost user.
• B. The user is logged in with --user=accounting as an option.
• C. The user is authorized as the accounting@localhost user.
• D. The user failed to define a username and the connecting username defaulted to ''@'%'.
• E. The user is authenticated as the anonymous proxy user ''@'%'.

Answer: A

 

NEW QUESTION 33
......

Focus on 1z1-908 All-in-One Exam Guide For Quick Preparation: https://www.exam4free.com/1z1-908-valid-dumps.html

Practice To 1z1-908 - Exam4Free Remarkable Practice On your MySQL 8.0 Database Administrator Exam: https://drive.google.com/open?id=14z3HY5T3s6PGfFfyuVZC6CsS2NA8xCW3