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 1
Which two statements are true about troubleshooting failed patching activities?
A. Dependency issues found during yum updates require rolling back to a previous release before retrying.
B. Bundle patches applied using opatch auto cannot roll back only the database or the grid infrastructure home.
C. Failed OS patches on database servers can be rolled back.
D. Failed storage cell patches are rolled back to the previous release automatically.
E. Database server OS updates can be rolled back using opatch auto -rollback.
F. Dependency issues found during yum updates should be ignored using the force option.
Answer: AE
Explanation:
– Oracle has shifted the strategy to patching the exadata in 11.2.3.2.0 onwards to using yum as the method of patching.
– Database servers are patched using yum; there is a yum channel for each Exadata image version. Recently, this functionality replaced the “minimal pack.”
– In the README for each storage server patch, Oracle provides detailed roll back instructions that are to be followed in the event of a patch failure.
QUESTION 2
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
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 3
Your customer wants to increase the size of the DATA diskgroup on the Exadata systems. The customer is currently using 600 GB disks. Which two are the best options that you would recommend?
A. adding a High Capacity Storage expansion rack
B. expanding the Exadata rack from a Half Rack to a Full Rack
C. moving underutilized grid disks from the RECO diskgroup to DATA
D. adding a ZFS storage appliance
E. adding a High Performance Storage expansion rack
Answer: AB
Explanation:
A: Oracle Exadata Storage Expansion Rack X4-2 enables you to grow the Oracle Exadata storage capacity and bandwidth of Oracle Exadata Database Machine X4-2 and X3-8 and Oracle SuperCluster. It is designed for database deployments that require very large amounts of data, including historical or archive data; backups and archives of Oracle Exadata Database Machine data; documents; images; file and XML data; LOB’s; and other large unstructured data.
QUESTION 4
What are two choices that a customer must make that impact diskgroup creation?
A. What is the level of redundancy required?
B. What OS will be run?
C. Where will disk backups be written?
D. How many databases will run on the cluster?
Answer: AB
Explanation:
B: There are a number of ASM disk group attributes that you can set when creating your disk groups, but the following are the most important:
* (Answer B) compatible.rdms: set this to the software version of your RDBMS home.
* au_size: set this to 4 MB.
* compatible.asm: set this to the software version of your Grid Infrastructure home.
* cell.smart_scan_capable: set this to TRUE. If this attribute is set to FALSE, Smart Scan will be disabled to segments that reside in the disk group.
* disk_repair_time: leave this defaulted to 3.6 hours unless you’re performing maintenance on a call and know that your outage window will be greater than 3.6 hours.
A: Once you identify candidate grid disks, use the CREATE DISKGROUP command to create your ASM disk groups. Here are some of the more important considerations to think about when creating ASM disk groups on Exadata:
* (Answer A) When capacity planning, take your redundancy specification into consideration. Normal redundancy will have the effect of reducing your usable storage to half the raw capacity, and high redundancy will shrink it to a third of your raw disk capacity.
* Simplicity is best on Exadata. Using wild-carded CREATE DISKGROUP syntax not only offers the most terse command syntax, but also ensures your ASM disk groups are spread evenly across your Exadata Storage Server disks.
* Take the time to plan grid disk prefix names and overall grid disk configuration in the context of your desired ASM disk group design.
* Make sure to set the appropriate compatible.asm and compatible.rdbms attributes when creating ASM disk groups.
* Whenever possible, use a 4 MB extent size when creating disk groups on ASM storage.
QUESTION 5
When would be the best time to run an Exadata health check (exachk)?
A. before patching, before upgrades, before backups, and on a regular basis
B. after patching, after upgrades, and after backups
C. only when advised by Oracle Support
D. before and after patching, when advised by Oracle Support, and on a regular basis
E. only after a hardware failure
F. monthly and after a hardware failure
Answer: D
Explanation:
#1: Check for updates frequently.
#2: Execute before & after system changes.
#3: Make part of regular planned maintenance.
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