Oracle Exadata X3 and X4 Administration : 1Z1-027

A table in one ofi your database schemas contains only varchar, number, and date data types fior the columns.
Which three operations can be offloaded to the Exadata storage servers when doing a smart scan against this table, ifi
no other situations arise that prevent Smart Scan firom occurring?

• A. Hash join filtering
• B. Predicate filtering
• C. Virtual column filtering
• D. Column filtering
• E. Sort merge join filtering
• F. Nested loop Join filtering

You have configured a multi-rack Database Machine with two X3-8 fiull racks all in a single cluster and storage grid.
Which two are true regarding the servers on which Enterprise manager agents must be deployed in order to monitor
all components ofi the multi-rack Database Machine?

• A. On all storage servers in all racks
• B. On at least two storage servers in the first rack
• C. On only one database server in the first rack
• D. On only one database server in second rack
• E. On at least two storage servers in the second rack
• F. On all database servers in the first rack
• G. On all database servers in second rack

Your customer wants you to partition the database and storage grids in his X3-2 fiull rack, creating database clusters and two storage grids.
One cluster will be used fior production and should consist ofi 6 databases servers and 11 cells firom the first storage grid.
The other cluster will be used fior test and development, and should consist ofi 2 database servers and 3 cells firom the second storage grid.
The storage must be partitioned so that the cells are visible only to the appropriate database servers based on the description above.
What must be done to achieve this?

• A. Edit the CELLIP.ORA file on each database server to contain IP addresses ofi database servers which are allowed access to specific cells in the same storage grid.
• B. Configure Exadata realms using Oracle ASM scoped security mode.
• C. Edit the CELLIP.ORA file on each database server to contain IP addresses ofi cells in the storage grid associated with cluster to which that database server belongs.
• D. Edit the CELLIP.ORA file on each cell to contain IP addresses ofi database servers in the database server grid that are associated with the storage grid to which that cell belongs.
• E. Edit the CELLINIT.ORA file on each database server to contain IP addresses ofi cells in the storage grid associated with the cluster to which that database server belongs.
• F. Configure Exadata realms using Database scoped security mode.

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 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.
• D. 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.
• E. 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%.

Which three statements are true about the initial storage configuration after the standard deployment ofi a new
database Machine?

• A. There is a firee space available on the hard disks inside the database servers fior possible extension ofi the /u01 file
  system.
• B. The Data_<DBM_Name> and RECO_<DBM_Name> ASM diskgroups are built on part ofi the interleaved griddisks.
• C. There is firee space available on the flashdisk inside the Exadata storage servers fior possible use as flash-based
  griddisks.
• D. The Data_<DBM_Name> and RECO_<DBM_Name> ASM diskgroups are built on top ofi the non-interleaved
  griddisks.
• E. There is no firee disk space available on the hard disk inside the database servers fior possible extensions ofi the /u01
  file system.
• F. There is no firee disk available on the flashdisk inside the Exadata storage servers fior possible use as flash-based
  griddisks.