Oracle 1z0-915-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 number of OCPUs required to process selected user tables.
C. Estimate the disk storage required for each user table.
D. Generate a set of alter statements to load selected tables into the HeatWave cluster.
E. Estimate the memory required for each user table.
正解：B,E
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which two are benefits of read replicas? (Choose two.)
A. Scale read queries.
B. Reduce down time.
C. Reduce network latency.
D. Reduce query latency.
E. Speed up analytical queries.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
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? (Choose two.)
A. You must install mysql client programs in the Cloud Shell session.
B. The VCN subnet of the Cloud Shell session must have an Internet Gateway in its route table.
C. The MySQL DB system subnet must be in the Cloud Shell tenancy home region.
D. You must attach the Cloud Shell session to a VCN subnet that can connect to the MySQL DB system.
E. The VCN subnet of the Cloud Shell session must have a Service Gateway in its route table.
正解：C,D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
You run this command to connect successfully to a DB system:
mysqlsh [email protected] --auth-method=authentication_oci_client
Why does the command NOT require a password?
A. The credential is stored in an OCI vault secret.
B. The operating system user credential is used to authenticate with the DB system.
C. The correct password is saved in the local MySQL Shell secret store.
D. The correct API key-pair is specified in the -/. oci. config file.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which feature do you use to copy transactions from an on-premises MySQL instance to a DB system?
A. Outbound replication
B. Inbound replication
C. Read replica
D. HeatWave cluster
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 6：
There are more than 10 concurrent users running queries on the DB system. The airport_geo table has been loaded successfully into a HeatWave cluster.
You want to run this query:
SELECT DISTINCT country FROM airport_geo ORDER BY country;
How do you determine whether the query is offloaded to the HeatWave cluster for execution?
A. View the Query Execution Plan of the query by running EXPLAIN.
B. Query the rpd_tables table in performance_schema.
C. Check the value of the hw_data_scanned global status variable.
D. Check the value of the rapid_query_offload_count global status variable.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 7：
You want to create a new DB system with data import. How do you prepare the data?
A. Back up the database into an Object Storage bucket with MySQL Enterprise Backup.
B. Export the data into the file system with the mysqldump client utility.
C. Export the data into anObject Storage bucket with a MySQL Shell dump utility.
D. Export the data into the file system with a MySQL Shell dump utility
正解：C
解説: (Topexam メンバーにのみ表示されます)