915

1.A query is not offloaded to the HeatWave cluster for execution. Which three are possible reasons?. The query estimated cost is less than the query cost threshold. The use_secondary_engine session variable is OFF. The client is connected to the DB system instead of the HeatWave cluster. The user does not have privileges to access the HeatWave cluster. A required column is excluded from the RAPID secondary engine.

2.How do you determine whether the query is offloaded to the HeatWave cluster for execution?. Query the rpd_tables table in performance_schema. Check the value of the hw_data_scanned global status variable. Check the value of the rapid_query_offload_count global status variable. View the Query Execution Plan of the query by running EXPLAIN.

3.The second query is NOT offloaded to HeatWave. Which two methods can offload the second query?. SET use_secondary_engine=FORCED;. SET optimizer_trace="enabled=on";. SET query_cost_threshold=1000;. CALL sys.load("airport_geo");. CALL sys.heavy_advisor(JSON_OBJECT("auto_en", JSON_OBJECT("mode", "recommend")));.

4.Which two are benefits of read replicas?. Reduce down time. Scale read queries. Speed up analytical queries. Reduce query latency. Reduce network latency.

5.What must you do before deleting a DB system?. Take a manual backup. Stop and remove any connected HeatWave Cluster. Stop the instance if it is running. Disable delete protection if it is enabled.

6.A DB system has been deleted successfully. Which two operations are allowed on the deleted DB system?. Create a manual backup. Restore the DB system from an existing manual backup. View the metrics. View the API call logs on the Audit page. Change the storage size.

7.What happens when you perform a switchover of a high-availability DB system with an attached HeatWave cluster?. The HeatWave cluster remains attached to the same DB system and the new primary instance redirects queries to that cluster. The HeatWave cluster is no longer valid; you must re-create the HeatWave cluster. The HeatWave cluster is deleted and a new HeatWave cluster is attached to the new primary instance. The HeatWave cluster is attached to the new primary instance.

8.Which two methods can be used to stop a DB system?. Execute the mysql db-system stop command from OCI CLI. Use the STOP action on the DB system details page in the OCI Console. Run the SHUTDOWN SQL statement from any connected client logged in as the admin user. Run the shutdown command from a mysqladmin client logged in as the admin user.

9.How can you determine the uptime of a DB system?. By checking the DB system details in the OCI Web console. By using the Audit section in Logging information in the OCI Web console. By executing mysql db-system get --db-system-id with OCI CLI. By querying performance_schema global_status from a connected MySQL client.

10.Which two are true about read replica load balancer?. It is created when the DB system is first created. It distributes connections among read replicas. It has the same endpoint as the DB system. It distributes connections among the source DB system and all read replicas. User accounts containing a client host name cannot connect to the read replica load balancer.

11. Which feature do you use to copy transactions from an on-premises MySQL instance to a DB system?. HeatWave cluster. Read replica. Inbound replication. Outbound replication.

12. Which is true about exporting data to Object Storage with MySQL Shell util.dumpInstance?. You must specify ociParManifest: true. You must provide an OCI username and password to gain write access to Object Storage. You must specify osLinux: true. You must have a valid OCI CLI configuration.

13. You want to migrate an on-premises MySQL database to MySQL HeatWave by exporting the MySQL database with MySQL Shell util.dumpInstance. What is the purpose of the osLinux: true option?. It returns an error if the database has any incompatibilities with MySQL HeatWave. It launches a new DB system and imports the data concurrently with the export operation. It enables all MySQL HeatWave compatibility options. It stores the exported files in OCI Object Storage.

15. Which three settings are available when configuring the backup plan of a DB system?. Set the backup compression level. Set the backup window start time. Enable automatic backups. Set the backup retention period. 15.Enable manual backups.

14. Which two are true about MySQL HeatWave configuration resources?. You can view custom configuration sets with the OCI CLI oci mysql db-system get command. You must copy the configuration before changing any variable values. You can set a value for any global MySQL variable in a configuration. You can compare configurations in the same compartment in OCI console.

