1z0-915-1試験無料問題集（67題）「Oracle MySQL HeatWave Implementation Associate Rel 1 認定」

出題：1

A port-forwarding Bastion session has been created for a MySQL DB system listening on 10.10.1.187:3306.
The SSH command provided by the Bastion session is:

An SSH tunnel is created successfully on a client machine by running this command:

Which command connects to the MySQL DB System from the client machine?

A. mysqlsh mysql://[email protected]:3306

B. mysqlsh mysql://[email protected]:3311

C. mysqlsh mysql://[email protected]:3311

D. mysqlsh mysql://[email protected]:3306

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

You want to import data into a DB system with MySQL Shell util.loadDump().
Which option can speed up the load?

A. skipBinlog: true

B. deferTableIndexes: all

C. updateGtidSet: off

D. showMetadata: false

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

You have a MySQL DB system with five active read replicas. The workload consists of 5% writes and 95% reads.
Which connection method provides the fastest query response time?

A. Connect to a specific read replica to perform read-only operations.

B. Connect to the source DB system to perform read-only operations.

C. Connect to the read replica load balancer to perform read-only operations.

D. Connect to the read replica load balancer to perform read/write operations.

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

Which two methods can you use to import data into a MySQL DB system by using MySQL Shell? (Choose two.)

A. util.importTable()

B. util.loadDump()

C. util.dumpInstance()

D. util.dumpSchemas()

正解：A,B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

A query is not offloaded to the HeatWave cluster for execution. Which three are possible reasons? (Choose three.)

A. The use_secondary_engine session variable is OFF.

B. A required column is excluded from the RAPID secondary engine.

C. The user does not have privileges to access the HeatWave cluster.

D. The client is connected to the DB system instead of the HeatWave cluster.

E. The query estimated cost is less than the query cost threshold.

正解：A,B,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

What must be enabled for using the point-in-time recovery feature in a DB system?

A. HeatWave cluster

B. High availability

C. Automatic backups

D. Delete protection

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

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? (Choose two.)

A. mysqlsh mysql://admin:[email protected]

B. mysqlsh -h10.0.1.221 -uadmin -pMySQL8.0

C. mysqlsh -h 10.0.1.221 -u admin -p MySQL8.0

D. mysqlsh -host 10.0.1.221 -user admin -password MySQL8.0

E. mysqlsh mysql://MySQL8.0:[email protected]

正解：A,B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

1z0-915-1試験無料問題集「Oracle MySQL HeatWave Implementation Associate Rel 1 認定」