Oracle Cloud Database Services 2021 Specialist - 1Z0-1093-21 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

You are asked to create a MySQL Database Service system. You can log in to the group's Oracle Cloud Infrastructure tenancy and access the assigned compartment, and all policies have been configured and tested.
What is the next step to create a MySQL Database Service?

A. Connect to the MySQL Database Service system endpoint. B. Create a Linux compute instance. C. Create a Virtual Cloud Network by using the VCN Wizard. D. Create the MySQL DB system.

Discussion 0

Correct Answer: C Vote an answer

Question 2

Which three actions can you perform on a DB system that has an Oracle Data Guard association with a standby database?
(Choose all correct answers)

A. You can write on both primary and standby databases because DB system standby databases in Oracle Cloud Infrastructure Database are logical standbys. B. You can terminate a primary database DB system. C. You can switch over the primary database to the standby role, perform maintenance on the standby database, and then switch it back to the primary role. D. You can use the reinstate command to return a failed database into standby role after correcting the cause of failure. E. If the primary database becomes unavailable, then you can use Oracle Data Guard to fail over the standby database to the primary role.

Discussion 0

Correct Answer: C,D,E Vote an answer

Question 3

Patching requires role permissions. However, since roles are not granted by default, which role needs to be added to someone patching the DB system?

A. Let users manage compute instance configurations, instance pools, and cluster networks. B. Let database administrator's manage DB systems. C. Let security admins manage vaults, keys, and secrets. D. Let database and fleet admins manage Autonomous Databases.

Discussion 0

Correct Answer: B Vote an answer

Question 4

What THREE steps must you perform to connect to a MySQL database in the database system by using SSH and MySQL Shell?

A. Start MySQL Shell on the compute instance. B. Add an ingress rule for port 20. C. Instantiate MySQL Shell on the MySQL database system instance. D. SSH into the compute instance from your local machine. E. Connect to the MySQL Database Service instance.

Discussion 0

Correct Answer: C,D,E Vote an answer

Question 5

Which three statements are true regarding MySQL Database Service HeatWave? (Choose all correct answers) HeatWave uses periodic long-running ETL batch jobs to refresh the data.

A. Heatwave uses machine learning to automate operations, increasing DBA productivity and reducing costs. B. Heatwave is a in-memory, query-processing engine designed for fast execution of analytic queries. C. HeatWave data which is needed for analytic processing is stored in disk files. D. Heatwave is Exclusively available in Oracle Cloud Infrastructure.

Discussion 0

Correct Answer: A,B Vote an answer

Question 6

You are considering whether or not to implement bare metal or virtual machine shapes. Which TWO statements are true about bare metal and virtual machine (VM) database (DB) systems? (Choose all correct answers)

A. The Console, API, and Oracle Cloud Infrastructure CLI are options for managing bare metal DB systems. B. Bare metal and VM DB can only have a single Database Home, and the single database will be the version of the Database Home. C. Bare metal shapes determine the total raw storage allocated to bare metal DB systems. D. Both bare metal and vm DB systems support two-node Real Application Clusters (RAC) systems.

Discussion 0

Correct Answer: A,C Vote an answer