Oracle Oracle Certifications 1z0-338 Questions & Answers

• Question 31:

  Which three options describe the flash memory capabilities of the Exadata X6-2 database and storage servers? (Choose three.)

  A. no flash storage on the database server

  B. 4 x 3.2 TB NVMe flash cards on the HC storage server

  C. 8 x 3.2 TB NVMe flash cards on the EF storage server

  D. 4 x 3.2 TB NVMe flash cards on the database server

  E. 8 x 3.2 TB NVMe flash cards on the HC storage server

  Correct Answer: ABC

• Question 32:

  Which two steps are needed to set up instance caging on an Exadata system? (Choose two.)

  A. Set the CPU_COUNT parameter to the maximum number of CPUs that the database instance should utilize at any time.

  B. Enable a resource plan to manage the CPUs.

  C. Specify the optimization objective as low_latency or high__throughput.

  D. Set PGA_AGGREGATE_LIMIT to an acceptable level for the intended instances.

  E. Change the initialization parameter THREADED_EXECUTION to TRUE and restart the instance.

  Correct Answer: AB

  Reference: http://www.oracle.com/technetwork/database/performance/instance-caging-wp-166854.pdf

• Question 33:

  In which three cases would RMAN backup and recovery be a good strategy for migrating to the cloud? (Choose three.)

  A. when the source platform is little endian, character set is AL32UTF8, and the architecture is multitenant

  B. when moving an Oracle Data Guard physical standby database to the cloud

  C. when you are migrating a database from a different database version and it might have a different character set

  D. when you are concerned about the endian nature of the database and want to perform conversions from different formats

  E. when a physical migration approach is feasible and physical database reorganization is no necessary

  Correct Answer: BCE

• Question 34:

  Your customer has encountered some system disk issues and has been told that a “storage cell rescue procedure” must be implemented.

  What will this procedure accomplish?

  A. It will perform a predictive disk failure replacement for cell disks.

  B. It will recover the Exadata system volumes by using the internal USB flash disk.

  C. It will perform cell flash cache failure replacement.

  D. It will perform a complete storage server hardware replacement.

  E. It will perform a database server disk replacement.

  Correct Answer: BCD

• Question 35:

  Which two terms correctly describe the concept of moving database processing from the database layer to the storage layer to reduce the volume of data that needs to be processed by the database server? (Choose two.)

  A. sharding

  B. offloading

  C. Smart Scan

  D. predicate filtering

  E. column projection

  Correct Answer: BC

  Reference: http://www.oracle.com/technetwork/database/exadata/exadata-dbmachine-x4-twp-2076451.pdf

• Question 36:

  Which three features are unique to Exadata Storage? (Choose three.)

  A. grid disks with default AU allocation sizes of 1 MB

  B. usage of flash technology to cache recently used data

  C. prioritization of disk I/Os based on the database

  D. prioritization of OLTP I/Os over scan I/Os

  E. database storage flash cache space allocation guarantees and limits

  Correct Answer: ACE

• Question 37:

  Your Exadata Cloud instance has been fully provisioned and you continue the setup by logging in to the newly created Virtual Machines (VMs) by using SSH.

  Which two default usernames can be used to log in to the VMs? (Choose two.)

  A. administrator

  B. oracle

  C. root

  D. system

  E. opc

  Correct Answer: CE

  Reference: https://docs.oracle.com/en/cloud/paas/java-cloud/jscug/switching-vm-users.html

• Question 38:

  A customer has received an email notification about a temperature alert on one of the storage servers on their Exadata system.

  What action can the customer take to further investigate the alert?

  A. Log in to the Oracle database and query v$temperature.

  B. SSH to the storage server and use the CeIICLI sensor_check command to get information about the storage server's health.

  C. Log in to the ILOM service processor and view the current status of the sensors and indicators on the system.

  D. Enter the data center and immediately power off the storage server.

  E. Run exachk to find the system component that might be having a problem.

  Correct Answer: B

• Question 39:

  When provisioning Oracle Exadata Cloud Service, the wizard requests information about backup and restore options.

  Which two options are provided to customers? (Choose two.)

  A. backup directly to a Storage Cloud Software Appliance

  B. backup to Oracle Replication Cloud

  C. backup to Exadata storage (if this option was chosen during configuration)

  D. cloud storage through Oracle Database Backup Cloud Service E. backup to Oracle Tape Library Cloud

  Correct Answer: CD

  Reference: https://docs.oracle.com/en/cloud/paas/exadata-cloud/csexa/backing.html

• Question 40:

  Which Exadata feature eliminates unnecessary data transfers between database nodes and storage?

  A. Flash Cache

  B. database views

  C. InfiniBand networking

  D. high performance SAS2 disk drives

  E. cell offloading

  Correct Answer: AE