Download Oracle.1z0-338.PracticeTest.2018-08-05.46q.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-08-05.46q.vcex
Size 143 KB
Posted Aug 05, 2018
Download Oracle.1z0-338.PracticeTest.2018-08-05.46q.vcex

How to open VCEX & EXAM Files?

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

Purchase

Coupon: MASTEREXAM
With discount: 20%






Demo Questions

Question 1

The Exadata architecture is divided into two specific tiers: the database tier and the storage tier.
What protocol do these tiers use to communicate with each other?


  1. iDB – Intelligent Database Protocol
  2. InfiniBand protocol
  3. Ethernet protocol
  4. Secure Shell protocol
  5. Fibre Channel protocol
Correct answer: A
Explanation:
Reference: https://docs.oracle.com/cd/E50790_01/doc/doc.121/e50471/concepts.htm#SAGUG20333
Reference: https://docs.oracle.com/cd/E50790_01/doc/doc.121/e50471/concepts.htm#SAGUG20333



Question 2

Your customer needs to ensure that their data is available on the Exadata machine during patches. The customer wants to be able to patch one server at a time but still be protected against single-node server failure. 
What ASM redundancy level should they use?


  1. High
  2. Normal
  3. External
  4. Extreme
  5. Standard
Correct answer: B
Explanation:
Reference http://www.oracle.com/technetwork/database/exadata/maa-exadata-asm-cloud-3656632.pdf  (page 7)
Reference http://www.oracle.com/technetwork/database/exadata/maa-exadata-asm-cloud-3656632.pdf  (page 7)



Question 3

In which three ways can customers access the ILOM interface to manage the Exadata database and storage server hardware components? (Choose three.)


  1. ILOM CLI interface through the management network
  2. ILOM Web interface through the management network
  3. remote KVM session to the ILOM
  4. from the database server operating system tool "ilomcli"
  5. from the storage server operating system tool "ilomcli"
Correct answer: BCE



Question 4

Your customer is implementing a storage consolidation strategy on their existing Exadata. 
Which step represents the Oracle recommended action that the customer should take in their approach?


  1. Do not use IORM because it will interfere with the shared database functionality on Exadata.
  2. Use ASM to create separate diskgroups for each database instance that is running on Exadata.
  3. Use IORM to distribute disk bandwidth among the databases.
  4. Set up Oracle Grid Infrastructure to use multiple clusters per hardware pool.
  5. Set up a resource consumer group within each database instance and manage it individually.
Correct answer: C
Explanation:
Reference: http://www.oracle.com/technetwork/topics/cloud/whatsnew/mixedworkloadmgmtexadata-300345.pdf page 42
Reference: http://www.oracle.com/technetwork/topics/cloud/whatsnew/mixedworkloadmgmtexadata-300345.pdf page 42



Question 5

How does Advanced Compression differ from Hybrid Columnar Compression?


  1. Advanced Compression is free to use on Exadata Database Machine, whereas Hybrid Columnar Compression must be purchased.
  2. They are the same; Advanced Compression is called Hybrid Columnar Compression on Exadata Database Machine.
  3. Hybrid Columnar Compression is good for tables with active updates and deletes, and provides deeper compression ratios.
  4. Advanced Compression is good for tables with active updates and deletes, whereas Hybrid Columnar Compression is best applied to tables or partitions where data is fairly static.
Correct answer: D



Question 6

The Exadata compute node, exadbs04, has been having issues for some time. The server had to be repaired and you just received a new server. Your LVM snapshot was corrupt and now the compute node must be re-imaged with an Oracle Support installation image. 
Which three tasks must be performed in order to re-image the compute node? (Choose three.)


  1. Create a CELLBOOT USB Flash Drive by using an external USB drive.
  2. Mount the LVM backup image across the network and recover the system.
  3. Remove exadbs04 from the RAC cluster and all associated Oracle Homes from the central inventory.
  4. Reboot the new server by using a bootable recovery image from the external USB drive.
  5. Reconfigure all site-specific settings (host name, IP addresses, NTP server, and so on).
Correct answer: CDE



Question 7

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 8

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 9

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 10

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









CONNECT US

Facebook

Twitter

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!



HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files