最新的MySQL Database Administration認證 1z0-915-1考試題庫

問題1

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?

A. Create an ingress rule that allows stateless connections on port 3306 and 33060.

B. Create an egress rule that allows stateful connections on port 3306 and 33060.

C. Create an egress rule that allows stateless connections on port 3306 and 33060.

D. Create an ingress rule that allows stateful connections on port 3306 and 33060.

正確答案: D

說明：（僅 VCESoft 成員可見）

問題2

Which two methods can be used to stop a DB system? (Choose two.)

A. Run the SHUTDOWN SQL statement from any connected client logged in as the admin user.

B. Use the STOP action on the DB system details page in the OCI Console.

C. Execute the mysql db-system stop command from OCI CLI.

D. Run the shutdown command from a mysqladmin client logged in as the admin user.

正確答案: B,C

說明：（僅 VCESoft 成員可見）

問題3

Which feature do you use to copy transactions from an on-premises MySQL instance to a DB system?

A. Inbound replication

B. Read replica

C. HeatWave cluster

D. Outbound replication

正確答案: A

說明：（僅 VCESoft 成員可見）

問題4

You want to train a model that predicts sales based on the available data the company holds.
This is an excerpt of thesalestable:

Which command trains the model?

A. CALL sys.ML_TRAIN('ml_data.sales', 'Sales', JSON_OBJECT('task', 'classification'), @model);

B. CALL sys.ML_TRAIN('ml_data.sales', 'Sales', JSON_OBJECT('task', 'anomaly_detection'),
@model);

C. CALL sys.mML_TRAIN('ml_data.sales', 'Sales', JSON_OBJECT('task', 'forecasting'), @model);

D. CALL sys.ML_TRAIN('ml_data.sales', 'Sales', JSON_OBJECT('task', 'regression'), @model);

正確答案: D

說明：（僅 VCESoft 成員可見）

問題5

Which sequence of steps must you perform to change the configuration of a high-availability DB system?

A. Edit and change the configuration of all secondary instances, switch over to a secondary instance, andedit and change the configuration of the former primary instance.

B. Disable high availability, edit the DB system, change the configuration, and enable high availability.

C. Edit the DB system and change the configuration.

D. Stop the DB system, edit the DB system, change the configuration, and start the DB system.

正確答案: D

說明：（僅 VCESoft 成員可見）

問題6

Which three must be provided when creating a channel? (Choose three.)

A. Replication delay

B. Channel name

C. Source connection SSL mode

D. Source connection password

E. Target DB system

正確答案: B,C,D

說明：（僅 VCESoft 成員可見）

問題7

Which two are true about MySQL HeatWave configuration resources? (Choose two.)

A. You can compare configurations in the same compartment in OCI console.

B. You can set a value for any global MySQL variable in a configuration.

C. You can view custom configuration sets with the OCI CLI oci mysql db-system get command.

D. You must copy the configuration before changing any variable values.

正確答案: B,C

說明：（僅 VCESoft 成員可見）

最新的Oracle MySQL HeatWave Implementation Associate Rel 1 - 1z0-915-1免費考試真題

最新更新

站內鏈接

聯系我們