1z0-915-1 무료 덤프문제 온라인 액세스

You want to restore a stand-alone DB system to a high-availability DB system with a point-in-time recovery.
Which three are required? (Choose three.)

• A.The stand-alone DB system must remain active during the restore.
• B.Point-in-time recovery must be enabled before the point in time to which you want to restore.
• C.An automatic backup taken before the selected point in time must be available.
• D.A manual backup taken before the selected point in time must be available.
• E.Every user table must have a primary key.

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 privatesubnet of a VCN.
Which network configuration is required?

• A.Create a service gateway in the VCN and configure the DB system subnet to route Internet-bound traffic to the service gateway.
• B.Configure an OCI network load balancer to accept incoming connections on a public IP and route to the DB system private IP address.
• C.Create a NAT gateway in the VCN and configure the DB system subnet to route Internet-bound traffic to the NAT gateway.
• D.Create an Internet gateway in the VCN and configure the DB system subnet to route Internet-bound traffic to the Internet gateway.

Which two are true about data loaded into a MySQL HeatWave cluster? (Choose two.)

• A.Data rows are sorted on the primary key to speed up range search.
• B.Data is stored locally in each cluster node's solid state disks (SSD) to increase I/O performance.
• C.Data is partitioned across cluster nodes for scalability.
• D.Data is stored in hybrid columnar format to speed up analytic queries.
• E.Data is replicated across cluster nodes for high availability.

How can you determine the uptime of a DB system?

• A.By executing mysql db-system get --db-system-id with OCI CLI
• B.By using the Audit section in Logging information in the OCI Web console
• C.By checking the DB system details in the OCI Web console
• D.By querying performance_schema.global_status from a connected MySQL client

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

• A.ENGINE=csv SECONDARY_ENGINE=lakehouse ENGINE_ATTRIBUTE='{"file": [{"region":
  "us-ashburn-1", "namespace": "mytenant", "bucket": "bucket01", "name": "airport.csv"}] }'
• B.ENGINE=csv SECONDARY_ENGINE=rapid 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"}] }'