[Jan-2024] 100% Actual 1z1-908 dumps Q&As with Explanations Verified & Correct Answers
1z1-908 Dumps with Free 365 Days Update Fast Exam Updates
NEW QUESTION # 59
You have replication configured, which consists of one master and one slave on different hosts with an asynchronous replication channel between them.
Your goal is to decrease the amount of data that is transferred between these two hosts.
It is confirmed that the slave instance does not need to have data from the example database.
Which replication filter contributes to your goal?
- A. on slave: --replicate-wild-ignore=example.%
- B. on master: --replicate-ignore-db=example
- C. on master: --binlog-ignore-db=example
- D. on slave: --binlog-ignore-db=example
- E. on slave: --replicate-ignore-db=example
Answer: B
NEW QUESTION # 60
Examine this SQL statement:
mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)
- A. ADMIN OPTION causes the role to be activated by default.
- B. Mark can grant the privileges assigned to the r_read@localhost role to another user.
- C. Mark can revoke the r_read@localhost role from another role.
- D. Mark can grant the r_read@localhost role to another user.
- E. ADMIN OPTION allows Mark to drop the role.
- F. Mark must connect from localhost to activate the r_read@localhost role.
Answer: B,E
NEW QUESTION # 61
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. ibbackupfiles
- E. ib_logfile*files
Answer: B,E
Explanation:
Explanation/Reference:
Reference: https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/innodb-backup.html
NEW QUESTION # 62
Examine this MySQL client command to connect to a remote database:
mysql -h remote.example.org -u root -p --protocol=TCP --ssl-mode=
Which two --ssl-mode values will ensure that an X.509-compliant certificate will be used to establish the SSL/TLS connection to MySQL?
- A. VERIFY_CA
- B. PREFERRED
- C. REQUIRED
- D. DISABLED
- E. VERIFY_IDENTITY
Answer: A,E
Explanation:
Explanation
https://dev.mysql.com/doc/refman/5.7/en/using-encrypted-connections.html
NEW QUESTION # 63
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. Connection 25 experiences a lock wait timeout.
- C. A deadlock occurs after innodb_lock_wait_timeout seconds.
- D. A deadlock occurs immediately.
- E. All statements execute without error.
Answer: C
NEW QUESTION # 64
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. Use the Clone Plugin to copy the data to another MySQL system.
- B. Take a logical backup of the MySQL system.
- C. Take a physical backup of the MySQL system.
- D. Take your backup from a slave of the MySQL system.
Answer: B
NEW QUESTION # 65
Which two methods allow a DBA to reset a user's password? (Choose two.)
- A. ALTER USER statement
- B. mysqladmin client program
- C. mysql_secure_installation utility
- D. GRANT statement
- E. SET PASSWORD statement
Answer: A,E
NEW QUESTION # 66
Which two statements are true about the binary log encryption feature? (Choose two.)
- A. It requires a keyring plugin.
- B. It can be activated per session.
- C. It can be set at run time.
- D. When enabled it encrypts existing binary logs.
- E. It encrypts any connecting slaves connection thread.
Answer: B,E
NEW QUESTION # 67
Which two statements are true about the mysqld-auto.cnf file? (Choose two.)
- A. This file is for logging purposes only and is never processed.
- B. It is always updated with changes to system variables.
- C. It is read and processed at the end of startup configuration.
- D. It is read and processed at the beginning of startup configuration.
- E. This file is for storing MySQL server_uuid values only.
- F. This file is for storing MySQL Server configuration options in ISON format.
Answer: B,C
NEW QUESTION # 68
You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)
- A. The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.
- B. The mysqlcheck --optimize --all-databases command reclaims free space from table files.
- C. The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.
- D. The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.
- E. The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.
Answer: A,C
NEW QUESTION # 69
A MySQL server is monitored using MySQL Enterprise Monitor's agentless installation.
Which three features are available with this installation method? (Choose three.)
- A. operating system memory utilization
- B. MySQL Query Analysis data
- C. MySQL Replication monitoring
- D. network-related information and network characteristics
- E. disk usage and disk characteristics including disk advisors warnings
- F. security-related advisor warnings
- G. CPU utilization
Answer: B,E,F
NEW QUESTION # 70
Examine this statement and output:
You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)
- A. QN = 5
- B. QN = 1
- C. QN = 4
- D. QN = 2
- E. QN = 3
Answer: B,D
NEW QUESTION # 71
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. shared memory
- C. SOCKET
- D. X Protocol
- E. UDP
- F. TCP/IP
Answer: A,B,F
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/mysql-installer-workflow.html
NEW QUESTION # 72
You wish to store the username and password for a client connection to MySQL server in a file on a local file system.
Which is the best way to encrypt the file?
- A. Use a text editor to create a new defaults file and encrypt it from Linux prompt.
- B. Use mysql_secure_installation to encrypt stored login credentials.
- C. Use mysql_config_editor to create an encrypted file.
- D. Use the AES_ENCRYPT() MySQL function on the option file.
Answer: C
NEW QUESTION # 73
Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)
- A. cluster.addInstance()
- B. dba.configureInstance()
- C. cluster.forceQuorumUsingPartitionOf()
- D. dba.checkInstanceConfiguration()
- E. dba.createCluster()
- F. dba.configureLocalInstance()
- G. cluster.setPrimaryInstance()
Answer: C,G
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-shell-8.0-relnotes-en/news-8-0-16.html
NEW QUESTION # 74
Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?
- A. TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.
- B. MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.
- C. Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQL configuration file.
- D. Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.
Answer: D
NEW QUESTION # 75
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 was not started due to a problem while executing process 2732.
- B. systemd found the mysqld service disabled and failed to start it.
- C. systemd waited for 30 seconds before timing out and start up failed.
- D. systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.
- E. MySQL server continued to start up even though another process existed.
Answer: D
NEW QUESTION # 76
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. It is possible to configure the Query Analysis built-in advisor to get notified about slow query execution.
- E. The single query QRTi pie chart in the Query Analyzer view is based on the average execution of all statements.
Answer: B,D
NEW QUESTION # 77
You recently upgraded your MySQL installation to MySQL 8.0.
Examine this client error:
Which option will allow this client to connect to MySQL Server?
- A. [mysqld]
default_authentication_plugin=mysql_native_password - B. [mysqld]
default_authentication_plugin=caching_sha2_password - C. ALTER USER user -
IDENTIFIED WITH caching_sha2_password
BY 'password'; - D. ALTER USER user -
IDENTIFIED WITH sha256_password -
BY 'password'; - E. [mysqld]
default_authentication_plugin=sha256_password - F. ALTER USER user -
IDENTIFIED WITH mysql_native_password
BY 'password';
Answer: D
NEW QUESTION # 78
You have upgraded the MySQL binaries from 5.7.28 to 8.0.18 by using an in-place upgrade.
Examine the message sequence generated during the first start of MySQL 8.0.18:
Which step or set of steps will resolve the errors?
- A. Execute: mysqlcheck --repair mysql columns_priv event proc proxies_priv tables_priv.
- B. Remove the redo logs. Replace the MySQL binaries with the 5.7.28 binaries. Prepare the tables for upgrade. Upgrade to 8.0.18 again.
- C. Start mysqld again using the --upgrade=FORCE option.
- D. Go to the <datadir>/mysql directory and execute: myisamchk --update-state columns_priv event proc proxies_priv tables_priv.
- E. Execute: mysqlcheck --check-upgrade mysql columns_priv event proc proxies_priv tables_priv.
Answer: C
NEW QUESTION # 79
......
Verified 1z1-908 dumps Q&As - 2024 Latest 1z1-908 Download: https://www.actual4cert.com/1z1-908-real-questions.html
Dumps Questions [2024] Pass for 1z1-908 Exam: https://drive.google.com/open?id=1hT4WVtCy7cUGTV1Ayn40QwBnMyAYuFiO