Free Oracle Exadata X5 Administration 1Z0-070 Exam Practice Test

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

• SNMP traps for alerts are sent by the storage server ILOM directly to the Enterprise Manager agent.
• SNMP traps for alerts are sent by the storage server ILOM to the storage server MS process.
• SNMP traps for alerts are sent by the storage server MS process to the Enterprise Manager agent.
• SNMP traps for alerts are sent by the storage server MS process to the storage server ILOM.
• SNMP traps for alerts are sent by the storage server ILOM to the storage server RS process.

Which two statements are true about RMAN incremental level-1 backups for a database running on an X5 Database Machine?

• Block Change tracking (BCT) is not needed for databases in an X5 Database Machine, because ASM automatically does block change tracking when diskgroups are built from griddisks.
• cellsrv filters blocks and returns only those that have changed since the last backup, for databases in archivelogmode.
• cellsrv returns all blocks that have been or might have been changed since the last backup, and RMAN filters the blocks that do not require backup.
• cellsrv filters blocks and returns only those that have changed since the last backup, for databases in noarchivelogmode.
• Block Change Tracking (BCT) is not needed for databases in an X5 Database Machine, because change tracking is done by cellsrv.

You plan to consolidate multiple mission-critical databases onto a single rack Exadata X6 Database Machine.You do not plan to use virtualization on the database servers.You have identified two database categories, based on differing availability and maintenance objectives.Which two choices will be the best solution?

• Create a single database cluster that accesses a single storage grid.
• Create a single database cluster that accesses multiple storage grids.
• Partition the Exadata storage servers into two separate storage grids.
• Create a single storage grid and share space on the celldisks using Exadata storage realms.
• Partition the database servers into two separate clusters.

Which three factors should you consider when choosing a method for migrating a database to the X5 Database Machine?

• The down time allowed for the migration
• Endian format of the source database
• Number of tablespaces in the source database
• The type of database workloads
• Size of the source database

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?

• Smart Storage operations can improve the performance of joins.
• Smart Storage operations can improve the performance of scans.
• Hybrid Columnar Decompression overheads can be offloaded from the database servers for index full scans.
• Full table scan operations can improve due to the default Smart Flash Cache implementation.
• Hybrid Columnar Compression can reduce the amount of physical I/O required to scan large tables.

A file contains a script with several EXACLI commands that must be executed on each cell in an X5 full rack.The script must run on each cell simultaneously.How would you achieve this?

• Copy the script to all cells using the DCLI command and manually execute it on each cell using the DCLI command.
• Copy the script to the cells using the EXACLI command and execute the script on all cells using the EXACLI command.
• Execute it on all cells using the EXADCLI command specifying the file name containing the EXACLI script.
• Copy the script to all cells using the CELLCLI command and execute it on all cells in parallel using the CELLCLI command.
• Execute it on all cells using the DBMCLI command specifying the file name containing the EXACLI script.

Which type or types of network traffic are transported over the internal InfiniBand interconnect in Exadata Database Machine X5?

• IDB protocol traffic, clustered ASM traffic, and clustered database instance traffic
• IDB protocol traffic and clustered database instance traffic only
• IDB protocol traffic and clustered ASM instance traffic only
• Both clustered ASM and clustered database instance traffic only
• IDB protocol traffic only

Which two must be true for a Smart Scan to occur on a table?

• Sessions querying the table must set cell_offload_processing = true.
• It must be stored in an ASM diskgroup with a 4 MByte AU size.
• It must be heap organized.
• It must be accessed using direct path reads.
• The table must not be compressed.

Which two statements are true about the X5 Exadata storage server rescue procedure?

• The rescue procedure can be executed from the CELLBOOT USB flash drive.
• An Exadata storage server automatically enters the rescue environment when it cannot boot from the system area.
• The rescue procedure can be used to repair corruption in an ASM diskgroup.
• The rescue procedure can be used to restore a corrupt system area.
• The rescue procedure must be used to recover from a failed Exadata storage server software upgrade.

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?

• Data Pump
• cross-platform Transportable Database
• Physical Standby database
• Logical Standby database