1Z0-515 Online Practice Questions and Answers

Correct Answer: D

Explanation:

There is no practical limit to number of cells that can be in the grid.

References:

Correct Answer: C

Explanation:

There are two approaches to consider for data integration: ELT and ETL. The difference between ETL and ELT lies in the environment in which the data transformations are applied. In traditional ETL, the transformation takes place when the data is en route from the source to the target system. In ELT, the data is loaded into the target system, and then transformed within the target system environment.

References:

Correct Answer: A

Explanation: Oracle Optimized Warehouse Reference Configurations are best practice guides to choosing the right server, storage and networking components to build an Oracle data warehouse. These best practice guides encapsulate years of configuration expertise from Oracle and its partners, helping customers take the risk out of implementing a data warehouse.

References:

Correct Answer: A

Explanation: The RESULT_CACHE_MODE initialization parameter determines the SQL query result cache mode. The parameter specifies when a ResultCache operator is spliced into a query's execution plan. The parameter accepts the following values: FORCE The ResultCache operator is added to the root of all SELECT statements, if that is possible. However, if the statement contains a NO_RESULT_CACHE hint, then the hint takes precedence over the parameter setting. MANUAL The ResultCache operator is added, only if you use the RESULT_CACHE hint in the SQL query.

References:

Correct Answer: A

Explanation:

The SQL Access Advisor was introduced in Oracle 10g to make suggestions about additional indexes and

materialized views which might improve system performance. Oracle 11g has made two significant

changes to the SQL Access Advisor:

The advisor now includes advice on partitioning schemes that may improve performance. The original

workload manipulation has been deprecated and replaced by SQL tuning sets.

References:

Correct Answer: B

Explanation: Oracle Data Integrator streamlines the highperformance movement and transformation of data between disparate systems in batch, real-time, synchronous, and asynchronous modes. Knowledge Modules are at the core of the Oracle Data Integrator architecture. They make all Oracle Data Integrator processes modular, flexible, and extensible. Knowledge Modules implement the actual data flows and define the templates for generating code across the multiple systems involved in each process. Knowledge Modules are generic, because they allow data flows to be generated regardless of the transformation rules. And they are highly specific, because the code they generate and the integration strategy they implement are finely tuned for a given technology. Oracle Data Integrator provides a comprehensive library of Knowledge Modules, which can be tailored to implement existing best practices (for example, for highest performance, for adhering to corporate standards, or for specific vertical know-how). By helping companies capture and reuse technical expertise and best practices, Oracle Data Integrator's Knowledge Module framework reduces the cost of ownership. It also enables metadata-driven extensibility of product functionality to meet the most demanding data integration challenges.

References:

Correct Answer: A

Explanation:

Oracle Business Intelligence Enterprise Edition is most commonly used with the Oracle Database using

SQL as the query language. Although the OLAP cube is a multidimensional data type, it is represented in

the Oracle database as a collection of relational views and is easily queried by SQL.

Note #1: The wording of the question is strange. SQL can be used and is the first choice. So it seems to

be the best answer.

Note #2: Oracle Business Intelligence Enterprise Edition (OBI EE) is a product suite based on the OBI EE

Server. The OBI EE Server can map a logical business model to many different physical data sources and

present the logical model for query to variety of client applications including Interactive Dashboards,

Answers and Oracle Business Intelligence Plug-in for Microsoft Office.

References:

Correct Answer: C

Explanation:

Compression is useful because it helps reduce the consumption of resources such as data space or

transmission capacity. Because compressed data must be decompressed to be used, this extra

processing imposes computational or other costs through decompression.

Correct Answer: B

Explanation:

Correct Answer: B

Explanation: You can use Analytic Workspace Manager for creating measures, dimensions and cubes in the OLAP database if the database was installed with the OLAP option. Workspace Manager, a feature of Oracle Database, enables application developers and DBAs to manage current, proposed and historical versions of data in the same database.

Note: Applications and DBA operations often work with more than one version of the data. Three common reasons to have multiple data versions are concurrency, auditing and scenario creation. Oracle Workspace Manager provides workspaces as a virtual environment to isolate a collection of changes to production data, keep a history of changes to data and create multiple data scenarios for "what if" analysis. It can save money, time and labor over traditional approaches.