Oracle Exadata Database Machine 2014 Implementation Essentials v6.0 (1z0-485)

Page:    1 / 5   
Total 74 questions

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.

Answer : C,D

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.

Which statement is true about instance caging setup?

  • A. Instance caging is the right approach to make sure that database instances are not stealing memory from each other.
  • B. The CPU Resource Manager and IORM need to be enabled to make instance caging to work as expected.
  • C. Database instances need to be restarted to make changes to cpu_count effective.
  • D. For a system with 16 threads, the sum of cpu_count for all databases should not be higher than 32 to prevent oversubscribing
  • E. The parameter resource_manager_plan should be set.

Answer : D

Explanation: * In 11.2G there is new option called Instance Caging which enables to limit number of CPUs which can be seen/used by a database.
* Enabling Instance Caging
1. Manually set dynamic parameter cpu_count on instance level. As default this parameter is set to maximum number of cpu available on a hosts. alter system set cpu_count=2;
2. Enable any resource manager plan that manages CPU. Most easy is to turn on default
Oracle plan DEFAULT_PLAN.
alter system set resource_manager_plan=DEFAULT_PLAN;
* Provisioning CPU
There are generally 2 ways to distribute your CPU between databases
Partitioning sum of all CPUs assigned to all your databases equals number of CPUs on a host. Databases dont interfere with each other.
Over-provisioning sum of all CPUs assigned to all your databases is higher that number of CPUs on a host. Databases can impact on each other performance.

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.

Answer : B

What are the three customer options for hosting the Platinum Services Advanced Support

  • A. Install on Exadata Engineered System.
  • B. Provide individual x86 64-Bit gateway hardware.
  • C. Install in Oracle Virtual Machine with required hardware.
  • D. Install on Oracle Database Appliance.
  • E. Purchase the recommended x86 64-Bit gateway hardware from Oracle.

Answer : A,C,E

Explanation: Oracle provides a flexible model for deployment of the Oracle Advanced
Support Gateway via no charge software that can be
installed in three configurations:
1. On x86 customer provided servers;
2. On x86 servers purchased from Oracle;
3. Installed on Oracle Exalogic Elastic Cloud or Oracle SuperCluster systems.
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.

Which statement is true about Enterprise Manager 12c for Exadata?

  • A. EM Agents are installed on each database and storage node.
  • B. EM Agents should not be installed on Exadata. Remote monitoring is the best practice.
  • C. EM Agents can communicate to storage cells via SSH.
  • D. The Exadata Plug-In for monitoring switches is installed in each EM Agent.
  • E. Storage cells communicate directly to the EM Management Server via SNMP and/or SMTP.

Answer : D

Explanation: All the code required for monitoring the various Oracle Exadata hardware components has been bundled into the Oracle Exadata plug-in that is pushed to the agents running on the Oracle Exadata Compute (or Database) nodes. Once the plug-in is deployed on the compute nodes, the database machine is ready for discovery with Oracle
Enterprise Manager.
Not A: Since agents only run on the compute nodes it is important to assign specific agents to different Oracle Exadata components. Not B: Oracle Exadata Discovery in Oracle

Enterprise Manager 12c -

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.

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.

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

Answer : D

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

Answer : A,D,E

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

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.

Answer : B,D

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
Define and test fallback plans
3. Apply in production environment
(D) Data Guard Standby-First Patch Apply
Monitor for regressions

Support Note 1262380.1 -

Which two statements appropriately describe the backup and recovery procedures on

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

Answer : A,D

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

Which two actions are permitted with Exadata Database Machine?
48-port Gigabit Ethernet switch
B. installing a second Ethernet switch in the Exadata rack for client access network connectivity
C. replacing the Sun Data Center InfiniBand Switch 36-spine switch with an InfiniBand

Gateway Switch -
D. configuring a Linux active-active channel bonding on the database servers by using two
10-Gigabit Ethernet port
E. configuring a Fibre Channel over Ethernet (FCoE) protocol on database servers

Answer : A,C