16. Which three operations can be performed on a MySQL HeatWave backup?. Move an active backup to another compartment. Change the retention period of an active automatic backup. Restore an active backup to a new DB system in another region. Change the retention period of an active manual backup. Delete an active manual backup when point-in-time recovery is enabled on the DB system.

17. Which sequence of steps must you perform to change the configuration of a high-availability DB system?. Disable high availability, edit the DB system, change the configuration, and enable high availability. Edit and change the configuration of all secondary instances, switch over to a secondary instance, and edit and change the configuration of the former primary instance. Edit the DB system and change the configuration. Stop the DB system, edit the DB system, change the configuration, and start the DB system.

18. You want to change the configuration of an active stand-alone DB system. The DB system is configured as the target of a channel, and the channel is currently active. Which sequence of steps must you perform?. Edit the DB system and change the configuration. Stop the channel, edit the DB system, change the configuration, and start the channel. Delete the channel, edit the DB system, change the configuration, and re-create the channel. Stop the DB system, edit the DB system, change the configuration, and start the DB system.

19. Which two are true about configuring a MySQL DB system to use high availability?. It has three instances during a normal operation. All instances share a single copy of the data. The instances can be placed in different VCN subnets. It uses an active standby mechanism where the standby is started when the active instance fails. It provides a single DB system endpoint for client connections.

20. You have obtained a new tenancy on Oracle Cloud Infrastructure. You first create a VCN by using the VCN Wizard, and then create a MySQL DB system. You want to create a Connection in Database Tools to use the SQL Worksheet feature. Which three steps are required?. Create an encryption key. Create an OCI vault. Create an OCI secret. Create an OCI password. Import an X.509 certificate into the OCI vault.

21. You want to migrate an on-premises MySQL database to a MySQL DB system on OCI. Which method provides the least amount of application down time when switching to the DB system?. Use the largest DB system shape to speed up the import. Store the exported data in object storage to speed up the export and import. Use inbound replication to synchronize the MySQL database transactions to the DB system. A.Run MySQL Shell on an OCI compute instance to export and import the data for faster migration.

22. Why would you select "Source cannot use GTID auto-positioning" when creating a channel?. The binary log offset is unknown. Some tables have no primary key. The target DB system is a high-availability DB system. The source gtid_mode is OFF.

23. Which three must be provided when creating a channel?. Target DB system. Replication delay. Source connection password. Source connection SSL mode. Channel name.

24. Which is true about dynamic variables in MySQL HeatWave configurations?. Initialization variables are not dynamic. All user variables are dynamic. Dynamic variables in a custom configuration can be changed without copying the configuration to a new configuration. Changes in dynamic variables require a server restart.

25. Which MySQL HeatWave AutoML routine evaluates a model?. ML_EXPLAIN. ML_EXPLAIN_TABLE. ML_PREDICT_TABLE. ML_TRAIN. ML_SCORE.

26. You have a MySQL DB system configured with lower_case_table_names=0. You want to change the setting to 1. Which action must you take?. Edit the configuration used by the DB system in OCI Console, change lower_case_table_names to 1, and save the changes. Restart the DB system to use the updated configuration. Create an OCI backup of the DB system. Restore the backup to a new DB system configured with lower_case_table_names=1. Run SET GLOBAL lower_case_table_names=1 while connected to the DB system as a user with administrative privileges. Copy the configuration used by the DB system in OCI Console, set lower_case_table_names=1, and save the new configuration. Edit the DB system to use the new configuration. Create a new DB system configured with lower_case_table_names=1. Use MySQL Shell to export and import the data into the new DB system.

27. You want to create a custom configuration for the MySQL DB system in OCI Console. Which three can you set?. VCN. Subnet. Shape. Compartment. Description.

28. You have successfully provisioned a MySQL DB system on Oracle Cloud Infrastructure... You CANNOT connect directly to the DB system endpoint from your workstation connected to the Internet. What is the reason?. MySQL DB system allows only SSL-encrypted connections. MySQL DB system endpoint does not have a public IP address. MySQL DB system allows only connections through a proxy server. MySQL DB systems cannot use the standard MySQL client libraries.

