Question 1

You want to examine how much Smart Scan activity is occurring. Which two would provide the information you require?

Options :

A : the number of full table scans that accessed the table

B :

the number of Smart Scans performed for the table on all the storage servers, as shown when performing a list activerequest command using CELLCLI on all the cells

C : the number of serial queries that accessed the table

D : the number of parallel queries that accessed the table

E :

the number of Smart Scans performed for the table on all the storage servers, as shown when performing a list ACTIVEREQUEST command using EXACLI on all the cells

Answer: B,E

Question 2

How do ASM failure groups provide redundancy?

Options :

A :

Failure groups are created for each grid disk to ensure mirror copies are written to the same storage server for faster recovery after a physical disk failure.

B :

Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.

C :

They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.

D : Extended Redundancy mirrors data across data centers providing the highest levels of data protection.

Answer: B

Question 3

Which two options describe the flash memory capabilities of the Exadata X9M-2 database and storage severs?

Options :

A : 4 x 6.4 TB NVMe flash cards on the High Capacity (HC) storage server

B : 4 x 6.4 TB NVMe flash cards on the database server

C : 8x 6.4 TB NVMe flash cards on the Extended (XT) storage server

D : No flash storage on the database server

E : 8 x 6.4 TB NVMe flash cards on the Extreme Flash (EF) storage server

Answer: A,E

Question 4

Which of the below is NOT a precaution that should be adhered to in order to ensure the site is safe and ready for

Options :

A : Do not use a flathead screwdriver to disconnect connector locks on LAN cables.

B :

Be sure that each grounding wire used for Oracle Exadata Rack is used exclusively for Oracle Exadata Rack.

C : Do not install Oracle Exadata Rack near a photocopy machine.

D : Do not place anything on top of Oracle Exadata Rack.

E : When using shared grounding, the grounding resistance must not be greater than 10 ohms.

F : Do not install Oracle Exadata Rack in a location that is exposed to direct sunlight.

Answer: C

Question 5

How is Exadata Secure RDMA Fabric isolation used in X9M-2 with virtualization enabled?

Options :

A :

With Secure Fabric isolation, each Storage Server runs multiple KVM guests each dedicated to a Database VM cluster using a dedicated network partition and VLAN ID. This provides security and isolation between multiple tenants or VM clusters.

B :

With Secure Fabric isolation, each Database VM Guest uses a dedicated network partition and VLAN ID for client networking between application servers. This improves security by preventing man in the middle attacks.

C :

With Secure Fabric isolation, each Database VM Cluster uses a dedicated network partition and VLAN ID for Data Guard networking between the primary and disaster recovery Exadata racks. This improves security by isolating data guard traffic onto an encrypted network between data centers.

D :

With Secure Fabric isolation, each Database VM cluster uses a dedicated network partition and VLAN ID for cluster networking between the database servers in the VM Cluster. This provides security and isolation between multiple tenants or VM clusters.

Answer: D

Confidently Practice Online with Free 1Z0-902 Exam Cram

Buying Options: