1. Home
  2. Oracle
  3. 1Z0-070

Oracle Exadata X5 Administration

Exam Details

  • Exam Code
    :1Z0-070
  • Exam Name
    :Oracle Exadata X5 Administration
  • Certification
    :Systems
  • Vendor
    :Oracle
  • Total Questions
    :103 Q&As
  • Last Updated
    :Dec 14, 2024

Oracle Systems 1Z0-070 Questions & Answers

  • Question 1:

    Which two statements are true about Database Server Metrics and Alerts on an X5 Database Machine?

    A. Database Server Metrics are collected my MMON.

    B. Database Server Metrics are collected by the MS process and stored in an internal disk-based repository.

    C. Database Server hardware sensor alerts are detected by the MS process on the database server.

    D. Database Server Metrics are collected by the RS process.

    E. Database Server Threshold Alerts may be forwarded by the MS process as SNMP traps.

  • Question 2:

    Identify the four software components that run only on an Exadata Database Machine Database Server.

    A. Cell Serve (CELLSRV)

    B. DISKMON

    C. CELLCLI

    D. Oracle Enterprise Manager Agent (OMA)

    E. Automatic Diagnostic Repository Command Interpreter (ADRCI)

    F. ASM instance

    G. DSKM

  • Question 3:

    Identify three facilities that can use X5 Extreme Flash Exadata Storage Server flashdisk space.

    A. Cell System Area

    B. Exadata Smart Flash Cache

    C. Database Smart Flash Cache

    D. cell boot flash image

    E. Exadata Smart Flash Log

  • Question 4:

    Which two communication methods are used by which components in the Enterprise Manager architecture for a Database Machine?

    A. SNMP traps for alerts are sent by the storage server ILOM directly to the Enterprise Manager agent.

    B. SNMP traps for alerts are sent by the storage server ILOM to the storage server MS process.

    C. SNMP traps for alerts are sent by the storage server MS process to the Enterprise Manager agent.

    D. SNMP traps for alerts are sent by the storage server MS process to the storage server ILOM.

    E. SNMP traps for alerts are sent by the storage server ILOM to the storage server RS process.

  • Question 5:

    You plan to migrate a very large database supporting a DSS workload to your new X5 Database Machine.

    It will be the only database on this full rack.

    Which three statements are true about Database Machine features that improve performance for the DSS

    workload?

    A. Smart Storage operations can improve the performance of joins.

    B. Smart Storage operations can improve the performance of scans.

    C. Hybrid Columnar Decompression overheads can be offloaded from the database servers for index full scans.

    D. Full table scan operations can improve due to the default Smart Flash Cache implementation.

    E. Hybrid Columnar Compression can reduce the amount of physical I/O required to scan large tables.

  • Question 6:

    Which two statements are true about Exadata storage server and database server alerts on an X5 Database Machine?

    A. Metric alerts are never stateful.

    B. Metric thresholds, if set, will persist across storage and database server reboots.

    C. SMTP alert notifications must be sent to both ASR manager and Enterprise Manager agents.

    D. SNMP alert notifications can be sent to only one destination.

    E. Metrics have no thresholds set on them by default.

  • Question 7:

    Which two Exadata X5 security features would you configure to control which databases can access which griddisks, when multiple databases share space on your storage servers in an unpartitioned storage grid?

    A. Using EXADCLI instead of CELLCLI to create the griddisks

    B. Exadata storage realms using database-scoped security mode

    C. file permissions on the griddisks in each storage server

    D. file permissions on the griddisks in each database server

    E. Exadata storage realms using ASM-scoped security mode

  • Question 8:

    You want to use Enterprise Manager to monitor the power distribution units (PDUs) in your Database Machine.

    On which three factors do the appropriate alarm thresholds for the plug-in depend?

    A. voltage and phase type of the PDUs

    B. disk types within the storage servers

    C. Database Machine server models for both the storage servers and database servers in the rack

    D. Database Machine rack size and variants

    E. disk types within the expansion racks

    F. distance between racks for multirack configurations

  • Question 9:

    You applied patches to both the storage servers and the database servers in your Exadata X6 Database Machine.

    You use Database Replay for a 90-minute workload to verify that there are no performance regressions after applying the patches.

    Which three options could you use to immediately measure the performance and to check for possible regressions caused by changes in the storage server software?

    A. cellcli list metriccurrent

    B. SQL Access Advisor

    C. cellcli list alerthistory

    D. SQL trace using dbms_monitor

    E. cellcli list metrichistory

  • Question 10:

    You are planning the migration of a large data warehouse to a Little Endian X6 Database Machine using

    which is running database version 12.2.0.1.

    The current database version is Oracle Database 11.2.0.4.0 hosted on a Big Endian platform.

    The current database characterset is WE8ISO8859P15.

    Which two migration methods are supported?

    A. Data Pump

    B. cross-platform Transportable Database

    C. Physical Standby database

    D. Logical Standby database

Related Exams:

Tips on How to Prepare for the Exams

Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-070 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.