[Sep 28, 2021] 1Z0-908 PDF Dumps is essential on your 1Z0-908 Exam Questions Certain Success!
1Z0-908 PDF Questions - Perfect Prospect To Go With 1Z0-908 Practice Exam
NEW QUESTION 45
Which two statements are true about using backups of the binary log? (Choose two.)
- A. They allow for point-in-time recovery of the data.
- B. Binary logs can always be used to unapply unwanted schema changes.
- C. Multiple binary logs can be used to restore data.
- D. Multiple binary logs can be applied in parallel for faster data restoration.
- E. Binary logs are relatively small, and therefore, excellent for long-term storage and disaster recovery.
Answer: A,B
NEW QUESTION 46
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. mysql> IMPORT TABLE FROM /var/tmp/customers.sdi
- B. mysql> IMPORT TABLE FROM /var/lib/mysql/shop/customers.sdi
- C. mysql> SOURCE '/var/tmp/customers.sdi'
- D. shell> cp /backup/customers.frm /var/lib/mysql/shop/
- E. shell> cp /backup/customers.sdi /var/lib/mysql/shop/
- F. shell> cp /backup/customers.sdi /var/tmp
- G. mysql> ALTER TABLE shop.customers DISCARD TABLESPACE
- H. mysql> ALTER TABLE shop.customers IMPORT TABLESPACE
Answer: A,H
NEW QUESTION 47
Examine this command, which executes successfully:
$ mysqlrouter --bootstrap user@hostname:port --directory=directory_path Which activity is performed?
- A. MySQL Router is restarted.
- B. MySQL Router is configured based on the information in files in directory_path.
- C. MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.
- D. MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.
Answer: C
NEW QUESTION 48
You have an InnoDB Cluster configured with three servers.
Examine this command, which executes successfully:
mysqldump -uroot -p -d mydatabase > mydatabase_backup.sql
Due to data loss, the cluster is initialized and a restore is attempted resulting in this error:
ERROR 13176 (HY000) at line 23: Cannot update GTID_PURGED with the Group Replication plugin running Which two actions, either one of which, can fix this error and allow a successful restore of the cluster? (Choose two.)
- A. Stop all instances except the primary read/write master instance and run the restore.
- B. Create the backup by using the --set-gtid-purged=OFF option.
- C. Remove the group replication plugin from each instance before restoring.
- D. Remove the @@GLOBAL.gtid_executed statement from the dump file.
- E. Remove the @@GLOBAL.gtid_purged statement from the dump file.
- F. Restore using the --set-gtid-purged=OFF option.
Answer: B,E
NEW QUESTION 49
Which command enables rule-based MySQL Auditing capabilities?
- A. shell> mysql < audit_log_filter_linux_install.sql
- B. shell> mysqld --initialize --log-raw=audit.log
- C. mysql> INSTALL COMPONENT audit_log;
- D. mysql> INSTALL PLUGIN audit_log;
Answer: A
NEW QUESTION 50
Which two statements are true about MySQL server multi-source replication? (Choose two.)
- A. It is not compatible with auto-positioning.
- B. It relies on relay_log_recovery for resilient operations.
- C. It does not attempt to detect or resolve replication conflicts.
- D. It must use GTID replication.
- E. It uses only time-based replication conflict resolution.
- F. It needs to be re-instanced after a crash to maintain consistency.
Answer: D,E
NEW QUESTION 51
You plan to take daily full backups, which include the ndbinfoand 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: A
Explanation:
Explanation/Reference: https://mysqlserverteam.com/introducing-mysqlpump/
NEW QUESTION 52
Which three statements are true about MySQL replication? (Choose three.)
- A. Binary logs contain only transactions originating from a single MySQL instance.
- B. A replication user must have the SELECT privilege for all tables that need to be replicated.
- C. Each slave must have its own MySQL user for replication.
- D. Any instance can have multiple slaves, but it can have only one master.
- E. Replication can use only TCP/IP connections.
- F. Binary logging must be enabled on the master in order to replicate to other instances.
- G. Each instance in a replication topology must have a unique server ID.
Answer: B,F,G
NEW QUESTION 53
Examine these statements and output:
Which statement is true?
- A. The user is authorized as the accounting@localhostuser.
- B. The user is authorized as the rsmith@localhostuser.
- C. The user is logged in with --user=accountingas an option.
- D. The user failed to define a username and the connecting username defaulted to ‘’@’%’.
- E. The user is authenticated as the anonymous proxy user ‘’@’%’.
Answer: B
NEW QUESTION 54
Which three settings control global buffers shared by all threads on a MySQL server? (Choose three.)
- A. sort_buffer_size
- B. innodb_buffer_pool_size
- C. key_buffer_size
- D. tmp_table_size
- E. table_open_cache
- F. read_buffer_size
Answer: A,C,D
NEW QUESTION 55
Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)
- A. It supports only non-blob datatypes.
- B. It supports all indexes transparently.
- C. It enforces encryption from disk to memory and over network transmission.
- D. It decrypts data for use in memory.
- E. It does not support the transportable tablespaces feature.
Answer: B,D
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/faqs-tablespace-encryption.html
NEW QUESTION 56
Which two are use cases of MySQL asynchronous replication? (Choose two.)
- A. MySQL Enterprise Backup will automatically back up from an available slave.
- B. It guarantees near real-time replication between a master and a slave.
- C. You can scale writes by creating a replicated mesh.
- D. It allows backup to be done on the slave without impacting the master.
- E. You can scale reads by adding multiple slaves.
Answer: D,E
NEW QUESTION 57
What does the binlog dump thread do?
- A. It connects to the master and asks it to send updates recorded in its binary logs.
- B. It monitors and schedules the rotation/deletion of the binary logs.
- C. It reads the relay log and executes the events contained in them.
- D. It acquires a lock on the binary log for reading each event to be sent to the slave.
Answer: A
NEW QUESTION 58
Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)
- A. dba.checkInstanceConfiguration()
- B. cluster.setPrimaryInstance()
- C. dba.configureInstance()
- D. dba.createCluster()
- E. dba.configureLocalInstance()
- F. cluster.addInstance()
- G. cluster.forceQuorumUsingPartitionOf()
Answer: B,G
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-shell-8.0-relnotes-en/news-8-0-16.html
NEW QUESTION 59
Which two statements are true about using MySQL Enterprise Monitor Query Analyzer? (Choose two.)
- A. The single query QRTi pie chart in the Query Analyzer view is based on the average execution of all statements.
- B. It is possible to retrieve a normalized statement, but never the exact statement that was executed.
- C. It is possible to import data into the Query Analyzer from heterogeneous sources, such as CSV.
- D. It is possible to list and analyze statements in an arbitrary graph range selection from timeseries graphs.
- E. It is possible to configure the Query Analysis built-in advisor to get notified about slow query execution.
Answer: D,E
NEW QUESTION 60
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 public_key.pemfile.
- B. Change the parent directory owner and group to mysql.
- C. Remove world read privileges from the server-cert.pemcertificate file.
- D. Remove group read/write privileges from the private_key.pemfile.
- E. Change the group ownership of the mysqldirectory to the mysqluser group.
- F. Remove the world read/execute privilege from the accountingdirectory.
Answer: B,E
NEW QUESTION 61
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. MySQL binaries could be damaged, deleted, or altered.
- E. Extra startup time would be required for the MySQL server to reset the privileges.
Answer: C,E
NEW QUESTION 62
Which two are features of MySQL Enterprise Firewall? (Choose two.)
- A. automatic locking of user accounts who break your firewall
- B. modifying SQL statement dynamically with substitutions
- C. provides stateless firewall access to TCP/3306
- D. blocking of potential threats by configuring pre-approved whitelists
- E. recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands
Answer: B,D
NEW QUESTION 63
You wish to protect your MySQL database against SQL injection attacks.
Which method would fail to do this?
- A. using stored procedures for any database access
- B. installing and configuring the Connection Control plugin
- C. using PREPARED STATEMENTS
- D. avoiding concatenation of SQL statements and user-supplied values in an application
Answer: A
NEW QUESTION 64
......
1Z0-908 Exam with Accurate MySQL 8.0 Database Administrator PDF Questions: https://www.prepawayexam.com/Oracle/braindumps.1Z0-908.ete.file.html
True Oracle Exam Extraordinary Practice For the 1Z0-908 Exam: https://drive.google.com/open?id=1FQfIcDpQsBdOFGrC2TbI6Lzx_V5Lpkkm