29. Which storage engine is supported by MySQL HeatWave?. InnoDB. CSV. MyISAM. Archive.

30. You want to enable high availability of a stand-alone DB system. Which two conditions are required?. The DB system automatic backup must be enabled. The DB system crash recovery must be enabled. The DB system must be active. The DB system delete protection must be enabled. The DB system point-in-time recovery must be enabled.

31. You encountered an error when enabling high availability of a stand-alone DB system. Which is a possible reason?. The DB system has one or more active read replicas. Some tables in the DB system do not have a primary key. The DB system inbound replication channel is stopped but not deleted. The DB system point-in-time recovery is enabled.

32. You have successfully enabled high availability of a stand-alone DB system. Which is true?. The DB system performs load balancing by distributing client connections to all instances. The DB system has three instances running in different availability or fault domains. The DB system provides new port numbers on the same endpoint to connect to the secondary instances for read-only connections. The DB system provides new endpoints to connect to the secondary instances for read-only connections.

33. A MySQL DB system has an endpoint in an OCI VCN subnet. The VCN is not configured with VCN peering, VPN access, and FastConnect. You want to connect to the MySQL DB system directly from an OCI Cloud Shell session. Which two are true?. The VCN subnet of the Cloud Shell session must have an Internet Gateway in its route table. The MySQL DB system subnet must be in the Cloud Shell tenancy home region. The VCN of the Cloud Shell session must have a Service Gateway in its route table. You must install mysql client programs in the Cloud Shell session. You must attach the Cloud Shell session to a VCN subnet that can connect to the MySQL DB system.

34. You can perform a node estimate when adding a HeatWave cluster to a DB system in OCI Console. Which two tasks are performed by the node estimate process?. Generate a set of ALTER statements to load selected tables into the HeatWave cluster. Estimate the number of OCPUs required to process selected user tables. Estimate the memory required for each user table. Generate a load command to activate Auto Parallel Load. Estimate the disk storage required for each user table.

35. Which operation is necessary before enabling a MySQL HeatWave cluster?. Create a DB system with a HeatWave shape. Start Cloud Shell in OCI Console connected to the DB system’s network. Offload the data to object storage to facilitate reloading into the cluster. Create all the schemas and tables in the DB system but do not load the data.

36. Which two methods can you use to import data into a MySQL DB system by using MySQL Shell?. util.loadDump(). util.dumpInstance(). util.dumpSchemas(). util.importTable().

37. You want to import data into a DB system with MySQL Shell util.loadDump(). Which option can speed up the load?. deferTableIndexes: all. showMetadata: false. updateGtidSet: off. skipBinlog: true.

38. Which placement is NOT valid for a high-availability DB system? (Note: AD refers to availability domain and FD refers to fault domain.). Primary instance: AD1-FD1; Secondary instance 1: AD1-FD2; Secondary instance 2: AD1-FD3. Primary instance: AD1-FD1; Secondary instance 1: AD2-FD2; Secondary instance 2: AD1-FD3. Primary instance: AD1-FD1; Secondary instance 1: AD2-FD2; Secondary instance 2: AD3-FD3. Primary instance: AD1-FD1; Secondary instance 1: AD2-FD2; Secondary instance 2: AD3-FD1.

39. Which is true about automatic DB system version upgrades?. The DB system is upgraded to the most recent release. You must specify the next version to be used before the upgrade. The DB system is upgraded to the next release in sequence. The DB system is never upgraded automatically.

40. You want to connect to a DB system with MySQL Shell. DB system endpoint IP address: 10.0.1.221 Username: admin Password: MySQL8.0 Which two commands work?. mysqlsh -h 10.0.1.221 -u admin -p MySQL8.0. mysqlsh -h 10.0.1.221 -u admin -pMySQL8.0. mysqlsh mysql://admin:MySQL8.0@10.0.1.221. mysqlsh -host 10.0.1.221 -user admin -password MySQL8.0. mysqlsh mysql://MySQL8.0:admin@10.0.1.221.

