Tested & Approved 1z1-908 Study Materials Download Free Updated 142 Questions
Regular Free Updates 1z1-908 Dumps Real Exam Questions Test Engine
NEW QUESTION # 47
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. Sort the "Exec" column and check for SQL queries with low Query Response Time index (QRTi) values.
- D. Look for queries with low total latency times in the Latency section in the times series graph.
Answer: B
NEW QUESTION # 48
Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)
- A. It decrypts data for use in memory.
- B. It supports only non-blob datatypes.
- C. It enforces encryption from disk to memory and over network transmission.
- D. It supports all indexes transparently.
- E. It does not support the transportable tablespaces feature.
Answer: A,D
NEW QUESTION # 49
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: A
NEW QUESTION # 50
A clean shutdown was performed with innodb_fast_shutdown=0.
While you were manipulating files, all files were accidentally deleted from the top-level data directory.
Which two files must be restored from backup to allow the DB to restart cleanly? (Choose two.)
- A. ib_buffer_pool
- B. ibtmp1
- C. ib_logfile0
- D. ibdata1
- E. undo_001
- F. mysql.ibd
Answer: A,F
NEW QUESTION # 51
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 MySQL user accounts.
- C. It creates a logical backup of all metadata, but contains no table data.
- D. It returns an error because the mysqldump command should have been used.
Answer: C
NEW QUESTION # 52
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 physical backup of the MySQL system.
- D. Take a logical backup of the MySQL system.
Answer: D
NEW QUESTION # 53
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 moves all innodb tablespaces to the /innodb_extrasdirectory to enable a new innodb_data_home_dirto be defined.
- D. It allows scanning of other locations to discover more innodb tablespaces.
- E. It adds more temporary workspace in addition to the innodb_tmpdirlocation.
Answer: A
NEW QUESTION # 54
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. *.ibdfiles
- B. ib_logfile*files
- C. ibbackupfiles
- D. *.CSMfiles
- E. *.sdifiles
Answer: A,B
Explanation:
Explanation/Reference:
Reference: https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/innodb-backup.html
NEW QUESTION # 55
How can mysql_multi be configured to allow MySQL instances to use the same port number?
- A. The instances use different socket names.
- B. The instances use different user accounts unique to each instance.
- C. The instances listen on different IP addresses.
- D. The instances have appropriate net masks set.
Answer: C
NEW QUESTION # 56
Examine this command and output:
Which two statements are true? (Choose two.)
- A. The lock is an exclusive lock.
- B. The lock is a row-level lock.
- C. The lock is at the table object level.
- D. The lock is at the metadata object level.
- E. The lock is an intentional lock.
- F. The lock is a shared lock.
Answer: A,B
NEW QUESTION # 57
Examine these statements and output:
Which statement is true?
- A. The user is authenticated as the anonymous proxy user ''@'%'.
- B. The user is authorized as the rsmith@localhost user.
- 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 logged in with --user=accounting as an option.
Answer: B
NEW QUESTION # 58
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. If only some InnoDB Cluster members are enabled for SSL group communication, and
--ssl-mode=PREFERRED, communication will fall back to unencrypted connection. - B. SSL group communication must be enabled at cluster creation time by specifying createCluster ({memberSslMode: 'REQUIRED'}).
- C. SSL group communication can be enabled for an existing cluster, one instance at time, by setting group_replication_ssl_mode.
- D. SSL group communication requires the use of an additional set of parameters group_replication_recovery_*.
- E. Configuring SSL group communication also configures SSL distributed recovery.
- F. An existing InnoDB Cluster must be dissolved and created from scratch to enable SSL for group communication.
Answer: B,D
NEW QUESTION # 59
Examine this command, which executes successfully on InnoDB Cluster: dba.dropMetadataSchema() Which two statements are true? (Choose two.)
- A. The mysql_innodb_cluster_metadata schema is dropped from all reachable members of the cluster.
- B. The mysql_innodb_cluster_metadata schema is dropped from the instance where the connection was established.
- C. Group Replication is still operational, but InnoDB Cluster must be reimported under MySQL Shell.
- D. The command drops the mysql_innodb_cluster_metadata schema and re-creates it.
- E. Group Replication will be dissolved and all metadata purged.
- F. Connections driven by MySQL Router are not affected by the command.
Answer: B,F
NEW QUESTION # 60
User account baduser@hostname on your MySQL instance has been compromised.
Which two commands stop any new connections using the compromised account? (Choose two.)
- A. ALTER USER baduser@hostname ACCOUNT LOCK;
- B. ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;
- C. ALTER USER baduser@hostname DEFAULT ROLE NONE;
- D. ALTER USER baduser@hostname PASSWORD DISABLED;
- E. ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;
Answer: A,B
NEW QUESTION # 61
You want to check the values of the sort_buffer_size session variables of all existing connections.
Which performance_schema table can you query?
- A. global_variables
- B. variables_by_thread
- C. user_variables_by_thread
- D. session_variables
Answer: D
NEW QUESTION # 62
Which two are features of MySQL Enterprise Firewall? (Choose two.)
- A. provides stateless firewall access to TCP/3306
- B. blocking of potential threats by configuring pre-approved whitelists
- C. recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands
- D. automatic locking of user accounts who break your firewall
- E. modifying SQL statement dynamically with substitutions
Answer: B,E
NEW QUESTION # 63
Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)
- A. table data
- B. doublewrite buffer
- C. change buffer
- D. primary indexes
- E. InnoDB Data Dictionary
- F. user privileges
Answer: B,E
NEW QUESTION # 64
Which three requirements must be enabled for group replication? (Choose three.)
- A. replication filters
- B. slave updates logging
- C. primary key or primary key equivalent on every table
- D. binary log checksum
- E. semi-sync replication plugin
- F. binary log ROW format
- G. binary log MIXED format
Answer: C,E,G
NEW QUESTION # 65
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 retrieve a normalized statement, but never the exact statement that was executed.
- D. The single query QRTi pie chart in the Query Analyzer view is based on the average execution of all statements.
- E. It is possible to configure the Query Analysis built-in advisor to get notified about slow query execution.
Answer: B,E
NEW QUESTION # 66
You have semi-synchronous replication configured and working with one slave.
rpl_semi_sync_master_timeout has never been reached.
You find that the disk system on the master has failed and as a result, the data on the master is completely unrecoverable.
Which two statements are true? (Choose two.)
- A. The slave automatically identifies that the master is unreachable and performs any required actions so that applications can start using the slave as the new master.
- B. Reads from the slave can return outdated data until the value of the rpi_semi_sync_master_timeout variable is reached.
- C. A small amount of committed transactions may be lost in case they were committed just before the disk failure.
- D. As soon as the incident happens, application can read data from the slave and rely on it to return a full and current set of data.
- E. No committed transactions are lost.
- F. Reads from the slave can return outdated data for some time, until it applies all transactions from its relay log.
Answer: A,C
NEW QUESTION # 67
Which two statements are true about MySQL server multi-source replication? (Choose two.)
- A. It must use GTID replication.
- B. It relies on relay_log_recovery for resilient operations.
- C. It needs to be re-instanced after a crash to maintain consistency.
- D. It does not attempt to detect or resolve replication conflicts.
- E. It uses only time-based replication conflict resolution.
- F. It is not compatible with auto-positioning.
Answer: A,E
NEW QUESTION # 68
MySQL programs look for option files in standard locations.
Which method will show the option files and the order in which they are read?
- A. shell> mysql --print-defaults
- B. shell> mysqladmin --debug
- C. shell> mysqld --help --verbose
- D. mysql> SHOW GLOBAL VARIABLES;
Answer: B
NEW QUESTION # 69
......
Pass Oracle 1z1-908 Exam in First Attempt Easily: https://www.dumpsmaterials.com/1z1-908-real-torrent.html
Practice Test Questions Verified Answers As Experienced in the Actual Test!: https://drive.google.com/open?id=1rdXKp1FeArgIZmxaruoMEoSWK5HnNKN7
