Free Oracle 1z1-070 Exam Dumps Questions & Answers

You plan to migrate a database supporting both DSS and OLTP workloads to your new X5 Database Machine.
The workloads contain many complex aggregating functions and expensive joins on large partitioned tables in the DSS workload and indexed access for OLTP workloads.
Which three benefits accrue as a result of this migration?

• A.Superior compression capability designed specifically for archival data
• B.Superior compression capability designed specifically for OLTP workloads
• C.Columnar storage capability for data in row major data blocks that is held in flash cache
• D.Superior flash cache compression technique
• E.Superior compression capability designed specifically for data warehouse tables
• F.Cell offload processing for indexed-organized table access

A heap-organized table in one of your database schemas contains only date, char, varchar2, and number data type columns.
Which three operations can be offloaded to Exadata Storage Servers when performing a Smart Scan on this table?

• A.Virtual column filtering
• B.Nested loop join filtering
• C.MIN/MAX scans
• D.Column filtering
• E.Sort-merge join filtering
• F.Predicate filtering

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.Logical Standby database
• C.cross-platform Transportable Database
• D.Physical Standby database

Which three are sources for alerts from storage servers in an X5 Database Machine?

• A.Software errors reported by the RS process on the storage servers
• B.Metrics that have administrator-defined thresholds on the storage servers
• C.Hardware sensor alerts detected by the ILOM on the storage servers
• D.Software errors reported by the MS process on the storage servers
• E.Hardware sensor alerts reported by the CELLSRV process on the storage servers

Which two are true about Smart Scan?

• A.Join processing can be partly offloaded to Exadata Storage Servers.
• B.It is possible to offload single row functions to the Exadata Storage Servers.
• C.Column projection does not contribute to the performance benefit of Smart Scan.
• D.Join processing can be fully offloaded to Exadata Storage Servers.
• E.A query rewrite may occur to a materialized view stored in Exadata, and it will always benefit from Smart Scan.
• F.A query rewrite may occur to a materialized view stored in Exadata but will never benefit from Smart Scan.