41. Automatic backup retention of a DB system is disabled. Which operation deletes all automatic backups of the DB system?. Deleting the DB system. Enabling point-in-time recovery. Disabling delete protection. Disabling point-in-time recovery.

42. What must be enabled for using the point-in-time recovery feature in a DB system?. Delete protection. High availability. Automatic backups. HeatWave cluster.

43. When you create a MySQL DB system, the point-in-time recovery feature is enabled. What is the benefit?. You can restore the DB system to any point in time within the automatic backup retention period. You can retain the DB system endpoint IP address when you restore the DB system. You can query the historical data of the DB system at any point in time without restoring the DB system. You can restore the DB system to any point in time after the oldest available backup of the DB system.

44. The following statements execute successfully: less CopyEdit CALL sys.ML_TRAIN('ml_data.iris', 'class', NULL, @model);SELECT @model; Which three are true?. The generated model handle is shown in the output. The statements create a classification model. The target column is class. The training data set is obtained from the ml_data table in the iris schema. The statements validate the data set but do not create a model.

45. You want to train a regression model with MySQL HeatWave AutoML. Which two are requirements of the training data set?. Each distinct value in the target column must appear in at least five rows. The data set must have one target column and at least one feature column. The target column must be numeric. All feature columns must be numeric. The target column and all feature columns must be stored in a single view.

46. You want to create a read replica on a DB system. Which is true about the read replica?. It must have at least 4 OCPUs. It must have at least 1 TB of storage. It must have at least 64 GB of memory. It must be a bare metal shape.

47. Which is also changed when you change the shape of a DB system?. The DB system configuration. The DB system OCID. The DB system server UUID. The DB system endpoint.

48. What is the benefit of creating a new DB system with data import?. Faster backup with a first full backup. Consistent data with no user connection. Smaller storage size with better compression. Faster import with minimal logging.

49. You want to create a new DB system with data import. How do you prepare the data?. Export the data into the file system with the mysqldump client utility. Back up the database into an Object Storage bucket with MySQL Enterprise Backup. Export the data into an Object Storage bucket with a MySQL Shell dump utility. Export the data into the file system with a MySQL Shell dump utility.

50. Which two are true about creating a new DB system with data import?. The data must be created with the mysqldump client utility. The data must be stored in an Object Storage bucket in the same OCI region as the new DB system. The files containing the data must be uploaded through OCI Console on the "Create DB system" page. A valid pre-authenticated request must be provided to access the data. The data must be created with MySQL Enterprise Backup.

51. You want to replicate data from an on-premises MySQL server to a MySQL DB system. Which network configuration is required?. Configure an OCI network load balancer to accept incoming connections on a public IP and route to the DB system private IP address. Create a NAT gateway in the VCN and configure the DB system subnet to route Internet-bound traffic to the NAT gateway. Create a service gateway in the VCN and configure the DB system subnet to route Internet-bound traffic to the service gateway. Create an Internet gateway in the VCN and configure the DB system subnet to route Internet-bound traffic to the Internet gateway.

52. You have an inbound replication channel that replicates data from one DB system to another DB system. What is the possible cause?. The missing GTID has been archived to object storage and is no longer available. The target DB system relay log file destination is full. The channel has been disabled for more than 2 hours. The administrator has deleted the binary log files from the source DB system.

53. You have a MySQL DB system with five active read replicas. Which connection method provides the fastest query response time?. Connect to the read replica load balancer to perform read-write operations. Connect to a specified read replica to perform read-only operations. Connect to the source DB system to perform read-only operations. Connect to the read replica load balancer to perform read-only operations.

