100% Free 1Z0-908 Files For passing the exam Quickly UPDATED Jan 08, 2024
1Z0-908 Dumps Questions Study Exam Guide
NEW QUESTION # 85
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 = 3
- C. QN = 4
- D. QN = 2
- E. QN = 1
Answer: D,E
NEW QUESTION # 86
You want to log only the changes made to the database objects and data on the MySQL system.
Which log will do this by default?
- A. error log
- B. binary log
- C. audit log
- D. general query log
- E. slow query log
Answer: B
NEW QUESTION # 87
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. Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.
- C. MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.
- D. Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQL configuration file.
Answer: B
NEW QUESTION # 88
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 PURGE BINARY LOGS to <binlog_name>.
- B. Set binlog_expire_logs_seconds in my.cnf.
- C. Use SET PERSIST binlog_expire_logs_seconds=<value>.
- D. Use SET GLOBAL binlog_expire_logs_seconds=<value> and restart the server.
- E. Set binlog_expire_logs_seconds = 0 in my.cnf and restart the server.
- F. Use SET GLOBAL binlog_expire_logs_seconds=<value> and run the FLUSH BINARY LOGS command.
Answer: C,D
NEW QUESTION # 89
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. employee
- B. information_schema
- C. world
- D. sys
- E. mysql
Answer: B,D
NEW QUESTION # 90
You wish to protect your MySQL database against SQL injection attacks.
Which method would fail to do this?
- A. avoiding concatenation of SQL statements and user-supplied values in an application
- B. installing and configuring the Connection Control plugin
- C. using stored procedures for any database access
- D. using PREPARED STATEMENTS
Answer: C
NEW QUESTION # 91
Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?
- A. /usr
- B. /var/lib/mysql
- C. /usr/bin
- D. /usr/mysql
- E. /etc/my.cnf
Answer: B
NEW QUESTION # 92
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_undo_directory=/dev/shm
- B. innodb_log_file_size=1G
- C. innodb_flush_log_at_trx_commit=1
- D. buffer_pool_size=24G
- E. sync_binlog=0
- F. max_connections=10000
- G. innodb_doublewrite=0
Answer: B,C,F
NEW QUESTION # 93
Which step or set of steps can be used to rotate the error log?
- A. Execute SET GLOBAL max_error_count = <number of messages at point to rotate>.
- B. Rename the error log file on disk, and then execute FLUSH ERROR LOGS.
- C. Execute SET GLOBAL log_error = '<new error log file>'.
- D. Execute SET GLOBAL expire_logs_days=0 to enforce a log rotation.
Answer: B
NEW QUESTION # 94
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 does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbbGTIDs in its binary logs.
- B. Replication will work.
- C. Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-ccccccccccccGTIDs.
- D. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
- E. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
Answer: D
Explanation:
Explanation/Reference: https://bugs.mysql.com/bug.php?id=86643
NEW QUESTION # 95
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 # 96
Which three are characteristics of a newly created role? (Choose three.)
- A. It can be granted to user accounts.
- B. It is stored in the mysql.role table.
- C. It can be dropped using the DROP ROLE statement.
- D. It can be protected with a password.
- E. It is created as a locked account.
- F. It can be renamed using the RENAME ROLE statement.
Answer: A,C,D
NEW QUESTION # 97
Examine these InnoDB Cluster parameter settings:
Now examine the partial status:
A permanent network failure isolates host3.
Which two statements are true? (Choose two.)
- A. The issuing command cluster.switchToMuitiPrimaryMode() will fail to enable multi-primary mode.
- B. The instance deployed on host2 is elected as the new primary instance.
- C. The instance deployed on host3 will automatically rejoin the cluster when connectivity is re-established.
- D. The primary instance can be specified by using the command
cluster.setPrimaryInstance(<host>:<port>). - E. Failure of the instance deployed on host1 provokes an outage.
- F. The instance deployed on host3 is expelled from the cluster and must be rejoined using cluster.addInstance ('host3:3377')
Answer: C,D
NEW QUESTION # 98
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 --check-upgrade mysql columns_priv event proc proxies_priv tables_priv.
- B. Go to the <datadir>/mysql directory and execute: myisamchk --update-state columns_priv event proc proxies_priv tables_priv.
- C. Execute: mysqlcheck --repair mysql columns_priv event proc proxies_priv tables_priv.
- D. 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.
- E. Start mysqld again using the --upgrade=FORCE option.
Answer: E
NEW QUESTION # 99
Examine this list of MySQL data directory binary logs:
binlog.000001 binlog.000002
.....
binlog.000289
binlog.000300
binlog.000301
binlog.index
Now examine this command, which executes successfully:
mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql
Which two are true? (Choose two.)
- A. All databases, excluding master metadata, are backed up to the output file.
- B. All binary logs are backed up and then deleted.
- C. All non-active binary logs are removed from the master.
- D. All databases are backed up to the output file.
- E. All details regarding deleted logs and master metadata are captured in the output file.
- F. All binary logs are deleted from the master.
Answer: A,F
NEW QUESTION # 100
You are using an existing server with a new configuration. MySQL Server fails to start.
Examine this snapshot of the error log:
Which action would allow the server to start?
- A. Execute mysqladmin flush-logs.
- B. Remove ib_logfile0 and ib_logfile1 files from the file system.
- C. Create a new ib_logfile0 file of size 26214400.
- D. First run mysqld --initialize to refresh the Size of ib_logfile.
Answer: D
NEW QUESTION # 101
Your MySQL environment has asynchronous position based-replication with one master and one slave.
The slave instance had a disk I/O problem, so it was stopped.
You determined that the slave relay log files were corrupted and unusable, but no other files are damaged.
You restart MySQL Server.
How can replication be restored?
- A. The relay logs from the master should be used to replace the corrupted relay logs.
- B. The slave needs to be restored from backup.
- C. The slave relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;
- D. The slave relay logs should be deleted; then execute START SLAVE;
Answer: A
NEW QUESTION # 102
You encountered an insufficient privilege error in the middle of a long transaction.
The database administrator is informed and immediately grants the required privilege:
GRANT UPDATE ON world.city TO 'user1';
How can you proceed with your transaction with the least interruption?
- A. Close the connection, reconnect, and start the transaction again.
- B. Roll back the transaction and start the transaction again in the same session.
- C. Re-execute the failed statement in your transaction.
- D. Change the default database and re-execute the failed statement in your transaction.
Answer: C
NEW QUESTION # 103
MySQL is installed on a Linux server with this configuration:
Which method sets the default authentication to SHA-256 hashing for authenticating user account passwords?
- A. Set validate-user-plugins=caching_sha2_password in the configuration file.
- B. Define CREATE USER ''@'%' IDENTIFIED WITH sha256_password in the MySQL instance.
- C. Add default_authentication_plugin=mysql_native_password in the configuration file.
- D. Add default_authentication_plugin=sha256_password in the configuration file.
Answer: D
NEW QUESTION # 104
Examine this query:
What information does this query provide?
- A. total memory used by the first 10 connections
- B. total memory used by connection number 10
- C. total memory used by the first 10 threads
- D. total memory used by thread number 10
- E. total memory used across all connections associated with the user on thread number 10
- F. total memory used across all connections associated with the user on connection number 10
Answer: B
NEW QUESTION # 105
Examine this parameter setting:
audit_log=FORCE_LOG_PERMANENT
What effect does this have on auditing?
- A. It will force the load of the audit plugin even in case of errors at server start.
- B. It prevents the audit log from being removed or rotated.
- C. It causes the audit log to be created if it does not exist.
- D. It prevents the audit plugin from being removed from the running server.
Answer: D
NEW QUESTION # 106
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 PASSWORD DISABLED;
- D. ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;
- E. ALTER USER baduser@hostname DEFAULT ROLE NONE;
Answer: A,B
NEW QUESTION # 107
Which two commands will display indexes on the partstable in the manufacturing schema? (Choose two.) \
- A. EXPLAIN SELECT INDEXES FROM manufacturing.parts;
- B. DESCRIBE manufacturing.parts;
- C. SELECT * FROM information_schema.COLUMN_STATISTICS;
- D. SHOW INDEXES FROM manufacturing.parts;
- E. SELECT * FROM information_schema.statistics WHERE table_schema=’manufacturing’
AND TABLE_NAME=’parts’;
Answer: C,E
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E11882_01/server.112/e40540/indexiot.htm#CNCPT912
NEW QUESTION # 108
Which three statements are true about MySQL replication? (Choose three.)
- A. Replication can use only TCP/IP connections.
- B. Each instance in a replication topology must have a unique server ID.
- C. Binary logs contain only transactions originating from a single MySQL instance.
- D. Each slave must have its own MySQL user for replication.
- E. Binary logging must be enabled on the master in order to replicate to other instances.
- F. Any instance can have multiple slaves, but it can have only one master.
- G. A replication user must have the SELECT privilege for all tables that need to be replicated.
Answer: B,E,G
NEW QUESTION # 109
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 --analyze --all-databases command performs a series of checks to spot eventual table corruptions.
Section: (none)
Explanation - C. The mysqlcheck --optimize --all-databases command reclaims free space from table files.
- D. The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.
- E. The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.
Answer: A,B
NEW QUESTION # 110
......
1Z0-908 Premium Exam Engine - Download Free PDF Questions: https://examcollection.vcetorrent.com/1Z0-908-valid-vce-torrent.html