[Sep 17, 2021] 1Z0-908 Ultimate Study Guide - Exam4Tests
Ultimate Guide to Prepare 1Z0-908 Certification Exam for MySQL Database Administration in 2021
NEW QUESTION 24
Examine this statement and output:
You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)
- A. QN = 4
- B. QN = 1
- C. QN = 3
- D. QN = 5
- E. QN = 2
Answer: B,E
NEW QUESTION 25
Examine this command and output:
Which two statements are true? (Choose two.)
- A. The lock is a row-level lock.
- B. The lock is at the metadata object level.
- C. The lock is an exclusive lock.
- D. The lock is an intentional lock.
- E. The lock is at the table object level.
- F. The lock is a shared lock.
Answer: C,E
NEW QUESTION 26
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 27
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_flush_log_at_trx_commit=1
- B. innodb_undo_directory=/dev/shm
- C. innodb_log_file_size=1G
- D. buffer_pool_size=24G
- E. sync_binlog=0
- F. innodb_doublewrite=0
- G. max_connections=10000
Answer: A,C,G
NEW QUESTION 28
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 --include-databases=% > full-backup-$(date +%Y%m$d).sql
- C. mysqldump --single-transaction > full-backup-$(date +%Y%m%d).sql
- D. mysqlpump --all-databases > full-backup-$(date +%Y%m%d).sql
Answer: A
Explanation:
Explanation/Reference: https://mysqlserverteam.com/introducing-mysqlpump/
NEW QUESTION 29
Examine this command, which executes successfully:
shell> mysqldump --master-data=2 --single-transaction --result-file=dump.sql mydb Which two statements are true? (Choose two.)
- A. It executes flush tables with read lock.
- B. The backup created is a consistent data dump.
- C. It enforces consistent backups for all storage engines.
- D. This option uses the READ COMMITTED transaction isolation mode.
- E. It is a cold backup.
Answer: A,D
NEW QUESTION 30
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. Create the backup by using the --set-gtid-purged=OFF option.
- C. Remove the group replication plugin from each instance before restoring.
- D. Remove the @@GLOBAL.gtid_executed statement from the dump file.
- E. Remove the @@GLOBAL.gtid_purged statement from the dump file.
- F. Restore using the --set-gtid-purged=OFF option.
Answer: B,E
NEW QUESTION 31
What does the binlog dump thread do?
- A. It connects to the master and asks it to send updates recorded in its binary logs.
- B. It monitors and schedules the rotation/deletion of the binary logs.
- C. It reads the relay log and executes the events contained in them.
- D. It acquires a lock on the binary log for reading each event to be sent to the slave.
Answer: A
NEW QUESTION 32
Examine these statements, which execute successfully:
TRUNCATE test; BEGIN;
INSERT INTO test(id, name) VALUES(1, "Hello"); ROLLBACK;
SELECT id FROM test;
Which three storage engines would return a nonempty recordset for the test table when executing the statements? (Choose three.)
- A. InnopB
- B. MEMORY
- C. BLACKHOLE
- D. ARCHIVE
- E. MyISAM
- F. NDB
Answer: C,E,F
NEW QUESTION 33
Your MySQL server is running on the Microsoft Windows platform.
Which three local connection protocols are available to you? (Choose three.)
- A. named pipes
- B. TCP/IP
- C. X Protocol
- D. SOCKET
- E. shared memory
- F. UDP
Answer: A,B,E
NEW QUESTION 34
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 35
You want to check the values of the sort_buffer_sizesession variables of all existing connections.
Which performance_schematable can you query?
- A. user_variables_by_thread
- B. global_variables
- C. variables_by_thread
- D. session_variables
Answer: D
Explanation:
Explanation/Reference: https://dev.mysql.com/worklog/task/?id=6629
NEW QUESTION 36
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. *.ibd files
- B. *.sdi files
- C. *.CSM files
- D. ibbackup files
- E. ib_logfile* files
Answer: A,E
NEW QUESTION 37
You wish to protect your MySQL database against SQL injection attacks.
Which method would fail to do this?
- A. using stored procedures for any database access
- B. installing and configuring the Connection Control plugin
- C. using PREPARED STATEMENTS
- D. avoiding concatenation of SQL statements and user-supplied values in an application
Answer: A
Explanation:
Explanation/Reference: https://www.ptsecurity.com/ww-en/analytics/knowledge-base/how-to-prevent-sql-injection-attacks/
NEW QUESTION 38
Your MySQL server was upgraded from an earlier major version.
The sales database contains three tables, one of which is the transactions table, which has 4 million rows.
You are running low on disk space on the datadir partition and begin to investigate.
Examine these commands and output:
Which two statements are true? (Choose two.)
- A. Executing SET GLOBAL innodb_row_format=COMPRESSED and then ALTER TABLE transactions will free up disk space.
- B. Executing ALTER TABLE transactions will enable you to free up disk space.
- C. The transactions table was created with innodb_file_per_table=OFF.
- D. Truncating the transactions table will free up the most disk space.
- E. Truncating the sales and leads table will free up disk space.
Answer: A,C
NEW QUESTION 39
Your MySQL server is running on the Microsoft Windows platform.
Which three local connection protocols are available to you? (Choose three.)
- A. named pipes
- B. TCP/IP
- C. X Protocol
- D. SOCKET
- E. shared memory
- F. UDP
Answer: A,B,E
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/mysql-installer-workflow.html
NEW QUESTION 40
Examine this statement:
mysql> DROP ROLE r_role1, r_role2;
Which two are true? (Choose two.)
- A. Existing connections can continue to use the roles' privileges until they reconnect.
- B. You must revoke r_role1 and r_role2 from all users and other roles before dropping the roles.
- C. It fails if at least one of the roles does not exist.
- D. It fails if you do not have the ADMIN OPTION of the roles r_role1 and r_role2.
- E. It fails if any of the roles is specified in the mandatory_roles variable.
- F. You must revoke all privileges from r_role1 and r_role2 before dropping the roles.
Answer: A,D
NEW QUESTION 41
Which four are types of information stored in the MySQL data dictionary? (Choose four.)
- A. performance metrics
- B. InnoDB buffer pool LRU management data
- C. stored procedure definitions
- D. table definitions
- E. server runtime configuration
- F. server configuration rollback
- G. view definitions
- H. access control lists
Answer: C,D,F,G
NEW QUESTION 42
Which three are characteristics of a newly created role? (Choose three.)
- A. It is created as a locked account.
- B. It can be renamed using the RENAME ROLE statement.
- C. It can be protected with a password.
- D. It is stored in the mysql.role table.
- E. It can be granted to user accounts.
- F. It can be dropped using the DROP ROLE statement.
Answer: C,E,F
NEW QUESTION 43
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 44
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.)
- A. mysql> IMPORT TABLE FROM /var/tmp/customers.sdi
- B. mysql> IMPORT TABLE FROM /var/lib/mysql/shop/customers.sdi
- C. mysql> SOURCE '/var/tmp/customers.sdi'
- D. shell> cp /backup/customers.frm /var/lib/mysql/shop/
- E. shell> cp /backup/customers.sdi /var/lib/mysql/shop/
- F. shell> cp /backup/customers.sdi /var/tmp
- G. mysql> ALTER TABLE shop.customers DISCARD TABLESPACE
- H. mysql> ALTER TABLE shop.customers IMPORT TABLESPACE
Answer: A,H
NEW QUESTION 45
Which two storage engines provide a view of the data consistent with the storage system at any moment? (Choose two.)
- A. NDB
- B. ARCHIVE
- C. InnoDB
- D. MyISAM
- E. MEMORY
Answer: D,E
NEW QUESTION 46
......
MySQL Database Administration Fundamentals-1Z0-908 Exam-Practice-Dumps: https://www.exam4tests.com/1Z0-908-valid-braindumps.html
Use Real 1Z0-908 Dumps - Oracle Correct Answers: https://drive.google.com/open?id=1SnPAb9gE3h3OIQFcsUoqscA2U7axLqQY