Ensurepass

QUESTION 31

Which two statements are true about enabling write-back flash cache?

 

A.

When enabling write-back flash cache in a non rolling manner, it is important to ensure that asmdeactivatonoutcome is set to YES and asmModestatus is set to ONLINE for all grid disks.

B.

Before using write-back flash cache, you need to verify the minimum required versions.

C.

Before write back-flash cache is enabled, you need to drop the Flash Cache first.

D.

The setting flashCacheMode should be set to writeback by updating cellinit.ora and restarting cellsrv.

E.

When enabling write-back flash cache in a rolling manner, dcli should be used to inactivate the grid disks on all cells first.

 

Correct Answer: BC

Explanation:

B: Exadata storage version 11.2.3.2.1 is the minimum version required to use this write back flash cache option.

C: Steps for Enabling Write back flash cache:

First of all, you don’t need the stop CRS or database (This is ROLLING method) ,you can do it cell by cell.

* drop flashcache

* Be sure asmdeactivationoutcome is YES is before disabling grid disk

 

 

QUESTION 32

Identify two reasons why using external tables for high performance data loads on Exadata is more advantageous than SQL*Loader.

 

A.

Transformations can be applied directly on the file data using SQL or PL/SQL constructions.

B.

External tables allow transparent parallelization inside the database.

C.

Parallelizing loads with external tables enables more efficient space management.

D.

External tables can take advantage of storage indexes to speed up data loads.

 

Correct Answer: C

Explanation:

Parallelizing loads with external tables enables a more efficient space management compared to SQL*Loader, where each individual parallel loader is an independent database sessions with its own transaction.

 

 

 

 

 

QUESTION 33

You are calculating the storage capacity that your customer will require on their ZFS Backup Appliance. Identify the set of factors that will affect this calculation.

 

A.

database size, full/incremental cycle, RPO (Recovery Point Objective), and RTO (Recovery Time Objective)

B.

database size, retention period, RPO (Recovery Point Objective), and compression

C.

database size, full/incremental cycle, compression, and retention period

D.

database size, compression, and backup window

E.

full/incremental cycle, retention period, and ZFS Backup Appliance model

 

Correct Answer: C

Explanation:

The Sun ZFS Backup

Appliance has extremely fast backup and restore throughputs, ensuring that backup windows and recovery time objectives (RTOs) are met by providing timely recovery in the event of a disaster

Incorrect:

Not A, Not E: compression is a factor

 

 

QUESTION 34

Which three migration options are available when you migrate a database from the Big Endian format system to Exadata?

 

A.

Data Pump Export and Import

B.

transportable database

C.

transportable tablespaces

D.

Data Guard

E.

Insert as Select

 

Correct Answer: BCD

Explanation:

Methods at a Glance:

* Data Guard Physical Standby

* Transportable Database (Note:732053.1)

* Transportable Tablespace (TTS)

 

 

QUESTION 35

Identify two ways to reduce the risks associated with the software updates that are performed on a production Exadata system.

 

A.

Patch all systems at once instead of one at a time.

B.

Test on an Exadata system that is identical to the production system first.

C.

Updating an engineered system has no risk.

D.

Patch on the standby system first by using Data Guard Standby First Patch Apply.

E.

Create a system-wide firmware and software snapshot first.

 

Correct Answer: BD

Explanation:

Patch Installation and Testing

Guidelines

1. Review patch documentation

README and referenced Support Notes

2. (B) Validate in test environment

Verify patch installation (HealthCheck Note 1070954.1)

Verify functionality and performance

Automate

Define and test fallback plans

3. Apply in production environment

(D) Data Guard Standby-First Patch Apply

Monitor for regressions

Support Note 1262380.1

 

 

QUESTION 36

Which two DML operations will add rows compressed by Hybrid Columnar Compression (HCC) to a table that is created to use HCC?

 

A.

INSERT

B.

insert with an append hint

C.

UPDATE

D.

CREATE TABLE AS SELECT

 

Correct Answer: BD

Explanation:

To maximize storage savings with Hybrid Columnar Compression, data must be loaded using data warehouse bulk loading techniques. Examples of bulk load operations commonly used in data warehouse environments are:

* Insert statements with the APPEND hint

* Parallel DML

* Direct Path SQL*LDR

* Create Table as Select (CTAS)

 

Incorrect:

Not A, Not C: DML operations (INSERT/UPDATE) against a Hybrid Columnar Compressed table/partition can reduce the overall compression savings over time since data INSERTED/UPDATED via DML operations will not be compressed to the same ratio as data that is bulk loaded.

 

 

QUESTION 37

A control file tracks the physical components of a database. It is the root file that the database uses to find all the other files used by the database. Because of the importance of the control file, Oracle recommends that the control file be __________?

 

A.

size constrained, to prevent size overruns

B.

multiplexed, or have multiple identical copies

C.

stored on an HA USB Drive, to ensure that it does not get overwritten

D.

managed by EM12c, to ensure proper maintenance

 

Correct Answer: D

 

 

QUESTION 38

Which statement is true about the patching features provided in Platinum Services?

 

A.

Patching services are available for the full software stack up to twice per year.

B.

Patching support includes Exadata, Exalogic, and Database Appliance.

C.

Rolling window and complete down time approaches are two options to patching.

D.

Platinum covers Exadata storage software and firmware patching, but the customer must perform database patching.

 

Correct Answer: D

Explanation:

* Patch Deployment: Oracle Platinum Services also includes patching services in which Oracle applies patches to covered systems four times (not A) per year via the Oracle Advanced Support Gateway. We work collaboratively with customers to assess, analyze, plan and deploy updates and patches to mitigate risks and complications. Through this continuous improvement, customers can experience greater system performance, availability, and security.

* Not B: Oracle Platinum Services provides enhanced support for high availability and performance to Oracle Premier Support customers running certified configurations of Oracle Exadata Database Machine, Oracle Exalogic Elastic Cloud, or Oracle SuperCluster–at no additional cost.

 

 

QUESTION 39

The Exadata compute node, exadbs04, has been having issues for some time. The server had to be repaired and you just received a new server. Your LVM snapshot was corrupt and now the compute node must be re-image with an Oracle Support installation image. Which three tasks would you need to perform to re-image the compute node?

 

A.

Mount the LVM backup image across the network and recover the system.

B.

Remove exadbs04 from the RAC cluster and all associated Oracle Homes from the central inventory.

C.

Create a CELLBOOT USB Flash Drive using an external USB drive.

D.

Reboot the new server using a bootable recovery image from the external USB drive.

E.

Reconfigure all site-specific settings (host name, IP addresses, NTP server, and so on).

 

Correct Answer: BCE

Explanation:

C: Exadata provides a way for you to create your own CELLBOOT USB. All you have to is plug-in a USB disk which should be at least 1 GB and run the tool:

$ /opt/oracle.SupportTools/make_cellboot_usb

Exadata turns your USB disk into a bootable disk of active image of your system.

 

 

QUESTION 40

Identify the three values to which the cell_flash_cache attribute can be set.

 

A.

read

B.

WRITE

C.

KEEP

D.

DEFAULT

E.

NONE

 

Correct Answer: CDE

Explanation:

There are three values the CELL_FLASH_CACHE attribute can be set to.

DEFAULT specifies the cache used for a DEFAULT object is automatically managed as described in the previous section. NONE specifies that the object will never be cached. KEEP specifies the object should be kept in cache.

Note: The CELL_FLASH_CACHE can be assigned to a database table, index, partition and LOB column.

 

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 …

Comments are closed.