Free Sales Ending Soon - Use Real 1Z0-908 PDF Questions [Dec 29, 2023]
Updated Dec-2023 Exam 1Z0-908 Dumps - Pass Your Certification Exam
Oracle 1z1-908: MySQL 8.0 Database Administrator exam is a valuable certification for database administrators who want to demonstrate their expertise in MySQL database administration. 1Z0-908 exam covers a broad range of topics and requires a good understanding of MySQL 8.0 features and functionalities. Passing 1Z0-908 exam will enhance your career prospects and validate your skills as a MySQL database administrator.
NEW QUESTION # 15
Which two are true about binary logs used in asynchronous replication? (Choose two.)
- A. They are pushed from the master to the slave.
- B. They contain events that describe all queries run on the master.
- C. They contain events that describe only administrative commands run on the master.
- D. They contain events that describe database changes on the master.
- E. They are pulled from the master to the slave.
Answer: A,D
Explanation:
Explanation/Reference: https://www.oracle.com/technetwork/community/developer-day/mysql-replication-presentation-
485890.pdf (14)
NEW QUESTION # 16
Examine this command, which executes successfully:
$ mysqlrouter --bootstrap user@hostname:port --directory=directory_path Which activity is performed?
- A. MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.
- B. MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.
- C. MySQL Router is configured based on the information in files in directory_path.
- D. MySQL Router is restarted.
Answer: A
NEW QUESTION # 17
You plan to take daily full backups, which include the ndbinfo and 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: B
Explanation:
Explanation
https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html By default --all-databases won't backup ndbinfo schema this can be done via
--include-database=%https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html#mysqlpump-restrictions
NEW QUESTION # 18
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> mysqld --help --verbose
- B. shell> mysqladmin --debug
- C. mysql> SHOW GLOBAL VARIABLES;
- D. shell> mysql --print-defaults
Answer: B
NEW QUESTION # 19
There are five MySQL instances configured with a working group replication.
Examine the output of the group members:
Which two statements are true about network partitioning in the cluster? (Choose two.)
- A. The cluster has built-in high availability and updates group_replication_ip_whitelistto remove the unreachable nodes.
- B. There could be both a 2 node and 3 node group replication still running, so shutting down group replication and diagnosing the issue is recommended.
- C. A manual intervention to force group members to be only the working two instances is required.
- D. The cluster will shut down to preserve data consistency.
- E. The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.
Answer: A,D
NEW QUESTION # 20
Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)
- A. cluster.addInstance()
- B. dba.configureInstance()
- C. dba.checkInstanceConfiguration()
- D. cluster.forceQuorumUsingPartitionOf()
- E. dba.createCluster()
- F. cluster.setPrimaryInstance()
- G. dba.configureLocalInstance()
Answer: D,F
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-shell-8.0-relnotes-en/news-8-0-16.html
NEW QUESTION # 21
Which command enables rule-based MySQL Auditing capabilities?
- A. mysql> INSTALL COMPONENT audit_log;
- B. shell> mysql < audit_log_filter_linux_install.sql
- C. mysql> INSTALL PLUGIN audit_log;
- D. shell> mysqld --initialize --log-raw=audit.log
Answer: B
Explanation:
Explanation/Reference: https://dev.mysql.com/doc/mysql-security-excerpt/5.7/en/audit-log-filtering.html
NEW QUESTION # 22
Examine this command, which executes successfully:
cluster.addInstance('<user>@<host>:<port>', {recoveryMethod: 'clone'})
Which three statements are true? (Choose three.)
- A. The account used to perform this recovery needs the BACKUP_ADMIN privilege.
- B. A new instance is installed, initialized, and provisioned with data from an instance already in the cluster and joined to the cluster.
- C. It is always slower than {recoveryMethod: 'incremental'}.
- D. InnoDB tablespaces outside the datadir are able to be cloned.
- E. InnoDB redo logs must not rotate for the duration of the execution; otherwise, the recovery will fail.
- F. A target instance must exist, then it will be provisioned with data from an instance already in the cluster and joined to the cluster.
Answer: A,C,E
NEW QUESTION # 23
Examine this command and output:
Which two options will improve the security of the MySQL instance? (Choose two.)
- A. Remove world read privileges from the server-cert.pem certificate file.
- B. Remove group read/write privileges from the private_key.pem file.
- C. Change the parent directory owner and group to mysql.
- D. Remove the world read/execute privilege from the accounting directory.
- E. Remove world read privileges from the public_key.pem file.
- F. Change the group ownership of the mysql directory to the mysql user group.
Answer: C,F
NEW QUESTION # 24
Examine this statement, which executes successfully:
Now examine this query:
Which two statements can do this? (Choose two.)
- A. ALTER TABLE employees -
ADD INDEX ((MONTH(birth_date))); - B. ALTER TABLE employees -
ADD INDEX ((CAST(birth_date->>'$.month' AS unsigned))); - C. ALTER TABLE employees -
ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (MONTH(birth_date)) VIRTUAL NOT NULL, ADD INDEX (birth_month); - D. ALTER TABLE employees -
ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (birth_date->>'$.month') VIRTUAL NOT NULL, ADD INDEX (birth_month); - E. ALTER TABLE employees -
ADD INDEX (birth_date DESC); - F. ALTER TABLE employees -
ADD INDEX (birth_date);
Answer: D,E
NEW QUESTION # 25
Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)
- A. change buffer
- B. InnoDB Data Dictionary
- C. doublewrite buffer
- D. primary indexes
- E. table data
- F. user privileges
Answer: B,C
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/innodb-system-tablespace.html
NEW QUESTION # 26
Examine this query and output:
Which two statements are true? (Choose two.)
- A. It takes more than 8 milliseconds to sort the rows.
- B. The optimizer estimates that 51 rows in the countrytable have Continent = ‘Asia’.
- C. 35 rows from the city table are included in the result.
- D. The query returns exactly 125 rows.
- E. The countrytable is accessed as the first table, and then joined to the city table.
Answer: B,C
NEW QUESTION # 27
Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)
- A. It enforces encryption from disk to memory and over network transmission.
- B. It supports only non-blob datatypes.
- C. It decrypts data for use in memory.
- D. It supports all indexes transparently.
- E. It does not support the transportable tablespaces feature.
Answer: C,D
NEW QUESTION # 28
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. information_schema
- B. sys
- C. mysql
- D. world
- E. employee
Answer: A,B
NEW QUESTION # 29
You are considering using file-system snapshots to back up MySQL.
Which three statements are true? (Choose three.)
- A. They take roughly twice as long as logical backups.
- B. There is a slight performance cost while the snapshot is active.
- C. They work best for transaction storage engines that can perform their own recovery when restored.
- D. The backup window is almost zero from the perspective of the application.
- E. They do not back up views, stored procedures, or configuration files.
- F. They allow direct copying of table rows with operating system copy commands.
- G. They do not use additional disk space.
Answer: C,E,G
NEW QUESTION # 30
Which two statements are true about the mysqld-auto.cnf file? (Choose two.)
- A. It is always updated with changes to system variables.
- B. It is read and processed at the end of startup configuration.
- C. It is read and processed at the beginning of startup configuration.
- D. This file is for logging purposes only and is never processed.
- E. This file is for storing MySQL Server configuration options in ISON format.
- F. This file is for storing MySQL server_uuid values only.
Answer: A,B
NEW QUESTION # 31
You must configure the MySQL command-line client to provide the highest level of trust and security when connecting to a remote MySQL Server.
Which value of --ssl-mode will do this?
- A. VERIFY_IDENTITY
- B. VERIFY_CA
- C. PREFERRED
- D. REQUIRED
Answer: D
NEW QUESTION # 32
t is a non-empty InnoDB table.
Examine these statements, which are executed in one session:
BEGIN;
SELECT * FROM t FOR UPDATE;
Which is true?
- A. mysqlcheck --analyze --all-databases will execute normally on all tables and return a report.
- B. If ANALYZE TABLE; is invoked from the same session, it hangs until the transaction is committed or rolled back.
- C. If OPTIMIZE LOCAL TABLE t; is invoked from another session, it executes normally and returns the status.
- D. If OPTIMIZE TABLE; is invoked, it will create a table lock on t and force a transaction rollback.
Answer: C
NEW QUESTION # 33
......
1Z0-908 Dumps To Pass MySQL Database Administration Exam in One Day: https://pass4sure.dumpstorrent.com/1Z0-908-exam-prep.html