1Z1-027試験無料問題集（72題）「Oracle Exadata X3 and X4 Administration 認定」

出題：1

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. No I/Os in any category or firom any database may use flashing or flashcache because the objective is off.

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. 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.

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.

正解：B,C 解答を投票する

出題：2

Which two are true about the use ofi DBFS in a Database Machine environment?

A. DBFS must be used to have a POSIX compliant shared storage solution that is accessible firom the database servers
on a Database Machine.

B. DBFS must be used to bulk load data into a database on the Database Machine ifi the staging area requires Exadata
based shared storage.

C. DBFS must be used to bulk load data into a production database on the Database Machine.

D. DBFS must be used to have a POSIX-compliant Exadata-based shared storage solution.

E. DBFS must use the DBFS_DG diskgroup fior any DBFS store.

正解：C,E 解答を投票する

出題：3

Your Database Machine has a large database with some very large tables supporting OLTP workloads.
High volume Insert applications and high volume update workloads access the same tables.
You decide to compress these tables without causing unacceptable perfiormance overheads to the OLTP application.
Which three are true regarding this requirement?

A. The compression is perfiormed on the storage servers when using compress fior oltp in an Exadata environment.

B. Using 'compress fior oltp' will compress the data more than ifi using Hybrid Columnar Compression when specified
with compress fior archive low.

C. The compression method compress fior archive high is the worst fit fior this requirement.

D. The compression is perfiormed on the database servers when using 'compress fior oltp' in an Exadata environment.

E. Using 'compress fior oltp' will compress the data less than ifi using Hybrid Columnar Compression when specified
with compress fior query low.

正解：C,D,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

You are evaluating the perfiormance ofi a SQL statement that accesses a very large table, and have run the fiollowing
query producing the output shown:

For which two reasons would the; "physical read total bytes" statistic be greater than the "cell physical IO bytes
eligible fior predicate offload" statistic?

A. There is an index on the column used in the where clause, causing "cell multiblock physical reads" to be requested
by the database instance, resulting in additional I/O fior blocks in the cells.

B. The table is an indexed clustered table, causing "cell single block physical reads" to be requested by the database
instance, resulting in additional I/O fior blocks in the cells.

C. There are migrated rows in the table, causing some "cell single block physical reads" to be requested by the
database instance, resulting in additional I/O fior blocks in the cells.

D. There is an uncommitted transaction that has modified some ofi the table blocks, causing some "cell single block
physical reads" to be requested by the database instance, resulting in additional I/O fior block in the cells.

E. The table is an IOT and has an overflow segment, causing "cell multiblock physical reads" to be requested by the
database instance, resulting in additional I/O fior block in the cells.

正解：B,E 解答を投票する

出題：5

You are planning the physical installation ofi two fiull rack Database Machines and two fiull-rack expansion racks. The
fiour racks will be combined into one multi rack system.
Which are the two guidelines fior installing this configuration in your data Center?

A. All racks must be placed in such a way that the exhaust air ofi one rack does not enter the air inlet ofi another

B. All racks must be placed side by side with no space between them.

C. All racks must be isolated firom each other with at least one meter between them.

D. All Database Machines must be placed side by side with no space between them.

E. Expansion Racks must be placed side by side at least one meter apart.

F. Racks may be placed as required in the machine room.

G. All Expansion Racks must be placed side by side with no space between them.

正解：A,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

Which two statements are true about the use ofi direct path loads when selecting firom external tables in a database
on a Database Machine?

A. CREATE TABLE . . . AS SELECT statements, which select firom external tables, attempt to use in direct path loading
automatically.

B. INSERT INTO . . . SELECT FROM statements, executed serially, which select firom external tables, are unable to use
direct path loading.

C. CREATE TABLE . . . AS SELECT statements, which select firom external tables, require the APPEND hint to use direct
path loading.

D. INSERT INTO . . . SELECT FROM statements, executed serially, which select firom external tables, require the
APPEND hint to use direct path loading.

正解：A,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

Which tool will provide you with diagnostic infiormation fior all the software log, trace files, and OS infiormation on
Database Machine?

A. oswatcher

B. diagget.sh

C. adrci

D. dbmcheck.sh

E. Enterprise Manager

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

1Z1-027試験無料問題集「Oracle Exadata X3 and X4 Administration 認定」