Online 1Z0-902 Practice Test

Question 1

You have been tasked with replacing a memory module of an Exadata Storage Server and need to power off the affected storage server. Which two commands must you execute to safely power off the storage server in an Exadata X9M Database Machine?

Options :

A : CeLLCLI> alter cell shutdown SERVICES all on the affected storage server

B : CeLLCLI> list GRIDDISK where status != 'inactive' on the affected storage server

C : 'crsct1 stop cluster -all' on one of the database servers

D :

CellCLI LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes' on the affected Storage server

E : CellCLI alter GRIDDISK all inactive on the affected storage server

F : shutdown -h now' on the affected storage server

Answer: E,F

Question 2

Which statement is FALSE about the OEDA command line interface (OEDACU)?

Options :

A : Add nodes to and remove nodes from a VM cluster.

B : Add or remove additional databases.

C : Resize Oracle ASM disk groups.

D : Support ZDLRA life cycle management operation.

E : Add or remove Oracle Database home directories.

F : OEDACU has Edit mode and Deploy mode.

Answer: D

Question 3

You are adding a disk expansion kit to a running Exadata X8M Database Machine's Database Servers, and have a filesystem layout that includes:

After running the following commands, which command needs to be run to add 20G of space to the filesystem mounted on /u01?

Options :

A : # lvextend -L +20G —verbose /dev/mapper/VGExaDb-LVDbOral

B : # xfs_growfs /uOl +20G

C : # resize2fs +20G /dev/VGExaDb/LVDbOral

D : # lvextend -L +20G —verbose /dev/VGExaDb/LVDbOral

Answer: A

Question 4

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 5

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

EXPERTY DESIGNED 1Z0-902 PRACTICE TEST