Oracle Exadata X3 and X4 Administration - 1Z1-027 Exam Practice Test

Question 1

Your database Machine has the exachk utility pre-installed and you decide to use it periodically, to validate the
installation against Oracle's recommended best practices.
Which two actions could you take to do this?

A. Rut it once firom a database node and it will then perfiorm periodic monitoring automatically.

B. Use a cron job on a database node to run it at regular intervals.

C. Run it once on each cell and it will then perfiorm periodic monitoring automatically.

D. Use a cron job on each cell to run it at regular intervals.

E. Create a Job in Enterprise Manager to run the exachk utility at regular intervals.

Correct Answer: B,E

Question 2

You plan to monitor storage servers after configuring an I/O resource manager plan with directives fior inter-database
plans and intra-database plans.
Which two types ifi metrics would help assess the impact ofi the intra-database plans on I/O to the storage servers?

A. Smart Flash Cache I/O

B. Database I/O

C. Category I/O

D. Smart Flash Log I/O

E. Resource Consumer Group I/O

Correct Answer: B,E

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

Question 3

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

A. Ifi two consumer groups P and Q In the PROD database get 20% and 10% respectively ofi resource allocation, then
the percentage ofi I/O resource would be the same ifi they got 10% and 5% respectively, and the Interdatabase plan
has changed, provided that the category plan is unchanged, and consumer groups A and B are still mapped to the
same categories.

B. Ifi two consumer groups C and D In the PROD database get 10% and 15% respectively ofi resource allocation, then
the percentage ofi I/O resource would be the same ifi they still got 10% and 15% respectively and were remapped to a
different category by the DBA, provided that the category plans and Interdatabase plans are unchanged.

C. Log Writer I/O and Control File I/O are high priority I/O managed automatically by IORM.

D. Database Writer I/O is considered to be the highest priority I/O and is managed based on attributes ofi the IORM
plan.

E. Ifi two consumer groups A and B in the PROD database get 10% and 15% respectively ofi resource allocation, then
the percentage ofi I/O resource would be the same ifi they got 20% and 30% respectively, provided that the category
plans and inter database plans are unchanged, and consumer groups A and B are still mapped to the same category.

Correct Answer: A,C

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

Question 4

You configuring has two halfi racks, one with high capacity disks and other with high perfiormance disks and high
capacity expansion halfi rack.
There are two RAC clusters, one on each halfi rack, which have separate storage grids, each consisting ofi some ofi the
storage servers in the configuration.
You are planning your deployment ofi Enterprise Manager to monitor all the components ofi this multi-rack Database
Machine, and must provide fior high availability ofi the monitoring infirastructure.
Ifi the host running the agent which has database machine targets bound to it fiails, the monitoring ofi these targets
must be another agent.
Which two are true regarding the configuration used to support this?

A. A secondary agent may be deployed on a database server in a different cluster than the server hosting the primary
agent.

B. Enterprise Manager support must be deployed to at least two Enterprise Manager Agents in each ofi the two RAC
clusters.

C. A secondary agent must be deployed on a database server in the same cluster as the server hosting the primary
agent.

D. Enterprise Manager support must be deployed to all Enterprise Manager Agents in each cluster.

E. Enterprise manager support must be deployed to only one Enterprise Manager Agent in each cluster.

F. A secondary agent must be deployed on a database server in a different cluster than the server hosting the primary
agent.

Correct Answer: A,E

Explanation: Only visible for Actualtests4sure 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 all existing and newly added Exadata storage servers.

B. The CELLIP.ORA files on the database servers in CLUSA

C. The CELLINIT.ORA files on the database servers in CLUSB

D. The CELLINIT.ORA files on database servers in CLUSA

E. The CELLIP.ORA files on the database servers in CLUSB

Correct Answer: B,E

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

Question 6

You plan to migrate your Oracle Version 11.1.0.2 database to your Exadata Database Machine.
The database supports an online transaction processing (OLTP) workload and is currently hosted on a Little Endian
platform
Which two are the supported and appropriate migration methods to minimize downtime?

A. Migrate using Data Pump.

B. Migrate using ASM online migration.

C. Upgrade source database to 11.2.0 and migrate using a physical standby database.

D. Migrate using cross platform Transportable Database.

E. Migrate using GoldenGate.

Correct Answer: A,C

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

Question 7

Which three statements are true regarding the configuration ofi Auto Service Request (ASR) on your Database
Machine?

A. HTTPS connectivity must be enabled firom the ASK Manager host to the internet.

B. ASR Manager may be installed on any type ofi server running Oracle Solaris.

C. Oracle Solaris must be used on the server where ASK Manager is installed.

D. SMTP must be enabled on at least one database server.

E. ASR Manager must be installed on one ofi the database servers.

F. ASR Manager may be installed on any type ofi server running Oracle Linux.

G. Oracle Linux must be used on the server where ASR Manager is installed

Correct Answer: A,B,F

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

Question 8

Which three are true regarding the use ofi Storage Indexes?

A. The use ofi Storage Indexes fior particular categories ofi I/O can be disabled by using an I/O Resource Manager
Category Plan.

B. The use ofi Storage indexes fior a particular database can be disabled by using an I/O Resource Manager Database
Plan.

C. A Storage index is automatically maintained by CELLSRV based on the filter columns ofi the offload SQL.

D. Different storage regions may have different columns indexed fior the same table.

E. Storage Indexes occupy space in the Smart Flash Cache.

F. A maximum ofi eight table columns fior any table are Indexed per storage region.

Correct Answer: C,D,F

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

Oracle Exadata X3 and X4 Administration - 1Z1-027 Exam Practice Test

Latest Update

Useful Links

Contact Us