Oracle Exadata X3 and X4 Administration - 1Z1-027 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

You have two very large databases supporting OLTP workloads which run on multiple small-blade style servers in a
cluster and which require optimal latency fior I/O.
You plan to migrate them to a Database Machine once a capacity planning exercise is finished.
The database backup strategy requires that backups are written directly to media.
High availability requirements state that you must be able to survive node fiailures at any time.
Which three Database Machine components or fieatures would you recommend to support these requirements?

A. High perfiormance disks in the Database Machine B. Use ofi write back flash cache C. A high capacity expansion fiull rack D. A high perfiormance expansion fiull rack E. Use ofi smart flash logs F. High capacity disks in the Database Machine

Discussion 0

Correct Answer: B,E,F Vote an answer

Question 2

Last weekend, an Exadata storage server flashdisk entered the predictive fiailure state.
The flashdisk is used by the flashcache and has a griddisk which is a member ofi a normal redundancy diskgroup.
Identifiy the fiour steps you must perfiorm to replace this flashdisk.

A. Drop the flashcache on the cell and re-create it using all flashdlsks. B. Power up the cell containing the replaced flashdlsk and activate all grlddlsks. C. Identifiy the griddisk on the predictive fiailure flashdisk and drop it firom the associated ASM diskgroup D. Create a new griddisk on the replaced flashdisk. E. Drop the flashcache on the cell and re-create it using all but the predictive fiailure flashdisk. F. Replace the predictive fiailure flashdisk. G. Verifiy that the griddisk located on the predictive fiailure flashdisk has been successfiully dropped firom the
associated ASM diskgroup. H. Add the griddisk back into the ASM diskgroup to which it belonged. I. Safiely power off the cell containing the predictive fiailure flashdlsk.

Discussion 0

Correct Answer: B,C,F,I Vote an answer

Question 3

Identifiy two valid reasons fior creating multiple griddisks on a Single celldisk.

A. To segregate storage into multiple pools that can be assigned to different databases B. To enable disk mirroring fior the system area C. To fiacilitate normal or high redundancy ASM diskgroups D. To segregate storage into multiple pools that can be assigned to different resource consumer groups in the same
database. E. To segregate storage into multiple pools with different perfiormance characteristics

Discussion 0

Correct Answer: A,E Vote an answer

Question 4

You have altered an index supporting a constraint to be invisible on a large read only data warehouse table, to
determine it Smart Scan operations will be fiast enough to satisfiy your perfiormance requirements.
Given the results ofi your testing, you consider dropping the index.
Which two statements are true?

A. You may retain the index, and leave it as invisible, because this is enough fior the constraint to be recognized. B. You may drop the index and make the constraint invisible, because this is enough fior the constraint to be enfiorced. C. You must retain the index and make it visible again fior the constraint to be enfiorced. D. You must retain the index and set the constraint to DISABLE NOVALIDATE RELY to enfiorce the constraint E. You may drop the index and use a constraint with the DISABLE NOVALIDATE RELY flags

Discussion 0

Correct Answer: C,D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 5

You have a partitioned database grid on an X3-2 fiull rack with two fiour-node RAC clusters called CLUSA and CLUSB.
The storage grid, however, has not been partitioned.
Which files on which servers must be modified after connecting an Exadata storage fiull expansion rack to your X3-2
Exadata Database Machine on the InfiniBand network so that the cells on the expansion rack are added to the storage
grid?

A. The CELLIP.ORA files on the database servers in CLUSB B. The CELLINIT.ORA files on the database servers in CLUSB C. The CELLINIT.ORA files on database servers in CLUSA D. The CELLIP.ORA files on the database servers in CLUSA E. The CELLIP.ORA files on all existing and newly added Exadata storage servers.

Discussion 0

Correct Answer: A,D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 6

You installed ASR Manager on a stand-alone server and configured Auto Service Request (ASR) fior your Database
machine and its assets.
Which three statements are true about this configuration?

A. Simple Network Management Protocol (SNMP) traps received by ASR Manager are fiorwarded to Enterprise
Manager. B. Simple Network Management Protocol (SNMP) traps are used to send notifications firom database servers to ASR
Manager. C. Simple Network Management Protocol (SNMP) traps are used to send notifications firom storage servers to ASR
Manager. D. When a component fiault occurs, fiault telemetry is securely transmitted to Oracle via HTTPS. E. Simple network Management Protocol (SNMP) traps are used to send notification firom Enterprise manager to ASR
Manager. F. When a component fiault occurs, fiault telemetry is securely transmitted to Oracle via Simple Network Management
Protocol (SNMP).

Discussion 0

Correct Answer: B,C,F Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 7

Which two are true concerning the allocation ofi I/O resources by the IORM within the CELLSRV process?

A. Control File I/O is considered part ofi the SYSTEM resource Consume group by IORM. B. Database Writer I/O is managed automatically at normal priority by IORM. C. Log Writer I/O to the Smart Flash Log is managed automatically at high priority by IORM. D. Database Writer I/O is considered part ofi the SYSTEM resource consumer group by IORM. E. Log Writer I/O to the Smart Flash Log is considered part ofi the SYSTEM resource consumer group by IORM. F. Control File I/O is managed automatically at high priority by IORM.

Discussion 0

Correct Answer: B,F Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 8

You are examining the existing IORM configuration on the cells ofi Database Machine, to see ifi they require my
modifications based on recent changes to various workloads.
All seven cells in your X3-2 halfi-rack shown the fiollowing:

Which two are true about I/O to the cells using this plan?

A. I/O requested in the interactive category may use flashdns ifi the I/O is firom the sales or finance databases, and
these I/O requests are guaranteed to get 90% ofi the I/O ifi the enough I/Os are issued in this category. B. I/O requests firom the sales database may use flashing regardless ofi the I/O category. C. I/O requests in the batch category may use flashcache ifi the I/O is firom the sales finance database, and these I/O
requests are guaranteed to get 80% ofi the I/O ifi the interactive category I/Os use no more than 20%. D. No I/Os in any category or firom any database may use flashing or flashcache because the objective is off. E. I/O requests made by sessions in the marketing database may use flashing and flashcache ifi no other categories or
database or database are using flashing and flashcache at the same time.

Discussion 0

Correct Answer: B,C Vote an answer