Download Oracle.1z0-338.PracticeTest.2018-01-19.43q.vcex

Download Exam

File Info

Exam Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials
Number 1z0-338
File Name Oracle.1z0-338.PracticeTest.2018-01-19.43q.vcex
Size 141 KB
Posted Jan 19, 2018
Download Oracle.1z0-338.PracticeTest.2018-01-19.43q.vcex

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase

Coupon: MASTEREXAM
With discount: 20%





Demo Questions

Question 1

Which statement is true about instance caging setup?


  1. The initialization parameter resource_manager_plan should be set.
  2. For a system with 16 threads, the sum of cpu_count for all databases should not be higher than 32 to prevent oversubscribing.
  3. Database instances need to be restarted to make changes to cpu_count effective.
  4. The CPU Resource Manager and IORM need to be enabled to make instance caging to work as expected.
  5. Instance caging is the right approach to make sure that database instances are not stealin memory from one another.
Correct answer: A
Explanation:
Reference: http://www.oracle.com/technetwork/database/performance/instance-caging-wp-166854.pdf
Reference: http://www.oracle.com/technetwork/database/performance/instance-caging-wp-166854.pdf



Question 2

Which three tools can be used on a freshly re-imaged Exadata system to create, resize, or delete ACFS filesystems? (Choose three.)


  1. SQL*Plus and ASMCMD
  2. ASMCA
  3. Enterprise Manager Express
  4. Enterprise Manager Cloud Control
  5. RMAN
  6. OUI
Correct answer: ABC
Explanation:
Reference https://dbasolutions.wikispaces.com/ACFS+on+Linux
Reference https://dbasolutions.wikispaces.com/ACFS+on+Linux



Question 3

Your government customer has purchased a full rack of Exadata. The customer has two departments that would like to share the Exadata Database Machine but the concern is that department A will be able to see data from department B. 
Which architecture would you suggest to solve this deployment issue?


  1. Split the configuration by using Oracle Nimbula's cloud software so that four database servers and seven cells can be used by department A and the rest can be used by department B.
  2. Split the configuration and use ASM-Scoped Security so that four database servers and seven cells can be used by department A and the rest can be used by department B.
  3. Set up instance caging to ensure that department A has access only to four database servers and seven cells and department B has access to the rest.
  4. Define the split by setting up database services that are specific to department A and department B.
Correct answer: D



Question 4

There are many different ways to load data into database tables. 
Which method does Oracle strongly recommend?


  1. generic connectivity via ODBC or JDBC
  2. database gateways to open systems and mainframes
  3. Oracle GoldenGate
  4. Oracle Data Pump
  5. SQL*Loader import
  6. data loading via external tables
Correct answer: F



Question 5

Which options does not benefit from storage offload processing?


  1. indexes that rely on B-Tree pointers
  2. column filtering
  3. joins and aggregation
  4. table scans
  5. incremental backups with block change tracking
Correct answer: A
Explanation:
Reference: https://www.pythian.com/blog/exadata-join-offloading-in-action/
Reference: https://www.pythian.com/blog/exadata-join-offloading-in-action/



Question 6

Your customer would like to configure monitoring capabilities alongside ASR on the stand-alone server that was set aside to run ASR Manager. 
What configuration would you set up for the customer?


  1. Enterprise Manager, SQL Developer Server, and ASR Manager on the stand-alone server because ASR needs SQL Developer to gain SQL access to the database server
  2. ASR Manager inside the firewall to ensure that root access to Exadata Database Machine is not compromised
  3. ASR Manager with SNMP traps configured to listen for specific alerts triggered by Exadata Database Machine
  4. Enterprise Manager (Ops Center) and ASR Manager on the stand-alone server because ASR is not a monitoring tool
Correct answer: D



Question 7

Identify three customer options for hosting the Platinum Services Advanced Support Gateway. (Choose three.)


  1. Purchase the recommended x86 64-Bit gateway hardware from Oracle.
  2. Install in Oracle Virtual Machine with required hardware.
  3. Install on Exadata Engineered System.
  4. Provide individual x86 64-Bit gateway hardware.
  5. Install on Oracle Database Appliance.
Correct answer: ABC
Explanation:
Reference: http://www.oracle.com/us/assets/platinum-services-faq-1653259.pdf
Reference: http://www.oracle.com/us/assets/platinum-services-faq-1653259.pdf



Question 8

Which two statements are true about metrics in the DBMCLI utility? (Choose two.)


  1. Metric values are computed and stored in memory, and then permanently stored on disk.
  2. DBMCLI can be used to report on Exadata storage server metrics.
  3. Metrics are reported as one of four types: cumulative, instantaneous, rate, or transition.
  4. Fields in AlertHistory cannot be modified.
  5. DBMCLI reported metrics are informational only and cannot be used to trigger alerts or reported events.
Correct answer: AC
Explanation:
Reference: https://docs.oracle.com/cd/E50790_01/doc/doc.121/e51951/app_dbmcli.htm#DBMMN22246
Reference: https://docs.oracle.com/cd/E50790_01/doc/doc.121/e51951/app_dbmcli.htm#DBMMN22246



Question 9

What happens in an Exadata Database Machine when the DUPLICATE sub-clause of the INMEMORY attribute is specified?


  1. The DUPLICATE sub-clause enables parallel execution NUMA support.
  2. Each In-Memory Compression Unit in the IM column store will have a mirrored copy placed on another node in the RAC cluster.
  3. The command allows the current instance to exceed DRAM limits and expand across memory, flash, and disk.
  4. The command creates an in-memory snapshot for write_only access.
  5. The In-Memory Compression Unit will have a mirrored copy placed on every other node in the RAC cluster.
Correct answer: B
Explanation:
Reference: http://www.oracle.com/technetwork/database/in-memory/learnmore/twp-dbim-exadata-2556211.pdf (page 3)
Reference: http://www.oracle.com/technetwork/database/in-memory/learnmore/twp-dbim-exadata-2556211.pdf (page 3)



Question 10

Which statement explains the difference between Normal and High redundancy ASM failure groups?


  1. Normal redundancy protects the DATA diskgroup, whereas High redundancy protects the RECO diskgroup.
  2. Normal redundancy (best practice) provides protection against two simultaneous disk failures, whereas High redundancy provides protection against a single disk failure or an entire storage server failure.
  3. High redundancy gives more usable storage, whereas Normal redundancy provides better I/O performance.
  4. Normal redundancy protects from disk failure when a cell is offline or being updated, whereas High redundancy protects the system when all the cells are offline.
  5. Normal redundancy tolerates a single cell failure, whereas High redundancy tolerates a two-cell failure.
Correct answer: E
Explanation:
Reference: http://blog.umairmansoob.com/tag/using-high-vs-normal-redundancy-in-exadata/
Reference: http://blog.umairmansoob.com/tag/using-high-vs-normal-redundancy-in-exadata/









CONNECT US

Facebook

Twitter

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!

Get Now!


HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files