Identity the true statement about a data warehouse A. The data warehouse is typically refreshed as often as a transactional system, B. Data warehouse queries are simpler than OLTP queries. C. A data warehouse typically contains historical data. D. Queries…
Identify the statement about Oracle OLAP that is NOT true. A. Oracle OLAP cubes are stored in the Oracle relational database B. Oracle OLAP uses standard Oracle database security. C. Meta data for Oracle OLAP is accessible in an external…
Your BI tool (for example, Oracle Business Intelligence Enterprise Edition Cognos) will be used to query an Oracle database that includes the Oracle BI tool generate in submitting queries that might include data stored in cubes? A. SQL B. PIVSQL…
What are Oracle Data Integrator templates used for? A. To model SAP applications B. To define how to transform data C. As reports to monitor ETL activity D. None of these
How does compression affect resource utilization? A. Reduces the amount of CPU and disk utilization B. Increases the amount of CPU and disk utilization C. Reduces the amount of disk but increases CPU utilization for loading D. Increases the amount…
How many Exadata Storage Server cells are there in a Full Rack Exadata database machine configuration that has 8 Database Server nodes? A. 2 B. 14 C. 16 D. 24
Identify the true statement about adaptive parallelism. A. It Is turned on by default. B. It is turned off by default. C. You should always leave the default setting D. There is no such thing.
Your customer wants to use Database Resource Manager to help ensure consistent performance based on users and operations. In designing this implementation, which limitation CANNOT be imposed through Database Resource Manager? A. Specifying the maximum number of concurrent operations for…
Data Guard compresses data: A. Always B. When using logical standby C. When using physical standby D. When catching up after a network failure
Your BI tool (for example, Oracle Business Intelligence Enterprise Edition Plus, Business Objects and Cognos) will be used to query an Oracle database that includes the Oracle OLAP Option What does tool generate in submitting queries that might include data…