Question No. 1

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. 2

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. 3

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 private subnet of a VCN.

Which network configuration is required?

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

BCreate a service gateway in the VCN and configure the DB system subnet to route Internet-bound traffic to the service gateway.

CCreate an Internet gateway in the VCN and configure the DB system subnet to route Internet-bound traffic to the Internet gateway.

DCreate a NAT gateway in the VCN and configure the DB system subnet to route Internet-bound traffic to the NAT gateway.

Show Answer

Correct Answer: A

Question No. 4

You want to create a second user called admin2 with the same privileges as the administrator specified when creating the DB system.

Which statement helps you achieve this?

ACREATE USER admin2 IDENTIFIED BY 'Password' DEFAULT ROLE 'administrator';

BCREATE USER admin2 IDENTIFIED BY 'Password'; GRANT SUPER ON *.* TO admin2 WITH GRANT OPTION;

CCREATE USER admin2 IDENTIFIED BY 'Password'; GRANT AUDIT_ADMIN, BACKUP_ADMIN, SESSION_VARIABLES_ADMIN ON *.* TO admin2 WITH GRANT OPTION;

DCREATE USER admin2 IDENTIFIED BY 'Password'; GRANT ALL PRIVILEGES ON *.* TO admin2 WITH GRANT OPTION;

Show Answer

Correct Answer: D

Question No. 5

You want to enable high availability of a stand-alone DB system. Which two conditions are required? (Choose two.)

AThe DB system delete protection must be enabled.

BThe DB system crash recovery must be enabled.

CThe DB system point-in-time recovery must be enabled.

DThe DB system must be active.

EThe DB system automatic backup must be enabled.

Show Answer

Correct Answer: D, E

Free Oracle 1Z0-915-1 Exam Actual Questions

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