Get Instant Access to 1Z0-908 Practice Exam Questions [Q70-Q94]

Get Instant Access to 1Z0-908 Practice Exam Questions

Reliable Study Materials & Testing Engine for 1Z0-908 Exam Success!

NEW QUESTION # 70
What does the binlog dump thread do?

• A. It monitors and schedules the rotation/deletion of the binary logs.
• B. It reads the relay log and executes the events contained in them.
• C. It connects to the master and asks it to send updates recorded in its binary logs.
• D. It acquires a lock on the binary log for reading each event to be sent to the slave.

Answer: C

NEW QUESTION # 71
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 # 72
Which three are requirements for a secure MySQL Server environment? (Choose three.)

• A. Keep the entire software stack on one OS host.
• B. Run MySQL server as the root user to prevent incorrect sudo settings.
• C. Restrict the number of OS users that have access at the OS level.
• D. Encrypt the file system to avoid needing exact file-system permissions.
• E. Minimize the number of non-MySQL Server-related processes running on the server host.
• F. Ensure appropriate file system privileges for OS users and groups.

Answer: A,D,F

NEW QUESTION # 73
Examine this command, which executes successfull
mysqlbackup --defaults-file=/backups/server-my.cnf --backup-dir=/backups/full copy-back Which statement is true about the copy-back process?

• A. It restores files from the data directory to their original MySQL server locations.
• B. The copy-back process is used to overwrite a new backup over an existing backup.
• C. The copy-back process makes inconsistent backups.
• D. It restores files from the backup directory to their original MySQL server locations.

Answer: B,D

NEW QUESTION # 74
Binary log events for the 'mydb1' schema must be copied to a different schema name 'mydb2'.
Which command will do this?

• A. mysqlbinlog --rewrite-db='mydb1->mydb2' | mysql
• B. mysqlbinlog --read-from-remote-server --raw | sed 's/mydb1/mydb2/g' | mysql
• C. mysqlbinlog --rewrite-db='mydb1' --rewrite-db='mydb2' | mysql
• D. mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql

Answer: B

NEW QUESTION # 75
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.sdi /var/tmp
• B. mysql> IMPORT TABLE FROM /var/tmp/customers.sdi
• C. mysql> ALTER TABLE shop.customers IMPORT TABLESPACE
• D. mysql> ALTER TABLE shop.customers DISCARD TABLESPACE
• E. shell> cp /backup/customers.frm /var/lib/mysql/shop/
• F. mysql> SOURCE '/var/tmp/customers.sdi'
• G. mysql> IMPORT TABLE FROM /var/lib/mysql/shop/customers.sdi
• H. shell> cp /backup/customers.sdi /var/lib/mysql/shop/

Answer: B,C

NEW QUESTION # 76
Which two commands will display indexes on the partstable in the manufacturing schema? (Choose two.) \

• A. EXPLAIN SELECT INDEXES FROM manufacturing.parts;
• B. SHOW INDEXES FROM manufacturing.parts;
• C. DESCRIBE manufacturing.parts;
• D. SELECT * FROM information_schema.COLUMN_STATISTICS;
• E. SELECT * FROM information_schema.statistics WHERE table_schema=’manufacturing’
  AND TABLE_NAME=’parts’;

Answer: D,E

Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E11882_01/server.112/e40540/indexiot.htm#CNCPT912

NEW QUESTION # 77
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. Remove ib_logfile0 and ib_logfile1 files from the file system.
• B. First run mysqld --initialize to refresh the Size of ib_logfile.
• C. Create a new ib_logfile0 file of size 26214400.
• D. Execute mysqladmin flush-logs.

Answer: B

NEW QUESTION # 78
You want to dump all databases with names that start with "db".
Which command will achieve this?

• A. mysqlpump --include-tables=db.% --result-file=all_db_backup.sql
• B. mysqlpump --include-databases=db --result-file=all_db_backup.sql
• C. mysqlpump --include-databases=db% --result-file=all_db_backup.sql
• D. mysqlpump > all_db_backup.sql

Answer: B

NEW QUESTION # 79
Which three are characteristics of a newly created role? (Choose three.)

• A. It can be protected with a password.
• B. It can be dropped using the DROP ROLE statement.
• C. It is stored in the mysql.role table.
• D. It can be renamed using the RENAME ROLE statement.
• E. It can be granted to user accounts.
• F. It is created as a locked account.

Answer: A,B,E

Explanation:
Explanation
https://dev.mysql.com/doc/refman/8.0/en/roles.html
https://www.mysqltutorial.org/mysql-roles/

NEW QUESTION # 80
Examine this command, which executes successfully:
shell> mysqldump --master-data=2 --single-transaction --result-file=dump.sql mydb Which two statements are true? (Choose two.)

• A. It enforces consistent backups for all storage engines.
• B. It is a cold backup.
• C. The backup created is a consistent data dump.
• D. It executes flush tables with read lock.
• E. This option uses the READ COMMITTED transaction isolation mode.

Answer: D,E

