[Free] Download Latest (March 2016) Oracle 1Z0-485 Real Exam 21-30

Ensurepass

QUESTION 21

Which Exadata feature uses Flash as a parallel write cache to Disk Controller Cache?

 

A.

Exadata DRAM

B.

InfiniBand network cache

C.

high performance SAS disks

D.

Smart Flash Log

E.

Hybrid Columnar Compression

 

Correct Answer: D

Explanation:

Smart Flash Logging takes advantage of the flash memory in Exadata storage to speed up log writes.

 

 

QUESTION 22

Identify the correct steps required to upgrade a 1/8th rack of Exadata to a 1/4th rack.

 

A.

Remove the doors of the 1/8th rack.

Add the new servers.

Cable the Database Servers in the rack.

Cable the Exadata Storage Servers in the rack.

Close the rack.

B.

Activate all cores by using a software command.

Activate all hard drives and flash drives.

Create the grid disks.

Expand the Oracle ASM diskgroups.

Review the new configuration.

< font style="font-size: 10pt" color="#000000">C.

Remove the doors of the 1/8th rack.

Add an additional Sun Datacenter InfiniBand Switch.

Add the new servers.

Cable the Database Servers in the rack.

Cable the Exadata Storage Servers in the rack.

Close the rack.

Configure the new hardware.

D.

Activate all cores by using a software command.

Activate all hard drives and flash drives.

 

Correct Answer: B

Explanation:

Not A: no need to remove doors.

Not C: No additional Infiband Switch needed.

 

Note:

Database Machine Upgrades

 

clip_image002

 

Database Machine Components and Upgradeability

 

clip_image004

 

 

QUESTION 23

When an Exadata Storage Server hard disk failure alert is received, what manual action must you take to restore the system to full redundancy?

 

A.

Replace the disk and run MegaCLI to rebuild the degenerate mirror.

B.

No manual action is required because Automatic Storage Management (ASM) fast mirror resync is automatic

C.

No manual action is required because ASM rebalancing is automatic.

D.

Replace the disk and manually copy the mirror extents to the new drive.

E.

Run RMAN REPAIR FAILURE.

 

Correct Answer: C

Explanation:

As soon as the Hard Disk failure is noticed by the MS (Management Server) background process on the Cell, it will raise an alert that will also be published to Grid Control, if configured. Immediately, due to Pro-Active Disk Quarantine, the ASM-, Grid- and Celldisks get dropped. ASM rebalancing is triggered. You as the responsible Admin notice the alert and order a replacement Disk resp. use a Spare Disk to plug it into the Cell after you plugged out the damaged one. The Cell can stay online, because the Hard Disks are hot-pluggable.

No further administrative work to be done, typically.

 

 

QUESTION 24

In looking to improve query performance for your Data Warehouse, select the best way that Exadata’s Flash Cache feature can be leveraged?

 

A.

Enable Smart Flash Log.

B.

Execute alter table … cell_flash_cache=keep on heavily scanned tables.

C.

Enable Write Back Flash Cache.

D.

Create an ASM diskgroup on Flash Cache and move the indexes from disk to Flash.

 

Correct Answer: B

Explanation:

In earlier releases, database administrators had to mark an object as KEEP to have it cached in flash cache for large scan workloads. This feature primarily benefits table scan intensive workloads such as Data Warehouses and Data Marts. Random I/Os such as those performed for Online Transactional Processing (OLTP) continue to be cached in the flash cache the same way as in earlier releases. Note: With the Exadata Storage Server Software 11.2.3.3.0 and above, the Exadata Smart Flash Cache software automatically caches objects read, in large table scans, in the flash cache based on how frequently the objects are read. Previously, the default behavior was to bypass the flash cache for such large sequential scans.

 

 

QUESTION 25

Which two statements appropriately describe the backup and recovery procedures on Exadata?

 

A.

Cell software backup is automatic and cell recovery is accomplished by using a rescue procedure.

B.

Data stored in a database is backed up and restored by using CellCLI commands.

C.

Database server software backup is automatic and recovery is accomplished by using a rescue procedure.

D.

Data stored in a database is backed up and restored by using RMAN commands.

E.

Cell software backup is performed through CellCLI and cell recovery is accomplished by using a rescue procedure.

 

Correct Answer: AD

Explanation:

A: Your Exadata Storage Servers do not need to be backed up; Exadata automatically backs these up using a self-maintained internal USB drive.

D: Backup your Oracle databases using Oracle RMAN

 

 

QUESTION
26

Storage indexes are unique to the Exadata Database Machine and their primary goal is to reduce the amount of I/O required to service I/O requests for Exadata Smart Scan. Put the following steps in order:

 

1. The Exadata cell services software conducts I/O requests on I MO storage regions.

2. cellsrv checks the high and low values, and determines the storage region does not contain any values meeting the predicate.

3. The database is started.

4. Physical I/O to the region is bypassed if the query selection falls outside the high/low storage index storage.

5. A query is issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=1500.

6. A subsequent query is Issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=2234.

7. MYOBJ_STATE’S region index is populated with high and low values for the OBJECT_ID column during the I/O request.

 