54. You want to create a second user called admin2 with the same privileges as the administrator. Which statement helps you achieve this?. CREATE USER admin2 IDENTIFIED BY 'Password'; GRANT AUDIT_ADMIN, BACKUP_ADMIN, SESSION_VARIABLES_ADMIN ON *.* TO admin2 WITH GRANT OPTION;. CREATE USER admin2 IDENTIFIED BY 'Password' DEFAULT ROLE 'administrator';. CREATE USER admin2 IDENTIFIED BY 'Password'; GRANT SUPER ON *.* TO admin2 WITH GRANT OPTION;. CREATE USER admin2 IDENTIFIED BY 'Password'; GRANT ALL PRIVILEGES ON *.* TO admin2 WITH GRANT OPTION;.

55. A port-forwarding Bastion session has been created for a MySQL DB system listening on 10.10.1.187:3306. Which command connects to the MySQL DB system from the client machine?. mysqlsh mysql/admin@10.10.1.187:3311. mysqlsh mysql/admin@10.10.1.187:3306. mysqlsh mysql/admin@127.0.0.1:3311. mysqlsh mysql/admin@127.0.0.1:3306.

56.Which two are true about creating a Bastion service to connect to a MySQL DB system?. The Bastion service must be in the same VCN as the DB system. The Bastion CIDR block allowlist must include the IP address of all valid client machines. The Bastion service must have a public IP address. The Bastion subnet must have an ingress rule to allow stateful connections on the MySQL DB system port number. The Bastion CIDR block allowlist must include the IP address of the DB system.

57. You want to train a machine learning model to predict the genre of library books based on the information stored in the Books table. Which command trains an appropriate model?. CALL my_ml.TRAIN('Books.Library', 'Genre', 'NON_OBJECT', 'regression', @model);. CALL my_ml.TRAIN('Library.Books', 'Genre', 'NON_OBJECT', 'classification', @model);. CALL my_ml.TRAIN('Library.Books', 'Genre', 'NON_OBJECT', 'clustering', @model);. 57.CALL my_ml.TRAIN('Library.Books', 'Genre', 'NON_OBJECT', 'regression', @model);.

58. Which two are true about data loaded into a MySQL HeatWave cluster?. Data is stored in hybrid columnar format to speed up analytic queries. Data is stored locally in each cluster node's solid state disks (SSDs) to increase I/O performance. Data rows are sorted on the primary key to speed up range search. Data is partitioned across cluster nodes for scalability. Data is replicated across cluster nodes for high availability.

59. You want to determine which version of MySQL is running on your DB system. Which two SQL statements show the MySQL version?. SELECT * FROM performance_schema.global_status WHERE VARIABLE_NAME='version';. select @@version;. SELECT @version;. SHOW STATUS LIKE 'version';. 59.SHOW VARIABLES LIKE 'version';.

60. Which MySQL DB system architecture provides automatic failover with no data loss?. Read replicas. Crash recovery. High availability. Inbound replication.

61. The following statements are executed successfully: sql CopyEdit mysql > CREATE TABLE airport ( airport_id INT NOT NULL, city CHAR(20) DEFAULT NULL, state CHAR(20) DEFAULT NULL, country CHAR(20) DEFAULT NULL, airport_code CHAR(3) NOT NULL, PRIMARY KEY(airport_id) ) ENGINE=INNODB SECONDARY_ENGINE=rapid ENGINE_ATTRIBUTE='{"file":[{"region":"us-ashburn-1","namespace":"mytenant","bucket":"bucket01","name":"airport.tbl"}]}'; mysql> SELECT COUNT(*), COUNT(DISTINCT airport_id)FROM airport; Which two are true?. Every row in the airport table has a unique airport_id value. The data of the airport table is loaded into the MySQL DB system. The airport.tbl file is in CSV format. The fields in the airport.tbl file are delimited by comma. The data placement key of the airport table is airport_id.

62. Which table option defines a Lakehouse external table based on a CSV file?. ENGINE=csv SECONDARY_ENGINE=rapid ENGINE_ATTRIBUTE=... ENGINE=csv SECONDARY_ENGINE=lakehouse ENGINE_ATTRIBUTE=... ENGINE=lakehouse SECONDARY_ENGINE=rapid ENGINE_ATTRIBUTE=... ENGINE=lakehouse SECONDARY_ENGINE=csv ENGINE_ATTRIBUTE=...

