Question No. 1

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

AThe use_secondary_engine session variable is OFF.

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

CThe query estimated cost is less than the query cost threshold.

DThe user does not have privileges to access the HeatWave cluster.

EA required column is excluded from the RAPID secondary engine.

Show Answer

Correct Answer: A, C, E

Question No. 2

Which table option defines a Lakehouse external table based on a CSV file?

AENGINE=csv SECONDARY_ENGINE=rapid ENGINE_ATTRIBUTE='{''file'': [{''region'': ''us-ashburn-1'', ''namespace'': ''mytenant'', ''bucket'': ''bucket01'', ''name'': ''airport.csv''}] }'

BENGINE=csv SECONDARY_ENGINE=lakehouse ENGINE_ATTRIBUTE='{''file'': [{''region'': ''us-ashburn-1'', ''namespace'': ''mytenant'', ''bucket'': ''bucket01'', ''name'': ''airport.csv''}] }'

CENGINE=lakehouse SECONDARY_ENGINE=csv ENGINE_ATTRIBUTE='{''file'': [{''region'': ''us-ashburn-1'', ''namespace'': ''mytenant'', ''bucket'': ''bucket01'', ''name'': ''airport.csv''}] }'

DENGINE=lakehouse SECONDARY_ENGINE=rapid ENGINE_ATTRIBUTE='{''file'': [{''region'': ''us-ashburn-1'', ''namespace'': ''mytenant'', ''bucket'': ''bucket01'', ''name'': ''airport.csv''}] }'

Show Answer

Correct Answer: C

Question No. 3

What is the benefit of creating a new DB system with data import?

AFaster import with minimal logging

BSmaller storage size with better compression

CFaster backup with a first full backup

DConsistent data with no user connection

Show Answer

Correct Answer: A

Question No. 4

Why would you select "Source cannot use GTID auto-positioning" when creating a channel?

AThe target DB system is a high-availability DB system.

BSome tables have no primary key

CThe binary log offset is unknown.

DThe source gtid mode is OFF.

Show Answer

Correct Answer: D

Question No. 5

Which two are true about creating a new DB system with data import? (Choose two.)

AThe data must be created with the mysqldump client utility.

BThe files containing the data must be uploaded through OCI Console on the 'Create DB system' page.

CThe data must be stored in an Object Storage bucket in the same OCI region as the new DB system.

DA valid pre-authenticated request must be provided to access the data.

EThe data must be created with MySQL Enterprise Backup.

Show Answer

Correct Answer: C, D

Free Oracle 1Z0-915-1 Exam Actual Questions

The questions for 1Z0-915-1 were last updated On Nov 20, 2024