Oracle Exadata X3 and X4 Administration (1Z0-027) Free Practice Test

Question 1

Consider the fiollowing sequence ofi CELLCLI commands and SQL statements:

All CELLCLI commands and SQL statements are executed successfiully without warnings.
Which statement is true about the I/O perfiormance ofi the DATA01 ASM diskgroups?

A. The DATA02 ASM diskgroup has better perfiormance because the DATA02 diskgroups was created first.

B. The DATA01 diskgroups has better perfiormance because the DATA01 griddisks were created first.

C. The perfiormance ofi both diskgroups is balanced because they are created on interleaved griddisks.

D. The DATA01 diskgroup has better perfiormance because the DATA01 griddisks are created on interleaved cell disks.

Correct Answer: B

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

Question 2

Which two are true about Smart Scan?

A. Some joins can be offloaded to the storage servers.

B. A query rewrite may occur to a container table stored Exadata, and it will always benefit firom Smart Scan.

C. All joins can be offloaded to the storage servers.

D. a query rewrite may occur to a container table stored in Exadata but will never benefit From Smart scan.

E. It is possible to offload single row fiunctions to the storage servers.

F. Column projection does not contribute to the perfiormance benefit ofi Smart Scan

Correct Answer: A,E

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

Question 3

Identifiy three valid configuration options that can be implemented during the initial configuration process ofi a new
Database Machine by using the Exadata Deployment Assistant

A. database character set

B. O/S owner mode (standard O/S authentication or role-separated O/S authentication)

C. size ofi the DBFS diskgroup

D. size ofi the RECO ASM diskgroup

E. RDBMS DBA group name

Correct Answer: B,D,E

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

Question 4

Which three fiactors should you consider when choosing a method fior migrating a database to the Database Machine?

A. Type ofi database workload

B. Endian fiormat ofi the source database

C. ASM attributes and allocation unit (AU) size ofi the diskgroups used by the source database

D. Number ofi tablespaces in the source database

E. Size ofi the source database

Correct Answer: A,B,E

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

Question 5

Which two communication methods are used by which components in the Enterprise manager Architecture fior the
Database Machine?

A. SNMP traps fior alerts are sent by the storage server MS process to the storage server ILOM

B. SNMP traps fior alerts are sent by the storage server MS process to the enterprise Manager agent

C. SNMP traps fior alerts are sent by the storage server ILOM to the Enterprise Manager agent.

D. SNMP traps fior alerts are sent by the storage server ILOM to the storage server RS process.

E. SNMP traps fior alerts are sent by the storage server ILOM to the storage server MS process

Correct Answer: B,E

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

Question 6

Which two may act as building blocks fior the creation ofi two or more griddisks residing on the same physical device
and which have more balanced perfiormance characteristics?

A. griddisk on hard drive-based intervleaved celldisks.

B. griddisk on Flash-base celldisks.

C. griddisk on hard drive-based celldisks consumed by ASM when creating diskgroups using ASM-based intelligent
Data Placement (IDP)

D. griddisk on hard drive-based non-interleaved celldisks.

Correct Answer: A,B

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

Question 7

You plan to migrate an existing production database supporting online transaction processing (OLTP) workloads to the
Exadata Database Machine. The database currently supports an application requiring fiast response times, which
satisfies stringent requirements, and most ofi the application queries use index access to the tables in the application
schema.
For which case would you consider dropping indexes to allow Smart Scans to occur?

A. Drop non-constraint Indexes ifi Smart Scan perfiorms better than any index scans on the corresponding table.

B. Drop non-constraint indexes ifi Smart Scan perfiorms better than index unique scans on the corresponding table.

C. Drop non-constraint indexes ifi Smart Scan occurs instead ofi an index access path on the corresponding table.

D. Drop non-constraint indexes ifi Smart Scan perfiorms better than index range scans on the corresponding table.

Correct Answer: A

Question 8

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

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

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

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

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

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

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

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

Correct Answer: B,E,G

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

Welcome to TestSimulate

Oracle Exadata X3 and X4 Administration (1Z0-027) Free Practice Test