63. You have two DB systems running in different OCI regions... You want to perform inbound replication... Which VCN configuration is required?. Internet gateway in each of the DB system's subnets in both VCNs. Local VCN peering between the two VCNs. FastConnect between the two VCNs. Remote VCN peering between the two VCNs.

64. You want to deploy a high-availability MySQL DB system in a region with multiple availability domains... Which two types of subnet provide maximum redundancy?. A private regional subnet. A public AD-specific subnet. A private AD-specific subnet. A public regional subnet.

65. You run this command to connect successfully to a DB system: bash CopyEdit mysqlsh john@10.0.1.122 --auth-method=authentication_oci_client Why does the command NOT require a password?. The operating system user credential is used... The credential is stored in an OCI vault secret. The correct API key-pair is specified in the ~/.oci/config file. The correct password is saved in the local MySQL Shell secret store.

66.You want to train a classification model with MySQL HeatWave AutoML. Which two are requirements of the training data set? (Choose two.). The target column must be numeric. The target column and all feature columns must be stored in a single table. All feature columns must be numeric. There must be at least two feature columns. The target column must have at least two distinct values.

67.Which two are available when creating a new MySQL DB system in OCI Console? (Choose two.). High availability. Lakehouse. Standalone server. Read replica. HeatWave cluster.

68.Which command trains the model?. CALL sys.ML_TRAIN('ml_data.sales', 'Sales', JSON_OBJECT('task', 'anomaly_detection'), @model);. CALL sys.mML_TRAIN('ml_data.sales', 'Sales', JSON_OBJECT('task', 'forecasting'), @model);. CALL sys.ML_TRAIN('ml_data.sales', 'Sales', JSON_OBJECT('task', 'classification'), @model);. CALL sys.ML_TRAIN('ml_data.sales', 'Sales', JSON_OBJECT('task', 'regression'), @model);.

69. You want to restore the backup of a stand-alone DB system to a new DB system. Which two changes are allowed? (Choose two.). Use a smaller data storage size for the new DB system. Use a different subnet for the new DB system. Use a different shape for the new DB system. Use a different tenancy for the new DB system. Use a different region for the new DB system.

70.You want to restore a stand-alone DB system to a high-availability DB system with a point-in-time recovery. Which three are required? (Choose three.). Every user table must have a primary key. Point-in-time recovery must be enabled before the point in time to which you want to restore. An automatic backup taken before the selected point in time must be available. A manual backup taken before the selected point in time must be available. The stand-alone DB system must remain active during the restore.

71.You create a new MySQL DB system. It fails because you use mysql.sys as the administrator username. What is the reason?. mysql.sys is a reserved username that cannot be used in customer-defined user accounts. The username can contain only uppercase characters. The username cannot contain non-alphanumeric characters, such as a period. The username must have at least 10 characters.

72.Which is true about changing the storage size of a DB system?. You must increase the DB system's storage size in multiples of 100 GB. You cannot decrease the DB system’s storage size. You must stop the DB system before changing its storage size. The DB system shuts down during the resize operation.

73. Which type of configuration variables CANNOT be modified in MySQL custom configurations?. Initialization variables. User variables. System variables. Default user variables.

74. Which three are features of MySQL AutoPilot? (Choose three.). Auto backup. Auto thread pooling. Auto encoding. Auto provisioning. AutoML.

75. You create a MySQL DB system with default port numbers, and attach it to a subnet. Which configuration is required on the subnet to enable client applications to connect to the DB system?. Create an ingress rule that allows stateless connections on port 3306 and 33060. Create an egress rule that allows stateful connections on port 3306 and 33060. Create an ingress rule that allows stateful connections on port 3306 and 33060. Create an egress rule that allows stateless connections on port 3306 and 33060.