11.11 Sale - Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70dumps

1z0-915-1 Questions and Answers

Question # 6

Which three must be provided when creating a channel? (Choose three.)

A.

Channel name

B.

Source connection SSL mode

C.

Target DB system

D.

Source connection password

E.

Replication delay

Full Access
Question # 7

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 memory required for each user table.

D.

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

E.

Estimate the disk storage required for each user table.

Full Access
Question # 8

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 -h 10.0.1.221 -u admin -p MySQL8.0

B.

mysqlsh mysql://MySQL8.0:admin@10.0.1.221

C.

mysqlsh mysql://admin:MySQL8.0@10.0.1.221

D.

mysqlsh -h10.0.1.221 -uadmin -pMySQL8.0

E.

mysqlsh -host 10.0.1.221 -user admin -password MySQL8.0

Full Access
Question # 9

How can you determine the uptime of a DB system?

A.

By using the Audit section in Logging information in the OCI Web console

B.

By checking the DB system details in the OCI Web console

C.

By querying performance_schema.global_status from a connected MySQL client

D.

By executing mysql db-system get --db-system-id with OCI CLI

Full Access
Question # 10

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

A.

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

B.

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

C.

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

D.

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

Full Access
Question # 11

You want to train a model that predicts sales based on the available data the company holds.

This is an excerpt of thesalestable:

Which command trains the model?

A.

CALL sys.ML_TRAIN(‘ml_data.sales’, ‘Sales’, JSON_OBJECT(‘task’, ‘anomaly_detection’), @model);

B.

CALL sys.mML_TRAIN(‘ml_data.sales’, ‘Sales’, JSON_OBJECT(‘task’, ‘forecasting’), @model);

C.

CALL sys.ML_TRAIN(‘ml_data.sales’, ‘Sales’, JSON_OBJECT(‘task’, ‘classification’), @model);

D.

CALL sys.ML_TRAIN(‘ml_data.sales’, ‘Sales’, JSON_OBJECT(‘task’, ‘regression’), @model);

Full Access
Question # 12

A port-forwarding Bastion session has been created for a MySQL DB system listening on 10.10.1.187:3306. The SSH command provided by the Bastion session is:

An SSH tunnel is created successfully on a client machine by running this command:

Which command connects to the MySQL DB System from the client machine?

A.

mysqlsh mysql://admin@10.10.1.187:3311

B.

mysqlsh mysql://admin@127.0.0.1:3306

C.

mysqlsh mysql://admin@127.0.0.1:3311

D.

mysqlsh mysql://admin@10.10.1.187:3306

Full Access
Question # 13

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 attach the Cloud Shell session to a VCN subnet that can connect to the MySQL DB system.

B.

You must install mysql client programs in the Cloud Shell session.

C.

The MySQL DB system subnet must be in the Cloud Shell tenancy home region.

D.

The VCN subnet of the Cloud Shell session must have a Service Gateway in its route table.

E.

The VCN subnet of the Cloud Shell session must have an Internet Gateway in its route table.

Full Access
Question # 14

Which placement is NOT valid for a high-availability DB system? (Note: AD refers to availability domain and FD refers to fault domain.)

A.

Primary instance: AD1-FD1; Secondary instance 1: AD2-FD2; Secondary instance 2: AD3-FD3

B.

Primary instance: AD1-FD3; Secondary instance 1: AD2-FD2; Secondary instance 2: AD3-FD3

C.

Primary instance: AD1-FD1; Secondary instance 1: AD1-FD2; Secondary instance 2: AD1-FD3

D.

Primary instance: AD1-FD3; Secondary instance 1: AD1-FD2; Secondary instance 2: AD1-FD3

Full Access
Question # 15

Which two are available when creating a new MySQL DB system in OCI Console? (Choose two.)

A.

High availability

B.

Lakehouse

C.

Standalone server

D.

Read replica

E.

HeatWave cluster

Full Access
Question # 16

Which two are benefits of read replicas? (Choose two.)

A.

Reduce query latency.

B.

Reduce down time.

C.

Reduce network latency.

D.

Scale read queries.

E.

Speed up analytical queries.

Full Access
Question # 17

The first query has an estimated cost of 100,000,000 and is offloaded to a HeatWave cluster for execution:

SELECT flightno, departure, country FROM flight JOIN airport_geo ON ‘from’=airport_id;

The second query has an estimated cost of 10,000 and is NOT offloaded to the Heatwave cluster for execution:

SELECT DISTINCT country FROM airport_geo ORDER BY country;

Which two methods can offload the second query to the Heatwave cluster for execution? (Choose two.)

A.

SET use_secondary_engine=FORCED;

B.

SET secondary_engine_cost_threshold=1000;

C.

SET optimizer_trace=”enabled=on”;

D.

CALL sys.heatwave_load(‘[“airport_geo”]’);

E.

CALL sys.heatwave_advisor(JSON_OBJECT(“auto_enc”, JSON_OBJECT(“mode”, “recommend”)));

Full Access
Question # 18

Which MySQL HeatWave AutoML routine evaluates a model?

A.

ML_EXPLAIN

B.

ML_EXPLAIN_TABLE

C.

ML_TRAIN

D.

ML_SCORE

E.

ML_PREDICT_TABLE

Full Access
Question # 19

You have a MySQL DB system with five active read replicas. The workload consists of 5% writes and 95% reads.

Which connection method provides the fastest query response time?

A.

Connect to the source DB system to perform read-only operations.

B.

Connect to a specific read replica to perform read-only operations.

C.

Connect to the read replica load balancer to perform read-only operations.

D.

Connect to the read replica load balancer to perform read/write operations.

Full Access