A.

3. 7, 5, 2, 1, 6, and 4

B.

3, 7, 1, 5, 6, 2, and 4

C.

3, 6, 1. 7, 2, 5 and 4

D.

3, 5, 1, 7, 6, 2. and 4

 

Correct Answer: D

Explanation:

3. The database is started.

5. A query is issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=1500.

1. The Exadata cell services software conducts I/O requests on I MO storage regions.

7. MYOBJ_STATE’S region index is populated with high and low values for the OBJECT_ID column during the I/O request.

6. A subsequent query is Issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=2234.

2. cellsrv checks the high and low values, and determines the storage region does not contain any values meeting the predicate.

4. Physical I/O to the region is bypassed if the query selection falls outside the high/low storage index storage.

Note:

Example:

Step 1 (step 5 in answer): The first time that each cell’s cell services software issued an I/O request to access extents from the D14.MYOBJ_UNCOMP table, Exadata populated a region index for each storage index with the high and low values found for the OBJECT_ID column, based on the WHERE OBJECT_ID BETWEEN 100 AND 200 query predicate.

Step 2 (step 6 in answer) : Subsequent queries against this table generated an iDB message instructing Exadata’s cell services software to read the same sets of extents as the first query, but in this case the region indexes would have been populated based on the I/Os read from the first query.

Step 3 (step 2 in answer) Prior to issuing a physical disk read, cellsrv checks the high and low values stored in the region index and if it determines that a storage region does not contain any values meeting the query predicate, bypasses the physical I/O to the region.

 

 

QUESTION 27

Which statement is true about Oracle compression?

 

A.

A non-partitioned table can use Advanced Compression and Hybrid Columnar Compression concurrently.

B.

A partitioned table can define the use of Advanced Compression or Hybrid Columnar Compression for each partition.

C.

Hybrid Columnar Compression can be defined for a single column.

D.

A partitioned table can use only Advanced Compression or only Hybrid Columnar Compression.

 

Correct Answer: CD

Explanation:

C: Tables are organized by column and compressed. This makes it much easier to get similar values together, which enhances the compression greatly.

D: It is recommended that HCC be enabled on tables or partitions with no or infrequent DML operations. If frequent DML operations are planned on a table or partition, then the Oracle Advanced Compression Option is better suited for such data.

 

 

QUESTION 28

Your customer would like to use DBFS in their Exadata environment. They are asking you for the key characteristic of DBFS on Exadata.

 

A.

DBFS in an Exadata environment is faster than an NFS mount system because of the Smart Scan performance gains.

B.

Tens of thousands of files are the perfect use case for DBFS on Exadata.

C.

DBFS offers tremendous I/O bandwidth.

D.

None of the above

 

Correct Answer: B

 

 

QUESTION 29

What are three ways to be informed of an Exadata Storage Server disk failure?

 

A.

review of the output of list alerthistory

B.

review of the output of select status from vSdatafile

C.

review of the ILOM log

D.

alert notifications through email when SMTP notification is configured

E.

alert notifications in the Enterprise Manager Exadata Plug-In

F.

review of database server iostat output

 

Correct Answer: ADE

Explanation:

A: A disk status change would be associated with an entry in the storage cell alerthistory.

D: The Cell Alert Delivery Configuration Worksheet allows you to provide SMTP details to allow for e-mail communication of various cell alerts and failures.

Incorrect:

Not F: Use the iostat command to report statistics about disk input and output, and to produce measures of throughput, utilization, queue lengths, transaction rates, and service time.

 

 

QUESTION 30

Which two statements are true about CellCLI?

 

A.

Using a CellCLI command, you can change the SNMP subscribers or add multiple SNMP subscribers.

B.

Using CellCLI, you can stop and start the ASM instances that are using the grid disks on the Exadata storage cell.

C.

With a simple CellCLI command, you can synchronize changes to all the storage cells in the Exadata realm.

D.

Using a CellCLI command, you can see whether grid disks are being used by ASM or not.

E.

You cannot use CellCLI to gather the serial numbers of physical disks.

 

Correct Answer: BD

Explanation:

B: * Making a grid disk inactive effectively offlines its associated ASM disk.

CellCLI> alter griddisk PRORECO_CD_11_cell01 inactive

GridDisk PRORECO_CD_11_cell01 successfully altered

* The command will wait until the ASM disk becomes offline. If you want the prompt to come back immediately without waiting, you can use nowait clause.

CellCLI> alter griddisk PRORECO_CD_11_cell01 inactive nowait

You can make it active again:

CellCLI> alter griddisk PRORECO_CD_11_cell01 active

GridDisk PRORECO_CD_11_cell01 successfully altered

Incorrect:

Not E: CellCLI> list physicaldisk detail

output include:

physicalSerial: XXXXXX

 

Free VCE & PDF File for Oracle 1Z0-485 Real Exam

Instant Access to Free VCE Files: CompTIA | VMware | SAP …
Instant Access to Free PDF Files: CompTIA | VMware | SAP …

This entry was posted in 1Z0-485 Real Exam (March 2016) and tagged , , , , , , , . Bookmark the permalink.