1Z0-515 Exam Questions
71 real 1Z0-515 exam questions with expert-verified answers and explanations. Page 1 of 2.
- Question #1Information Lifecycle Management
Your customer wants to implement an ILM strategy. The customer must have which option when deploying Oracle's ILM Assistant to implement this strategy?
ILM AssistantpartitioningInformation Lifecycle Managementdeployment requirements - Question #2Data Warehouse Architecture and Design
You want to create an optimally performing data warehouse hardware configuration for your customer. Which way of creating a hardware configuration will reduce the implementation ti...
data warehouse hardwarereference configurationapplianceimplementation time - Question #3Oracle Database Partitioning
Which statement is true for you to get the benefits of partition-wise joins?
partition-wise joinsreference partitioningprimary keyquery optimization - Question #4Oracle Warehouse Builder
You can perform what-if analysis of potential changes with Oracle Warehouse Builder.
Oracle Warehouse Builderwhat-if analysisETL capabilitiesOWB features - Question #5Data Warehouse Design
Indentify the dimension that appears most often in queries in a data warehouse.
data warehouse dimensionsdimensional modelingquery patternsdimension frequency - Question #6Oracle Data Mining
Which questions CANNOT be addressed by Oracle Data Mining?
Oracle Data Miningdata mining capabilitiesfraud detectionprediction - Question #7Oracle Database Partitioning
Which is NOT an available composite partition in Oracle Database 11g?
composite partitioninginterval partitioningpartition typesOracle 11g - Question #8Data Warehouse Architecture and Design
You are looking to create a RAC cluster to deliver high performance for your client's data warehouse. Which statement is true about a configuration with a few large nodes versus a...
RACdata warehouse performancenode configurationworkload analysis - Question #9Oracle Data Mining
You can use Oracle Data Mining unstructured data.
Oracle Data Miningunstructured datadata mining capabilitiesODM features - Question #10Oracle Data Mining
How can you use Oracle Data Mining with Oracle Warehouse builder?
Oracle Data MiningOracle Warehouse BuilderETL integrationrecord extraction - Question #11Oracle Data Mining
You customer wants to segment their customers1 demographic data into those that use and do not use loyalty card. What would you recommend?
Oracle Data Miningcustomer segmentationmatrix factorizationclassification algorithms - Question #12Information Lifecycle Management
One goal of your Information Lifecycle Management strategy using Oracle's ILM capabilities is to reduce cost or online storage. Identify two database options that would help in ena...
ILMpartitioningAdvanced Compressiononline storage cost - Question #13Loading Data into the Data Warehouse
Which can be used in scenario where there are large data loads of a sensitive nature into a data warehouse?
direct path loadingpartition exchange loadingexternal tablesdata sensitivity - Question #14Loading Data into the Data Warehouse
How can you implement near real time data integration with Oracle Data Integrator?
Change Data CaptureOracle Data Integratornear real-time integrationCDC logs - Question #15Advanced Concepts
Your customer wants to determine "market baskets." What do you recommend?
market basket analysisassociations algorithmOracle Data Miningdata mining use cases - Question #16Materialized Views
Identify the type of refresh that is NOT supported by materialized views.
materialized view refreshincremental refreshfull refreshdeferred refresh - Question #17Advanced Concepts
For which task would you NOT use Oracle Data Mining?
Oracle Data Miningpredictive analyticsdata mining use casesdata reduction - Question #18Introduction to Data Warehousing Concepts
What is the estimated maximum speed of data loads for a Quarter Rack with the Exadata Storage Server?
Exadata Storage ServerQuarter Rackdata load throughputhardware specs - Question #19Advanced Concepts
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...
Oracle OLAPBI tool integrationSQL generationOLAP cubes - Question #20Advanced Concepts
Data Guard compresses data:
Data Guarddata compressionphysical standbylogical standby - Question #21Loading Data into the Data Warehouse
What are Oracle Data Integrator templates used for?
Oracle Data IntegratorETL templatesdata transformationODI - Question #22Advanced Concepts
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...
Oracle OLAPSQL generationBI toolsOLAP cubes - Question #23Advanced Concepts
How does compression affect resource utilization?
data compressionCPU utilizationdisk utilizationcompression trade-offs - Question #24Advanced Concepts
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...
Database Resource Managerresource groupsparallelismperformance management - Question #25
How many Exadata Storage Server cells are there in a Full Rack Exadata database machine configuration that has 8 Database Server nodes?
- Question #26Advanced Concepts
Identify the true statement about adaptive parallelism.
adaptive parallelismparallel querydefault settingsOracle database - Question #27Advanced Concepts
Identify the statement about Oracle OLAP that is NOT true.
Oracle OLAPOLAP cubesdata dictionaryRAC - Question #28Advanced Concepts
The Analytic Workspace Manager would be used to generate_______.
Analytic Workspace ManagerOracle OLAPOLAP cubes - Question #29Loading Data into the Data Warehouse
Which feature of Oracle Warehouse Builder can be used to help ensure data quality?
Oracle Warehouse Builderdata qualitydata profilingETL - Question #30Introduction to Data Warehousing Concepts
Flash in the Oracle Exadata Database Machine is of lower latency (and enables faster access to data) than:
Exadataflash storagestorage latencystorage hierarchy - Question #31Partitioning
Indentify the true statement about REF partitions.
REF partitioningparent-child partitioningpartition inheritancepartition-wise joins - Question #32Loading Data into the Data Warehouse
Identify the control structure that would NOT be defined as part of a data flow with Oracle Data Integrator.
Oracle Data Integratordata flowcontrol structuresETL workflow - Question #33Advanced Concepts
For which type of query is the SQL result cache automatically disabled?
SQL result cacheSYSDATEcache invalidationnon-deterministic functions - Question #34Introduction to Data Warehousing Concepts
Which is NOT among Oracle SQL Analytic functions included in Oracle Database 11g?
SQL analytic functionswindow functionsLAG/LEADranking functions - Question #35Advanced Concepts
How many Exadata Storage Server cells can be used in a grid?
Exadatastorage server cellsgrid scalability - Question #36Advanced Concepts
Identify the action that you CANNOT perform using Database Resource Manager.
Database Resource Managerconsumer groupsresource planCPU allocation - Question #37Introduction to Data Warehousing Concepts
You will be implementing a data warehouse for one of your customers. In your design process, which index type is most likely to be used to improve the performance of some queries w...
bitmap indexeslow cardinalityindex selectionquery performance - Question #38Advanced Concepts
You think that result set caching might provide some benefits for your current data warehouse scenario. You perform some analysis on the composition of the queries used in the scen...
result set cachingquery optimizationcache eligibilitydata warehouse performance - Question #39Advanced Concepts
For data warehousing, identify the benefits that would NOT be provided by the use of RAC.
RACworkload distributionparallel queryhigh availability - Question #40Partitioning
You want partitions to be automatically created when data that does not fit into current date range loaded. Which type of partitioning would you implement?
interval partitioningautomatic partition creationdate range partitioningpartitioning types - Question #41Partitioning
Identify the benefit of using interval partitioning.
interval partitioningautomatic partition creationpartition management - Question #42Introduction to Data Warehousing Concepts
You are looking to size a data warehouse configuration. If the I/O throughput for the CPUs is 25 GB/s, the I/O throughput for the HBA is 18 GB/s, and the I/O throughput for the dis...
I/O throughputperformance sizingbottleneck analysisdisk subsystem - Question #43Partitioning
What are three advantages provided by proper partitioning in a data warehouse?
partition pruningparallel joinsdata loadingpartitioning benefits - Question #44Advanced Concepts
Exadata uses smart scans, which are executed in________.
Exadatasmart scansstorage server cellsstorage offloading - Question #45Partitioning
Identify the indexing technique you would use to minimize partition maintenance.
local indexesglobal indexespartition maintenanceindex types - Question #46Partitioning
Which feature would enable higher availability during maintenance operations while also improving query response performance?
partitioninghigh availabilitymaintenance windowsquery performance - Question #47Advanced Concepts
What two types of results can be cached in the Result Set Cache?
result set cacheSQL query cachingPL/SQL function caching - Question #48Loading Data into the Data Warehouse
Knowledge Modules are:
Knowledge ModulesOracle Data IntegratorETL templatesODI - Question #49Advanced Concepts
Which Oracle option might be used to encrypt sensitive data in an Oracle data warehouse?
data encryptionAdvanced Security Optiondata warehouse security - Question #50
Which unique method of improving performance is NOT used by the Oracle Exadata Database Machine?