Question 1

You want to monitor how a large production table is accessed. Especially, you are interested to see how the

access on that particular table leverages the benefits of the Exadata Platform.

Which two actions are NOT appropriate for that purpose?

Options :

A :

YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.

B :

You query v$segment_statistics and filter for the Object ID of your table from dba_objects and the the column STATISTIC_NAME='optimized physical reads'.

C : You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.

D :

You run the CellCli-command list activerequest , filtering for the attributes ioReason and objectNumber, that you specify as 'Smart Scan' and the Object ID of your table from DBA_OBJECTS.

Answer: A,C

Question 2

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

Question 3

Which three statements are true about the CELLCLI command?

Options :

A : It can execute commands on multiple storage servers in parallel.

B : It has command-line history.

C : It requires root privileges to create CELLDISKS and GRIDDISKS.

D : It can be executed on storage servers.

E : It can be executed using the DCLI utility.

Answer: B,D,E

Question 4

You are monitoring PMEM cache to see if it is being used effectively with RDMA. Which two of these sources contain information about the RDMA I/O statistics?

Options :

A : PMEM Cache Space Usage section in AWR Report

B : PMEM Cache User Reads section in AWR Report

C : Database lOs section in AWR Report

D : Database Statistics (v$ View)

E : Exadata Metrics (LIST METRICCURRENT)

Answer: B,E

Question 5

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

Free 1Z0-902 Mock Exam – Practice Online Confidently

Buying Options: