100% Pass Your 1z1-908 Exam Dumps at First Attempt with DumpsQuestion
Penetration testers simulate 1z1-908 exam PDF
NEW QUESTION 33
Examine these statements, which execute successfully:
TRUNCATE test; BEGIN;
INSERT INTO test(id, name) VALUES(1, "Hello"); ROLLBACK;
SELECT id FROM test;
Which three storage engines would return a nonempty recordset for the test table when executing the statements? (Choose three.)
- A. InnopB
- B. MEMORY
- C. BLACKHOLE
- D. ARCHIVE
- E. MyISAM
- F. NDB
Answer: C,E,F
NEW QUESTION 34
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. TCP/IP
- C. X Protocol
- D. SOCKET
- E. shared memory
- F. UDP
Answer: A,B,E
NEW QUESTION 35
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 PASSWORD DISABLED;
- B. ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;
- C. ALTER USER baduser@hostname DEFAULT ROLE NONE;
- D. ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;
- E. ALTER USER baduser@hostname ACCOUNT LOCK;
Answer: D,E
NEW QUESTION 36
Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)
- A. InnoDB Data Dictionary
- B. change buffer
- C. table data
- D. primary indexes
- E. doublewrite buffer
- F. user privileges
Answer: A,E
NEW QUESTION 37
Examine this command, which executes successfully:
cluster.addInstance('<user>@<host>:<port>', {recoveryMethod: 'clone'})
Which three statements are true? (Choose three.)
- A. InnoDB tablespaces outside the datadir are able to be cloned.
- B. InnoDB redo logs must not rotate for the duration of the execution; otherwise, the recovery will fail.
- C. It is always slower than {recoveryMethod: 'incremental'}.
- D. A target instance must exist, then it will be provisioned with data from an instance already in the cluster and joined to the cluster.
- E. A new instance is installed, initialized, and provisioned with data from an instance already in the cluster and joined to the cluster.
- F. The account used to perform this recovery needs the BACKUP_ADMIN privilege.
Answer: B,C,F
NEW QUESTION 38
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. employee
- C. mysql
- D. world
- E. sys
Answer: A,E
Explanation:
Explanation/Reference: https://mysqlserverteam.com/introducing-mysqlpump/
NEW QUESTION 39
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. TCP/IP
- C. X Protocol
- D. SOCKET
- E. shared memory
- F. UDP
Answer: A,B,E
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/mysql-installer-workflow.html
NEW QUESTION 40
Examine this query:
What information does this query provide?
- A. total memory used across all connections associated with the user on thread number 10
- B. total memory used across all connections associated with the user on connection number 10
- C. total memory used by the first 10 connections
- D. total memory used by the first 10 threads
- E. total memory used by connection number 10
- F. total memory used by thread number 10
Answer: E
NEW QUESTION 41
Examine this query and output:
Which two statements are true? (Choose two.)
- A. The country table is accessed as the first table, and then joined to the city table.
- B. The optimizer estimates that 51 rows in the country table have Continent = 'Asia'.
- C. 35 rows from the city table are included in the result.
- D. It takes more than 8 milliseconds to sort the rows.
- E. The query returns exactly 125 rows.
Answer: B,C
NEW QUESTION 42
Examine this statement and output:
You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)
- A. QN = 4
- B. QN = 1
- C. QN = 3
- D. QN = 5
- E. QN = 2
Answer: B,E
NEW QUESTION 43
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 revoke the r_read@localhost role from another role.
- C. Mark can grant the r_read@localhost role to another user.
- D. ADMIN OPTION causes the role to be activated by default.
- E. ADMIN OPTION allows Mark to drop the role.
- F. Mark can grant the privileges assigned to the r_read@localhost role to another user.
Answer: E,F
NEW QUESTION 44
Examine this command and output:
Which two statements are true? (Choose two.)
- A. The lock is a row-level lock.
- B. The lock is at the metadata object level.
- C. The lock is an exclusive lock.
- D. The lock is an intentional lock.
- E. The lock is at the table object level.
- F. The lock is a shared lock.
Answer: C,E
NEW QUESTION 45
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 has already purged transactions with cccccccc-cccc-cccc- cccc-ccccccccccccGTIDs.
- B. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
- C. Replication will work.
- D. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
- E. Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbbGTIDs in its binary logs.
Answer: D
Explanation:
Explanation/Reference: https://bugs.mysql.com/bug.php?id=86643
NEW QUESTION 46
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: A
NEW QUESTION 47
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 48
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 executes flush tables with read lock.
- B. The backup created is a consistent data dump.
- C. It enforces consistent backups for all storage engines.
- D. This option uses the READ COMMITTED transaction isolation mode.
- E. It is a cold backup.
Answer: A,D
NEW QUESTION 49
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. Re-execute the failed statement in your transaction.
- B. Change the default database and re-execute the failed statement in your transaction.
- C. Roll back the transaction and start the transaction again in the same session.
- D. Close the connection, reconnect, and start the transaction again.
Answer: A
NEW QUESTION 50
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 will shut down to preserve data consistency.
- 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. The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.
- D. A manual intervention to force group members to be only the working two instances is required.
- E. The cluster has built-in high availability and updates group_replication_ip_whitelistto remove the unreachable nodes.
Answer: A,E
NEW QUESTION 51
You execute this command:
shell> mysqlpump --exclude-databases=% --users
Which statement is true?
- A. It creates a logical backup of all MySQL user accounts.
- B. It creates a logical backup of all metadata, but contains no table data.
- C. It returns an error because the mysqldumpcommand should have been used.
- D. It creates a logical backup of only the usersdatabase.
Answer: B
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/mysqlpump.html
NEW QUESTION 52
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 53
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 54
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 55
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' --rewrite-db='mydb2' | mysql
- B. mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql
- C. mysqlbinlog --read-from-remote-server --raw | sed 's/mydb1/mydb2/g' | mysql
- D. mysqlbinlog --rewrite-db='mydb1->mydb2' | mysql
Answer: C
NEW QUESTION 56
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 57
......
All 1z1-908 Dumps and Training Courses: https://www.dumpsquestion.com/1z1-908-exam-dumps-collection.html
Help candidates to study and pass the MySQL 8.0 Database Administrator Exams hassle-free: https://drive.google.com/open?id=1Ht5f5NX2whwn-LcKc2eMDp5jodKMMxkd