Prepare 1Z0-908 Exam Questions [2024] Recently Updated Questions
Give push to your success with 1Z0-908 exam questions
NEW QUESTION # 80
You execute this command:
shell> mysqlpump --exclude-databases=% --users
Which statement is true?
- A. It creates a logical backup of only the users database.
- B. It creates a logical backup of all metadata, but contains no table data.
- C. It returns an error because the mysqldump command should have been used.
- D. It creates a logical backup of all MySQL user accounts.
Answer: D
Explanation:
Explanation
the command mysqlpump --exclude-databases=% --users creates a logical backup of all MySQL user accounts as CREATE USER and GRANT statements2. The option --exclude-databases=% excludes all databases from the backup, while the option --users includes all user accounts1.
NEW QUESTION # 81
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. bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
RESET SLAVE; - C. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
- D. SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
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: D
NEW QUESTION # 82
Which two MySQL Server accounts are locked by default? (Choose two.)
- A. any user set as DEFINER for stored programs
- B. any user created with a username, but missing the host name
- C. any internal system accounts
- D. any user created without a password
- E. any new ROLE accounts
Answer: A,C
NEW QUESTION # 83
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 implicitly executes FLUSH TABLES and stores a snapshot backup of the metadata.
- B. MySQL writes SDI to the binary log for distributed backups.
- C. MySQL Server stores a copy of the serialized data in the InnoDB user tablespace.
- D. The metadata is serialized in JSON format in Serialized Dictionary Information (SDI).
- E. MySQL keeps InnoDB metadata changes in .sdi files in datadir.
Answer: C,D
NEW QUESTION # 84
An existing asynchronous replication setup is running MySQL 8.
Which two steps are a part of implementing GTID replication? (Choose two.)
- A. Restart MySQL (master and slave) with these options enabled:
--gtid_mode=ON
--log-bin
--log-slave-updates
--enforce-gtid-consistency - B. On the slave, alter the MySQL master connection setting with:
CHANGE MASTER TO MASTER_AUTO_POSITION = 1; - C. Execute this on the slave to enable GTID:
RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC; - D. Execute this on the slave to enable GTID:
START SLAVE IO_THREAD WITH GTID; - E. Enable GTID by executing this on the master and the slave:
SET GLOBAL GTID_ENABLED=on; - F. On the slave, alter the MySQL master connection setting with:
ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1;
Answer: A,B
NEW QUESTION # 85
What is the correct syntax for using transparent data encryption with an existing InnoDB table?
- A. ALTER TABLE t1 ADD ENCRYPTED_TABLESPACE = 'Y';
- B. ALTER TABLE t1 ENCRYPTION='Y';
- C. ALTER TABLE t1 SET TDE = 'ON';
- D. ALTER TABLE t1 WITH ENCRYPTION USING MASTER KEY;
Answer: A
NEW QUESTION # 86
You have configured MySQL Enterprise Monitor to monitor your MySQL server.
Which four features are available? (Choose four.)
- A. deploying the MySQL agent on supported target operating system
- B. monitoring of NDB Cluster API nodes
- C. tracing import and export with mysqidump
- D. analyzing executed MySQL queries
- E. starting and stopping the MySQL instance
- F. monitoring the availability of the MySQL instance
- G. creating e-mail alerts and SNMP traps for MySQL warnings
Answer: C,D,F,G
NEW QUESTION # 87
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. Connection 24 experiences a lock wait timeout.
- C. A deadlock occurs immediately.
- D. All statements execute without error.
- E. A deadlock occurs after innodb_lock_wait_timeout seconds.
Answer: E
NEW QUESTION # 88
Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?
- A. /var/lib/mysql
- B. /usr/mysql
- C. /usr
- D. /usr/bin
- E. /etc/my.cnf
Answer: A
NEW QUESTION # 89
Which three requirements must be enabled for group replication? (Choose three.)
- A. binary log checksum
- B. primary key or primary key equivalent on every table
- C. semi-sync replication plugin
- D. binary log ROW format
- E. binary log MIXED format
- F. replication filters
- G. slave updates logging
Answer: B,C,E
NEW QUESTION # 90
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. shell> cp /backup/customers.frm /var/lib/mysql/shop/
- B. shell> cp /backup/customers.sdi /var/lib/mysql/shop/
- C. mysql> ALTER TABLE shop.customers IMPORT TABLESPACE
- D. mysql> ALTER TABLE shop.customers DISCARD TABLESPACE
- E. mysql> SOURCE '/var/tmp/customers.sdi'
- F. mysql> IMPORT TABLE FROM /var/lib/mysql/shop/customers.sdi
- G. shell> cp /backup/customers.sdi /var/tmp
- H. mysql> IMPORT TABLE FROM /var/tmp/customers.sdi
Answer: C,H
NEW QUESTION # 91
A MySQL server is monitored using MySQL Enterprise Monitor's agentless installation.
Which three features are available with this installation method? (Choose three.)
- A. disk usage and disk characteristics including disk advisors warnings
- B. MySQL Query Analysis data
- C. CPU utilization
- D. operating system memory utilization
- E. security-related advisor warnings
- F. network-related information and network characteristics
- G. MySQL Replication monitoring
Answer: A,B,E
NEW QUESTION # 92
You want to check the values of the sort_buffer_sizesession variables of all existing connections.
Which performance_schematable can you query?
- A. variables_by_thread
- B. session_variables
- C. global_variables
- D. user_variables_by_thread
Answer: B
Explanation:
Explanation/Reference: https://dev.mysql.com/worklog/task/?id=6629
NEW QUESTION # 93
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 allows scanning of other locations to discover more innodb tablespaces.
- B. It is not necessary because innodb_data_home_diris already defined.
- C. It defines all innodb tablespace options relative to a starting parent directory.
- D. It adds more temporary workspace in addition to the innodb_tmpdirlocation.
- E. It moves all innodb tablespaces to the /innodb_extrasdirectory to enable a new innodb_data_home_dirto be defined.
Answer: B
NEW QUESTION # 94
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. Truncating the transactions table will free up the most disk space.
- B. Executing SET GLOBAL innodb_row_format=COMPRESSED and then ALTER TABLE transactions will free up disk space.
- C. The transactions table was created with innodb_file_per_table=OFF.
- D. Truncating the sales and leads table will free up disk space.
- E. Executing ALTER TABLE transactions will enable you to free up disk space.
Answer: B,C
NEW QUESTION # 95
You are having performance issues with MySQL instances. Those servers are monitored with MySQL Enterprise Monitor.
Using Query Analyzer, where do you begin to look for problem queries?
- A. Sort the "Exec" column and check for SQL queries with high Query Response Time index (QRTi) values.
- B. Look for queries with big prolonged spikes in row activity/access graph in the times series graph.
- C. Look for queries with low total latency times in the Latency section in the times series graph.
- D. Sort the "Exec" column and check for SQL queries with low Query Response Time index (QRTi) values.
Answer: B
NEW QUESTION # 96
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. sync_binlog=0
- B. innodb_flush_log_at_trx_commit=1
- C. innodb_doublewrite=0
- D. innodb_log_file_size=1G
- E. innodb_undo_directory=/dev/shm
- F. max_connections=10000
- G. buffer_pool_size=24G
Answer: B,D,F
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 # 97
Which command enables rule-based MySQL Auditing capabilities?
- A. mysql> INSTALL COMPONENT audit_log;
- B. shell> mysql < audit_log_filter_linux_install.sql
- C. shell> mysqld --initialize --log-raw=audit.log
- D. mysql> INSTALL PLUGIN audit_log;
Answer: B
Explanation:
Explanation/Reference: https://dev.mysql.com/doc/mysql-security-excerpt/5.7/en/audit-log-filtering.html
NEW QUESTION # 98
......
Get 1Z0-908 Actual Free Exam Q&As to Prepare Certification: https://www.prep4away.com/Oracle-certification/braindumps.1Z0-908.ete.file.html
1Z0-908 100% Guarantee Download 1Z0-908 Exam PDF Q&A: https://drive.google.com/open?id=17lacJIItdqtN15Pik1Gz8uWLSw2UBMEo