NEW QUESTION # 81
Examine this command, which executes successfully:

Which two statements are true? (Choose two.)

• A. A raw backup is created.
• B. The backup operation will finish only when backup-and-apply-log is executed.
• C. A single-file backup is created.
• D. The --backup-dir option holds temporary output, status, and metadata files.
• E. The backup operation will finish only when apply-log is executed.

Answer: D,E

NEW QUESTION # 82
Examine this SQL statement:
mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)

• A. Mark must connect from localhost to activate the r_read@localhost role.
• B. Mark can grant the privileges assigned to the r_read@localhost role to another user.
• C. ADMIN OPTION causes the role to be activated by default.
• D. Mark can grant the r_read@localhost role to another user.
• E. ADMIN OPTION allows Mark to drop the role.
• F. Mark can revoke the r_read@localhost role from another role.

Answer: B,E

NEW QUESTION # 83
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. *.CSM files
• B. *.ibd files
• C. ib_logfile* files
• D. ibbackup files
• E. *.sdi files

Answer: B,C

NEW QUESTION # 84
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 slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
• B. Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-ccccccccccccGTIDs.
• C. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
• D. Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbbGTIDs in its binary logs.
• E. Replication will work.

Answer: A

Explanation:
Explanation/Reference: https://bugs.mysql.com/bug.php?id=86643

NEW QUESTION # 85
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 adds more temporary workspace in addition to the innodb_tmpdirlocation.
• C. It defines all innodb tablespace options relative to a starting parent directory.
• D. It allows scanning of other locations to discover more innodb tablespaces.
• E. It moves all innodb tablespaces to the /innodb_extrasdirectory to enable a new innodb_data_home_dirto be defined.

Answer: A

NEW QUESTION # 86
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. systemd found the mysqld service disabled and failed to start it.
• B. systemd waited for 30 seconds before timing out and start up failed.
• C. MySQL server was not started due to a problem while executing process 2732.
• D. MySQL server continued to start up even though another process existed.
• E. systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.

Answer: E

NEW QUESTION # 87
Which four are types of information stored in the MySQL data dictionary? (Choose four.)

• A. access control lists
• B. server runtime configuration
• C. stored procedure definitions
• D. server configuration rollback
• E. InnoDB buffer pool LRU management data
• F. table definitions
• G. performance metrics
• H. view definitions

Answer: C,D,F,H

NEW QUESTION # 88
Which four connection methods can MySQL clients specify with the --protocol option when connecting to a MySQL server? (Choose four.)

• A. IPv4
• B. SOCKET
• C. FILE
• D. PIPE
• E. MEMORY
• F. TCP
• G. DIRECT
• H. IPv6

Answer: B,D,E,F

NEW QUESTION # 89
Four nodes are configured to use circular replication.
Examine these configuration parameters for each node:

Which statement is true?

• A. Each slave thread is responsible for updating a specific database.
• B. Setting slave_preserve_commit_order to on will improve data consistency.
• C. Cross-database constraints can cause database inconsistency.
• D. Increasing slave_parallel_workers will improve high availability.
• E. Setting slave_parallel_type=DATABASE won't work for circular replication; it should be set to LOGICAL_CLOCK.
• F. Setting transaction_allow_batching to on will improve data consistency.

Answer: B

NEW QUESTION # 90
On examination, your MySQL installation datadir has become recursively world read/write/executable.
What are two major concerns of running an installation with incorrect file privileges? (Choose two.)

• A. Users could overwrite configuration files.
• B. SQL injections could be used to insert bad data into the database.
• C. Data files could be deleted.
• D. Extra startup time would be required for the MySQL server to reset the privileges.
• E. MySQL binaries could be damaged, deleted, or altered.

Answer: C,D

NEW QUESTION # 91
Which statement is true about InnoDB persistent index statistics?

• A. Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.
• B. Updating index statistics is an I/O expensive operation.
• C. Tables are scanned and index statistics recalculated when an instance is restarted.
• D. Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.
• E. Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.
• F. Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.

Answer: A

NEW QUESTION # 92
Which two storage engines provide a view of the data consistent with the storage system at any moment?
(Choose two.)

• A. ARCHIVE
• B. MEMORY
• C. InnoDB
• D. NDB
• E. MyISAM

Answer: B,E

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 adds more temporary workspace in addition to the innodb_tmpdir location.
• B. It is not necessary because innodb_data_home_dir is already defined.
• C. It defines all innodb tablespace options relative to a starting parent directory.
• D. It allows scanning of other locations to discover more innodb tablespaces.
• E. It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.

Answer: B

NEW QUESTION # 94
......

Oracle 1Z0-908 exam is intended for experienced database administrators who have a strong understanding of MySQL and its related technologies. Candidates should have at least two years of experience working with MySQL databases in a production environment, as well as a solid understanding of database architecture and design principles.

 

Validate your Skills with Updated 1Z0-908 Exam Questions & Answers and Test Engine: https://torrentlabs.itexamsimulator.com/1Z0-908-brain-dumps.html