1Z0-027 | Downloadable Oracle 1Z0-027 dumps
Q1. You plan to migrate an existing production database supporting online transaction processing (OLTP) workloads to the Exadata Database Machine. The database currently supports an application requiring fast response times, which satisfies stringent requirements, and most of the application queries use index access to the tables in the application schema.
For which case would you consider dropping indexes to allow Smart Scans to occur?
A. Drop non-constraint indexes if Smart Scan occurs instead of an index access path on the corresponding table.
B. Drop non-constraint indexesif Smart Scan performs better than index unique scans on the corresponding table.
C. Drop non-constraint indexes if Smart Scan performs better than index range scans on the corresponding table.
D. Drop non-constraint Indexes if Smart Scan performs better than any index scans on the corresponding table.
Answer: D
Q2. Which three are true about Smart Flash log?
A. I/O Resource Manager database plans can be used to enable or disable Smart Flash Log for different databases.
B. LGWR will not wait for writes to Smart Flash log if the write to a disk based logfile completes first.
C. Smart Flash Log is enabled by default, using 1024 MB of Rash storage on each storage server.
D. You can remove Smart Flash Log from a single storage server with the drop flashing command.
E. I/O Manager category plans can be used to enable or disable Smart Flash LogFor different I/O categories.
Answer: ABD
Q3. You plan to monitor storage servers after configuring an I/O resource manager plan with directives for inter-database plans and intra-database plans.
Which two types if metrics would help assess the impact of the intra-database plans on I/O to the storage servers?
A. Category I/O
B. Database I/O
C. Resource Consumer Group I/O
D. Smart Flash Log I/O
E. Smart Flash Cache I/O
Answer: BC
Q4. Which two are true about Smart Scan?
A. a query rewrite may occur to a container table stored in Exadata but will never benefit From Smart scan.
B. Column projection does not contribute to the performance benefit of Smart Scan
C. It is possible to offload single row functions to the storage servers.
D. Some joins can be offloaded to the storage servers.
E. A query rewrite may occur to a container table stored Exadata, and it will always benefit from Smart Scan.
F. All joins can be offloaded to the storage servers.
Answer: CD
Q5. Which two are true concerning the allocation of I/O resources by the IORM within the CELLSRV process?
A. If two consumer groups A and B in the PROD database get 10% and 15% respectively of resource allocation, then the percentage of I/O resource would be the same if they got 20% and 30% respectively, provided that the category plans and inter database plans are unchanged, and consumer groups A and B are still mapped to the same category.
B. If two consumer groups C and D In the PROD database get 10% and 15% respectively of resource allocation, then the percentage of I/O resource would be the same if they still got 10% and 15% respectively and were remapped to a different category by the DBA, provided that the category plans and Interdatabase plans are unchanged.
C. If two consumer groups P and Q In the PROD database get 20% and 10% respectively of resource allocation, then the percentage of I/O resource would be the same if they got 10% and 5% respectively, and the Interdatabase plan has changed, provided that the category plan is unchanged, and consumer groups A and B are still mapped to the same categories.
D. Log Writer I/O and Control File I/O are high priority I/O managed automatically by IORM.
E. Database Writer I/O is considered to be the highest priority I/O and is managed based on attributes of the IORM plan.
Answer: CD
Q6. Identity the resource bottleneck for which QoS Management can generate recommendation?
A. CPU resource bottlenecks
B. Global Cache resource bottlenecks
C. I/O resource bottlenecks
D. Network resource bottlenecks
Answer: B
Q7. Which two are true about Exadata storage server alerts?
A. Metric alerts are never stateful.
B. Metrics have no thresholds set on them by default.
C. SNMP alert notifications can be sent to only one destination.
D. Metric threshold; if set, will persist across storage server reboots.
E. SMTP alert notifications must be sent to both ASR manager and Enterprise Manager Agents
Answer: DE
Q8. Which three are among the software components that constitute the QoS Management framework?
A. Cluster Health Monitor (CHM)
B. Cluster Verification Utility (CLUVFY)
C. O/S Resource Manager
D. Grid Infrastructure for a standalone server
E. Grid Infrastructure for a cluster
F. OC4J cluster resource
Answer: AEF
Q9. Which three storage components are available after the standard initial Database machine deployment?
A. The DATA_<DBM_Name> ASM diskgroup
B. The RECO_<DBM_Name> ASM diskgroup
C. Mirrored system partitions on hard disk 0 and hard disk 1
D. The DBFS_DG diskgroup with external redundancy
E. Exadata Smart Flash Cache using all of the flashdisk space
Answer: ABD
Q10. Which is true regarding Enterprise Manager monitoring and configuration?
A. Agents must be deployed on the- storage servers, in case all the database servers are down.
B. Monitoring the power distribution units (PDUs) is done by Enterprise Manager agents, but additional ethernet cables are required to connect the PDUs to the internal network switch in the Database Machine
C. Monitoring the power distribution units (PDUs) is done by Enterprise Manager agents without, any additional network configuration.
D. Agents may be deployed on the storage servers, in case all the database servers are down.
E. Monitoring the power distribution units (PDUS) is done by Enterprise Manager agents but additional ethernet cables are required to connect the PDUs to the corporate network switch.
Answer: C