6/30/25, 10:12 AM Quiz MySQL Implementation Associate | Wayground
Worksheets Name
Quiz MySQL Implementation Associate
Class
Total questions: 51
Worksheet time: 38mins
Date
Instructor name: Binh Huy
1. Which statement is true about the data directory?
a) It contains the my.cf and temporary files. b) It is configured automatically when you install
MySQL from binary archive.
c) It is a mandatory setting in the my.cnf file. d) It is empty until you create a user database.
2. Which installation method requires that you manually configure the service user?
a) binary archive b) MySQL Installer
c) RPM packages d) yum packages
3. Which statement is true about upgrades?
a) You can upgrade MySQL while the server is offline b) You can upgrade MySQL while the server is running.
by replacing the binaries with new versions.
c) You must reinstall MySQL completely and restore d) The Upgrade Checker utility is only available in
from backup when upgrading from Community Enterprise Edition.
Edition to Enterprise Edition.
4. How often are MySQL Innovation versions released?
a) Every month b) Every year
c) Every quarter d) Every two years
5. Which permissions are required for the MySQL service user?
a) Data directory privileges b) Shell privileges
c) System privileges d) Root privileges
6. For which language does MySQL Shell offer support?
a) GO b) Python
c) PHP d) JAVA
7. Which statement is true about MySQL Workbench Enterprise?
a) It simplifies MySQL database migrations. b) It backs up MySQL instances.
c) It adds security features to the MySQL system. d) It installs MySQL server.
https://wayground.com/print/quiz/677304c2ca0ca4f7fe86fef0 1/9
6/30/25, 10:12 AM Quiz MySQL Implementation Associate | Wayground
8. Which service does MySQL HeatWave offer?
a) Backup to GitHub b) Migration to AWS AuroraA
c) Automatic replication to the Oracle Database d) fully managed MySQL service
9. When is MySQL Enterprise Support available?
a) 8 hours a day, 5 days a week b) 24 hours a day, 7 days a week
c) 8 hours a day, 7 days a week d) 24 hours a day, 5 days a week
10. How many major editions does MySQL offer?
a) 5 b) 2
c) 3 d) 1
11. What does the Oracle commercial licensing option allow businesses to do?
a) Allows businesses to use MySQL in their products b) Allows businesses to use MySQL Enterprise Edition
with other third-party commercial products for free
c) Allows businesses to use MySQL code in their d) Allows businesses to pay a reduced price for MySQL
products and keep their code private Community Edition
12. What is performed by the JOIN clause in SQL?
a) Generates a Venn diagram of table row associations b) Connects rows from two or more tables on some
condition
c) Concatenates two or more column values to a d) Jumps to the next row if a value is null (Jump Only If
single output column Null)
13. Which data type stores string values?
a) DOUBLE b) BIT
c) DECIMAL d) ENUM
14. Which statement is true about PRIMARY indexes?
a) PRIMARY index values are replicated to every b) You can have multiple PRIMARY indexes on a table.
secondary index.
c) They speed up insert operations. d) You can have multiple rows with the same value in
the PRIMARY index.
15. Which is the default MySQL storage engine?
a) InnoDB b) NDB Cluster
c) MyISAM d) Memory
https://wayground.com/print/quiz/677304c2ca0ca4f7fe86fef0 2/9
6/30/25, 10:12 AM Quiz MySQL Implementation Associate | Wayground
16. What can you accomplish using MySQL Partitioning?
a) Specify how big each table can be based on where b) Specify a physical file for each row based on a rule.
it is stored.
c) Specify how big each column can be based on how d) Specify the storage engine for a particular
many partitions are there. database.
17. What is the default MySQL authentication plugin used to encrypt passwords?
a) caching_sha2_password b) mysql_native_password
c) plaintext d) caching_sha256_password
18. Which type of compliance do GDPR, HIPAA, FERPA, and GLBA impose that MySQL can implement?
a) Administrative b) Financial
c) Performance d) Regulatory
19. Which statement about dynamic privileges is true?
a) They are assigned by the server, a plugin, or a b) They are assigned implicitly when a transaction
component at load time. requires them.
c) They are assigned in the mysqld-auto.cf d) They are assigned in the my.cnf configuration file.
configuration file.
20. Which MySQL Enterprise feature supports Kerberos, PAM, and FIDO?
a) Auditing b) Manager
c) Firewall d) Authentication
21. Which product can mitigate the risk of SQL Injection attacks?
a) MySQL Enterprise Audit b) MySQL Enterprise Firewall
c) MySQL Shell d) Oracle Enterprise Manager
22. In which two ways can you install the MySQL Enterprise Masking and De-Identification feature?
a) Stored Procedure b) Component
c) Plugin d) Tablespace
e) Configuration File
23. Against what does MySQL Enterprise Firewall provide real-time protection?
a) Virus b) SQL Injection
c) Brute Force Attack d) Denial of Service (DoS) Attack
https://wayground.com/print/quiz/677304c2ca0ca4f7fe86fef0 3/9
6/30/25, 10:12 AM Quiz MySQL Implementation Associate | Wayground
24. When using MySQL Enterprise Transparent Data Encryption (TDE), which key must be stored outside the
database?
a) Public b) Primary
c) Private d) Master
e) Tablespace
25. Which two formatting options are supported by MySQL Enterprise Audit?
a) XML b) YAML
c) SQL d) Text
e) Json
26. What file can you encrypt using MySQL Enterprise Transparent Data Encryption (TDE)?
a) Tablespace File b) SSL Key File
c) Configuration File (my.cnf or my.ini) d) General Query, Slow Query, and Error Log File
27. What makes a database backup effective?
a) Being able to restore the backup data b) Scheduling the backup
c) Monitoring the backup for consistency d) Not exceeding limitations for the backup resources
28. What must you do to restore from a backup using MySQL Enterprise Backup?
a) Unzip the MySQL Enterprise Backup file. b) Review the SQL script generated script to make
sure it is valid.
c) Shut down the MySQL database system. d) Remove any previous files from the MySQL data
directory.
29. What is the MySQL Enterprise Backup utility designed for?
a) Perform upgrades of MySQL systems b) Create Logical backup of MySQL systems
c) Create Physical backup of MySQL systems d) Create a snapshot of the MySQL storage medium
30. Which statement is true about the mysqldump utility?
a) The mysqldump output is a human-readable text b) mysqldump is fast and does not require locking
file with SQL statements. tables.
c) mysqldump is excellent for backing up large d) mysqldump is a standard way to create physical
databases. backups.
31. How does MySQL Enterprise Backup support optimistic backup?
a) It records all data including data from busy tables. b) It puts the database server in read-only mode.
c) It ignores data from busy tables. d) It locks up tables during the backup process.
https://wayground.com/print/quiz/677304c2ca0ca4f7fe86fef0 4/9
6/30/25, 10:12 AM Quiz MySQL Implementation Associate | Wayground
32. What is one requirement on the source to enable source-replica replication?
a) Source must have binary logging enabled. b) Source must have its binary log format set to
statement based.
c) Source must have all tables use InnoDB storage d) Source must have the sql_require_primary_key
engine only. variable set to on.
33. Which thread is responsible for taking a copy of the binary log events from the source and writing those to a
relay log?
a) SQL thread b) Connection thread
c) I/O thread d) I/O binlog dump thread
34. What uses the Relay Log?
a) Source b) Replica
c) Neither d) Both Source and Replica
35. Which thread maintains an open connection to the source when the replica connects and is used to send the
binary log contents from the source to a replica?
a) I/O thread b) Connection thread
c) I/O binlog dump thread d) SQL thread
36. Which thread reads the relay log and executes the transactions that it contains on the replica?
a) I/O binlog dump thread b) Connection thread
c) I/O thread d) SQL thread
37. Which two are NOT used when setting up MySQL InnoDB ReplicaSet?
a) MySQL Read Replica b) MySQL Group Replication
c) MySQL Workbench d) MySQL Shell
e) MySQL Router
38. Which MySQL component redirects application queries to available nodes in an InnoDB Cluster?
a) MySQL Router b) MySQL Group Replication
c) MySQL Workbench d) MySQL Shell
39. Which MySQL component automates InnoDB Cluster creation and makes managing the Cluster easy?
a) MySQL Router b) MySQL Group Replication
c) MySQL Shell d) MySQL Workbench
https://wayground.com/print/quiz/677304c2ca0ca4f7fe86fef0 5/9
6/30/25, 10:12 AM Quiz MySQL Implementation Associate | Wayground
40. What is the Recovery Point Objective (RPO) or data loss tolerance within a region when using MySQL InnoDB
Cluster?
a) Minutes to hours b) Minutes
c) Zero d) Seconds to minutes
41. Which MySQL component provides automatic failover when using InnoDB Cluster?
a) MySQL Workbench b) MySQL Group Replication
c) MySQL Router d) MySQL Shell
42. What does the MySQL Performance Schema do?
a) It creates indexes for the SQL code. b) It scales the MySQL database for better
performance.
c) It provides statistics about your MySQL instance. d) It compresses the database for better underlying
hardware management.
43. Which MySQL schema has its own dedicated storage engine?
a) sakila Schema b) Performance schema
c) world schema d) mysql schema
44. Which part of the database is the highest source of Database Performance Problems?
a) The SQL, index, and Schema group b) The database structure
c) The underlying hardware d) The overall size of retained data in the active
dataset
45. What can you do with MySQL in Oracle Enterprise Manager?
a) Add extra security to the MySQL database. b) Monitor MySQL Performance.
c) Back up a MySQL database instance. d) Create a MySQL InnoDB ReplicaSet.
46. Slow query log is used to capture long-running SQL statements.
Which is NOT logged by default?
a) Queries that use an index b) SELECT statements
c) Queries that use a join operation d) Administrative statements
47. Which machine learning technique is NOT supported by HeatWave ML?
a) Clustering b) Forecasting
c) Anomaly Detection d) Recommendation Systems
https://wayground.com/print/quiz/677304c2ca0ca4f7fe86fef0 6/9
6/30/25, 10:12 AM Quiz MySQL Implementation Associate | Wayground
48. From which cloud service can you use HeatWave?
a) Google Cloud Platform (GCP) b) Salesforce Cloud
c) Amazon Web Services (AWS) d) IBM Cloud
49. Which HeatWave feature allows you to query data from Object Storage?
a) High Availability b) Autopilot
c) Lakehouse d) Read Replicas
50. Which action can you perform using the HeatWave service web-based console?
a) Install MySQL Shell b) Write SQL code
c) Deploy your instances and manage their backups. d) Connect to MySQL Workbench
51. Which database platform does HeatWave use to store OLTP data?
a) TimesTen In-Memory Database b) MySQL
c) Oracle Database d) Berkley DB
https://wayground.com/print/quiz/677304c2ca0ca4f7fe86fef0 7/9
6/30/25, 10:12 AM Quiz MySQL Implementation Associate | Wayground
Answer Keys
1. c) It is a mandatory setting in 2. a) binary archive 3. a) You can upgrade MySQL
the my.cnf file. while the server is offline by
replacing the binaries with
new versions.
4. c) Every quarter 5. a) Data directory privileges 6. b) Python
7. a) It simplifies MySQL database 8. d) fully managed MySQL service 9. b) 24 hours a day, 7 days a
migrations. week
10. b) 2 11. c) Allows businesses to use 12. b) Connects rows from two or
MySQL code in their more tables on some
products and keep their condition
code private
13. d) ENUM 14. a) PRIMARY index values are 15. a) InnoDB
replicated to every
secondary index.
16. b) Specify a physical file for 17. a) caching_sha2_password 18. d) Regulatory
each row based on a rule.
19. a) They are assigned by the 20. d) Authentication 21. b) MySQL Enterprise Firewall
server, a plugin, or a
component at load time.
22. c) Plugin , b) Component 23. b) SQL Injection 24. d) Master
25. e) Json , a) XML 26. a) Tablespace File 27. a) Being able to restore the
backup data
28. d) Remove any previous files 29. c) Create Physical backup of 30. a) The mysqldump output is a
from the MySQL data MySQL systems human-readable text file
directory. with SQL statements.
31. a) It records all data including 32. a) Source must have binary 33. c) I/O thread
data from busy tables. logging enabled.
34. b) Replica 35. c) I/O binlog dump thread 36. d) SQL thread
37. c) MySQL , MySQL 38. a) MySQL Router 39. c) MySQL Shell
Workbench b) Group
Replication
40. c) Zero 41. b) MySQL Group Replication 42. c) It provides statistics about
your MySQL instance.
43. b) Performance schema 44. a) The SQL, index, and Schema 45. b) Monitor MySQL
group Performance.
46. d) Administrative statements 47. a) Clustering 48. c) Amazon Web Services (AWS)
49. c) Lakehouse 50. c) Deploy your instances and 51. b) MySQL
manage their backups.
https://wayground.com/print/quiz/677304c2ca0ca4f7fe86fef0 8/9
6/30/25, 10:12 AM Quiz MySQL Implementation Associate | Wayground
https://wayground.com/print/quiz/677304c2ca0ca4f7fe86fef0 9/9
