1z0-485 Free Practice Test

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

1. 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.
2. B. Auto DOP is disabled by default and must be enabled before SQL statements can take advantage of its features.
3. C. Auto DOP is enabled by default on Oracle 11gR2, allowing full use of its features.
4. D. Oracle's Auto DOP algorithms calculate the Degree of Parallelism based on the table's block counts.
5. 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.

Correct Answer: BDE
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).
Incorrect: Not A:
* What if you don’t 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 statement is true about Enterprise Manager 12c for Exadata?

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

Correct Answer: D
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.
Incorrect:
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 ways to reduce the risks associated with the software updates that are performed on a production Exadata system.

1. A. Patch all systems at once instead of one at a time.
2. B. Test on an Exadata system that is identical to the production system first.
3. C. Updating an engineered system has no risk.
4. D. Patch on the standby system first by using Data Guard Standby First Patch Apply.
5. E. Create a system-wide firmware and software snapshot first.

Correct Answer: BD
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

Your customer has purchased their brand new Exadata Database Machine X3-2 Full rack to achieve 20-TB-per-hour backups on their 300 TB database. You have been called to determine why they are not able to achieve even half that rate. Use the information in the image below to identify two reasons their backups are still slow.

1. A. The Media Server to Tape Library transfer is causing a bottleneck.
2. B. The number of tape drives is causing a bottleneck.
3. C. Exadata backups are being performed using RMAN over the 10 Gigabit Ethernet network.
4. D. The number of database servers is causing a bottleneck.

Correct Answer: BC
The following bottlenecks will be reached first if using InfiniBand fabric to media server:
1. Media server to tape library SAN transfer rate
2. Number of tape drives

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

1. A. Patching services are available for the full software stack up to twice per year.
2. B. Patching support includes Exadata, Exalogic, and Database Appliance.
3. C. Rolling window and complete down time approaches are two options to patching.
4. D. Platinum covers Exadata storage software and firmware patching, but the customer must perform database patching.

Correct Answer: D
* 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.