web analytics

Oracle Exadata Database Machine 2014 Implementation Essentials 1Z0-485 Dumps With VCE and PDF Download (Question 41 – Question 45)

PassLeader now are offering 100% pass ensure 1Z0-485 dumps! All 1Z0-485 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-485 VCE dumps and PDF dumps: https://www.passleader.com/1z0-485.html (82 Q&As)

BTW: Download PassLeader 1Z0-485 dumps from Google Drive for free: https://drive.google.com/open?id=12x1C2TDaXj894HTQfKIN10fpXS2y2JeW

QUESTION 41
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: 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 42
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: BD

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

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 44
Which two actions are permitted with Exadata Database Machine?

A.    replacing the Ethernet switch with an equivalent 1U 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: AC

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

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 11g R2, allowing full use of its features.
D.    Oracle’s Auto DOP algorithms calculate the Degree of 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: BDE
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).
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.


PassLeader now are offering 100% pass ensure 1Z0-485 dumps! All 1Z0-485 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-485 VCE dumps and PDF dumps: https://www.passleader.com/1z0-485.html (82 Q&As)

BTW: Download PassLeader 1Z0-485 dumps from Google Drive for free: https://drive.google.com/open?id=12x1C2TDaXj894HTQfKIN10fpXS2y2JeW