Free Oracle 1Z0-915-1 Exam Questions

Become Oracle Certified with updated 1Z0-915-1 exam questions and correct answers

Page: 1 / 40

Total 200 Questions | Updated On: Jul 08, 2025

Add To Cart

Question 1

You need to create a read replica for your MySQL HeatWave service in a different OCI region. Which of the following is the MOST efficient approach?

A : Clone the entire HeatWave service with its read replica configuration.

B : Create a new HeatWave service in the target region and manually configure a read replica connection.

C : Use the Oracle Cloud Infrastructure (OCI) Console to create a read replica directly from the source HeatWave service.

D : Backup the source HeatWave service and restore it in the target region, including the read replica configuration.

Answer: C

Question 2

You want to set up automatic backups for your MySQL HeatWave service in OCI. Which three configuration options are essential for a robust backup strategy?

A : Retention policy for archived backups

B : Encryption options for backup files

C : Scheduling for incremental backups

D : Backup storage destination in OCI Object Storage

E : Integration with Oracle Cloud Infrastructure Notifications

Answer: A,B,D

Question 3

You need to set up inbound replication for a specific schema in your on-premises MySQL database to a dedicated table in your MySQL HeatWave replica. Which channel configuration should you utilize?

A : Use a single channel with a table filter to include only the desired schema from the source.

B : Configure a multi-source channel capturing all changes from the on-premises database and filter specific tables during apply on the HeatWave side.

C : Create a dedicated channel for the target table in the HeatWave replica and specify the source schema and table during channel creation.

D : Implement a statement-based filter on the source database replication plugin to selectively capture changes for the target table.

Answer: C

Question 4

Which backup method utilizes minimal network resources and complies with security best practices?

A : Offline backup using the HeatWave Administration Console

B : Online backup with RMAN to Object Storage via a public endpoint

C : Online backup with the HEATWAVE_FULL_BACKUP tool to a local NVMe disk

D : Online backup with Data Guard to another HeatWave service in a separate VCN

Answer: A

Question 5

You are successfully connected to your MySQL HeatWave DB system using MySQL Shell. Which command can you use to verify the connection and confirm you are accessing the HeatWave layer?

A : SHOW SCHEMAS; - This command lists all available schemas in the database.

B : SELECT * FROM SYS.STORAGE_POOL; - This command retrieves information about the HeatWave storage pool.

C : SHOW ENGINE; - This command displays the currently active storage engine, indicating HeatWave if connected correctly.

D : SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES; - This command counts the total number of tables in the database.

E : SHOW VARIABLES WHERE VARIABLE_NAME LIKE '%HEATWAVE%'; - This command displays all MySQL variables related to HeatWave settings.

Answer: C

Page: 1 / 40

Total 200 Questions | Updated On: Jul 08, 2025

Add To Cart