Explanation: There are total two category of network switches used to prepare computing environment inside the rack.
* InfiniBand Switches - two models used depending on requirements
Sun Oracle 36-port InfiniBand Switch
Sun Oracle InfiniBand Gateway Switch
* Ethernet Switch - primarily for management purposes

Cisco Catalyst 4948 -
Common information that applies to both of these InfiniBand switches
Form Factor: One rack unit (1U) height

Power Supplies: Two -

Cooling Fans: Five -

IB Subnet Management: Yes -

Firmware Upgradeable: Yes -
Command Line Access: Yes. Via ssh and usb-serial access

Web Based Management: Yes -

SNMP Access: Yes -
As you might have figured out by now that the IB Gateway switch is almost like a super set of 36-port switch in terms of features and capabilities.
Not E: Since the Exadata hardware cannot be modified, it is not supported to add HBA cards to any of the Exadata servers. It is supported to present storage via the network ports on the database servers via NFS or iSCSI, although Fibre Channel over Ethernet (FCoE) is not supported.

Which three statements are true about Automatic Degree of Parallelism (Auto DOP) on

  • A. Auto DOP is an exclusive feature in Exadata, which allows the database optimizer to evaluate each statement and run it in parallel without special hints.
  • B. Auto DOP is disabled by default and must be enabled before SQL statements can take advantage of its features.
  • C. Auto DOP is enabled by default on Oracle 11gR2, allowing full use of its features. Parallelism based on the table's block counts.
  • E. SQL statements that take advantage of Auto DOP am be identified by using data from Oracle Automatic Workload Repository (AWR) or Enterprise Manager's Monitored SQL Executions page.

Answer : B,D,E

Explanation: B (not c): To enable the features in 11g Release 2, use the parallel_degree_policy parameter (by default this stuff is off - parameter is set to manual).
For Auto DOP, setting this to limited is sufficient. If you want more functionality (in-memory parallel processing and parallel statement queuing parallel_degree_policy should be set to auto).
Not A:
* What if you dont have Exadata? Chances are that if your system is large enough to warrant Auto DOP, it is similar enough to Exadata to behave nicely with this number.
* Auto DOP is only useful in systems with enough CPUs and disks to make concurrent parallel processing feasible. It was designed mostly for Exadata, or for systems of similar size. 48 CPUs and 84 disks sound like a nice start

Which two statements are true about Exadata memory capabilities?

  • A. X3-8 can be purchased in a Half Rack configuration with 2 TB of memory.
  • B. X3-2 memory can be expanded to 512 GB per node from 256 GB.
  • C. X3-2 memory can be upgraded to use Flash in the compute nodes.
  • D. X3-8 memory is fixed at 4 TB per a Rack.
  • E. X3-2 can be purchased in a Half Rack configuration with 256 GB per node.

Answer : D,E

Explanation: D: ORACLE EXADATA DATABASE MACHINE X3-8 features include:
160 CPU cores and 4 TB of memory for database processing

E: Database servers X3-2 -
A third generation was announced in 2012. Each Database Server with
2 x Eight-Core Intel Xeon E5-2690 Processors (2.9 GHz)
128 GB Memory (expandable to 256GB)

What are two impacts of selecting high redundancy over normal redundancy for your diskgroups?

  • A. High redundancy provides more usable storage.
  • B. Normal redundancy provides more usable storage.
  • C. High redundancy gives you better I/O performance.
  • D. High redundancy provides High Availability (HA) during disk failure and rolling Storage Server patching
  • E. Normal redundancy provides HA during rolling Storage Server patching.

Answer : B,D

Identify a recommended configuration to set up Auto Service Request (ASR) for Exadata.

  • A. Install ASR Manager on Exadata Database Server.
  • B. Install ASR Manager on Exadata Storage Server.
  • C. ASR is not recommended for Exadata; the Oracle Configuration Manager is preferred.
  • D. Install ASR Manager on a Standalone Server.

Answer : D

Explanation: The recommended configuration is to install the ASR Manager, which receives fault telemetry information from the servers in Oracle Exadata Database Machine, on an external standalone server. This server must run Solaris or Linux as the operating system.

Page:    1 / 5   
Total 74 questions