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

質問 1

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

（A）Generate a load command to activate Auto Parallel Load.

（B）Estimate the disk storage required for each user table.

（C）Estimate the memory required for each user table.

（D）Generate a set of alter statements to load selected tables into the HeatWave cluster.

（E）Estimate the number of OCPUs required to process selected user tables.

正解：C、E 解答を投票する

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

質問 2

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

（A）Create an OCI secret.

（B）Create an OCI password.

（C）Import an X.509 certificate into the OCI vault.

（D）Create an encryption key.

（E）Create an OCI vault.

正解：A、B、C 解答を投票する

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

質問 3

You want to train a classification model with MySQL HeatWave AutoML. Which two are requirements of the training data set? (Choose two.)

（A）All feature columns must be numeric.

（B）The target column must have at least two distinct values.

（C）There must be at least two feature columns.

（D）The target column must be numeric.

（E）The target column and all feature columns must be stored in a single table.

正解：B、E 解答を投票する

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

質問 4

You want to replicate data from an on-premises MySQL server to a MySQL DB system. The on-premises MySQL server runs in your corporate network. The MySQL server accepts incoming connections from the Internet on a public IP endpoint.
The DB system runs in Oracle Cloud Infrastructure. The DB system endpoint is connected to a privatesubnet of a VCN.
Which network configuration is required?

（A）Create an Internet gateway in the VCN and configure the DB system subnet to route Internet-bound traffic to the Internet gateway.

（B）Create a NAT gateway in the VCN and configure the DB system subnet to route Internet-bound traffic to the NAT gateway.

（C）Create a service gateway in the VCN and configure the DB system subnet to route Internet-bound traffic to the service gateway.

（D）Configure an OCI network load balancer to accept incoming connections on a public IP and route to the DB system private IP address.

正解：B 解答を投票する

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

質問 5

You want to determine which version of MySQL is running on your DB system.
Which two SQL statements show the MySQL version? (Choose two.)

（A）SHOW STATUS LIKE 'version';

（B）select @@version;

（C）SELECT * FROM performance_schema.global_status WHERE VARIABLE_NAME='version';

（D）SHOW VARIABLES LIKE 'version';

（E）SELECT @version;

正解：B、D 解答を投票する

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

質問 6

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://MySQL8.0:[email protected]

（B）mysqlsh -h 10.0.1.221 -u admin -p MySQL8.0

（C）mysqlsh -h10.0.1.221 -uadmin -pMySQL8.0

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

（E）mysqlsh mysql://admin:[email protected]

正解：C、E 解答を投票する

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

質問 7

You have an inbound replication channel that replicates data from one DB system to another DB system. Both DB systems are created with the default configuration.
You encountered the following error on the target DB system:

What is the possible cause?

（A）The missingGTID set has been archived to object storage and is no longer available.

（B）The administrator has deleted the binary log files from the source DB system.

（C）The target DB system relay log file destination is full.

（D）The channel has been disabled for more than 2 hours.

正解：B 解答を投票する

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

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

弊社を連絡する

関連リンク

トップ試験