1Z0-417 Oracle Database Performance and Tuning Essentials 2015

Oracle

Exam Number: 1Z0-417
Exam Title: Oracle Database Performance and Tuning Essentials 2015
Associated Certification Paths Oracle Database Performance and Tuning 2015 Certified Implementation Specialist
Duration: 120 minutes
Number of Questions: 82
Passing Score: 75%
Validated Against: This exam is validated against Oracle Database 12c.
Format: Multiple Choice

Complete Recommended Training

Complete the training below to prepare for your exam (optional):
Oracle Database 12c: New Features for Administrators
Oracle Database: Introduction to SQL
Oracle Database: SQL Workshop I
Oracle Database: SQL and PL/SQL Fundamentals
Oracle Database 12c: Admin, Install and Upgrade Accelerated
Oracle Database 12c: Backup and Recovery Workshop
Oracle Database 12c: Managing Multitenant Architecture

Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.

Exam Study Guide (PDF)
Oracle Database 12c Implementation Specialist Guided Learning Path

Product / Solution Overview
Describe Oracle’s solution for database performance and tuning and its fit in Oracle’s strategy
Describe and summarize product history and the future public road map
Differentiate Oracle product technology for database performance within the Oracle portfolio, competitive marketplace and the opportunity available to partners.
Describe what it requires to get started with an Oracle Database Performance solution and the minimum and typical environment required

Positioning the Solution
Identify and construct probing questions that help position and match Oracle technology to database performance needs
Describe Oracle product technology that addresses the market trends and business dynamics driving the customer requirements
Describe key positioning statements for an Oracle Database Performance solution
Describe the value proposition for an Oracle Database solution and how the solution benefits and impacts a customer’s financial position (i.e. top-line and bottom-line)

Product Area Features and Functions for Technical Individuals
Describe product technologies and major capabilities that make up an Oracle Database Performance and Tuning Solution
Provide a high level overview of key hardware and software product components for an Oracle Database Performance solution
Describe key features, functions, terminology unique to Oracle’s solution including:
Oracle Performance Tuning Method , DB Time Model
Oracle Database Performance and Diagnostic Product Technology and Solution Capabilities
Oracle Enterprise Manager Database Express
Additional Database Performance functionality capability gained by using Oracle Enterprise Manager Cloud Control
Identify and map features, capabilities, and benefits to customer business needs and requirement scenarios

Architecture
Identify the type of hardware on which the solution / product runs for specific customer scenarios.
Outline the system requirements needed to architect and build an Oracle Database Performance and Tuning solution in single tenant, multitenant and non-CDB environments. Identify reference sources of architecture and best practices
Describe Oracle Product Technology architecture models that could be used for an Oracle Database Performance and Tuning solution including:
AWR, ADDM, ASH, and Database Express architecture
Real Application Testing architecture
Real User Experience Insight architecture
Oracle Application Testing architecture
Integration: Oracle Enterprise Manager Cloud Control architecture
Relate integration options and abilities available for an Oracle Database Performance solution

Solution Implementation – Installation, Configuration
Outline requirements and plan environment readiness for implementation of an Oracle Database Performance and Tuning solution
Implement Oracle Performance and Tuning product technology including installation and configuration
Test and validate that installation and configuration was successful

Performance Diagnostics and Monitoring, Best Practices
Define and apply database performance troubleshooting techniques using Oracle Database Performance and Tuning solution and Oracle Database capabilities for:
AWR, ADDM, ASH
Database Express Performance Hub
Define and apply database performance troubleshooting techniques using overall Oracle Database Performance and Tuning solution optional capabilities for:
Application, database, middleware, network, system, storage
Real User Experience Monitoring
View and modify parameters used to configure Oracle database performance using an Oracle Database Performance and Tuning solution
Define setup, and run database performance reporting using an Oracle Database Performance and Tuning solution
Automate database performance reporting using an Oracle Database Performance and Tuning solution

Performance Tuning, Best Practices
Analyze and apply database performance tuning using an Oracle Database Performance and Tuning solution capabilities including:
SQL Tuning Advisor
SQL Access Advisor
Segment Advisor and object reorganization
View and modify SQL to tune Oracle database performance using an Oracle Database Performance and Tuning solution
Define, setup, and automate SQL performance tuning using an Oracle Database Performance and Tuning solution

Performance Testing, Best Practices
Test database performance using an Oracle Database Performance and Tuning solution including:
SQL Performance Analyzer
Database Replay
Synthetic User Monitoring
Functional Testing, Load Testing and Test Management
View, test and validate Oracle database performance using an Oracle Database Performance and Tuning solution
Define, setup, and automate database performance testing using an Oracle Database Performance and Tuning solution

Use Cases, Scenarios
Identify common Oracle Database Performance and Tuning use cases for:
Monitoring performance
Performing database performance Health Checks
Maintaining database availability and Service Levels
Database Performance Diagnostics and Troubleshooting
SQL Tuning
Identify applicable Oracle Database Performance product technology for use cases
Describe implementation scenarios and options for an Oracle Database Performance solution

QUESTION 1
You need to load SQL statements from a time period of optimal performance to compare against a time period
that performance was reported as poor. Which functionality would you use to accomplish that task?

A. Optimizer Statistics Comparator
B. Dynamic Baseline Advisor
C. Automatic Workload Repository Baselines
D. SQL Tuning Sets
E. Database Replay

Answer: D

QUESTION 2
Which option would you use to capture workloads from one or more systems concurrently and then play them back?

A. Automatic Workload Repository
B. Enterprise Manager Cloud Control
C. Consolidated Database Replay
D. Consolidation Planner
E. Workload Consolidator and Playback

Answer: C

QUESTION 3
Upon migration to Oracle Database 12c, a customer asked that monitoring at an individualdatabase level be
disabled in favor of database performance monitoring consolidated and centralized across their enterprise.
Which are two actions you would take to meet the customer’s requirements?

A. Disable Oracle Enterprise Manager Database Express by setting the HTTP Port to 0.
B. For the always active Oracle Enterprise Manager Database Express process, create a script that will disable that process upon database boot.
C. Using the appropriate architecture implement Oracle Enterprise Manager.
D. Delete the “express” directory in Oracle Home to disable Oracle Enterprise Manager Database Express.
E. Changes permissions of the “express” directory to real only by root.
F. Enable SNMP and configure MIBS on each database and forward database monitoring SNMP traps.

Answer: B,E

QUESTION 4
What two statements are true when you are using SQL Tuning Advisor and create a SQL Profile to improve performance of a SQL statement issued by a packaged application?

A. You need to regularly run SQL Tuning Advisor to verify if the SQL Profile can be replaced with a better one.
B. After a SQL Profile is created, it will then run efficiently for the life of the database.
C. The SQL Profile rewrites the SQL Statement issued by theapplication so it appears to the Optimizer as aperfectly written SQL statement.
D. You can have only one SQL Profile active at one time for a single SQL statement.
E. You need Oracle Database 12c or later to use SQL Profiles.
F. SQL Profiles can be used for non-Oracle databases like Microsoft SQL Server, if the Tuning Pack islicensed.

Answer: A,E

QUESTION 5
Which two situations help to identify that a customer as already using Oracle Diagnostics Pack for Oracle Database functions?

A. The customer has Enterprise Manager installed on a separate server and regularly accesses the
Databasehome page of some of its Enterprise Edition databases from its console.

B. A customer says that he or she doesn’t use Enterprise Manager, but you learn that the customer
routinelyexecutesawrrpt.sqlfrom the SQLPlus prompt.

C. A customer has theCONTROL_MANAGEMENT_PACK_ACCESSinitialization parameter set
toDIAGNOSTIC +TUNING.

D. A customer says that he or she doesn’t use Enterprise Manager, but you learn that the customer has
SQLscripts that access theDBA_HIST_ACTIVE_SESS_HISTORYdatabase view.

E. A customer says that he or she doesn’t use theEnterprise Manager, but you learn that the customer
usescustomized SQL scripts that accessV$SESSIONandV$SQLviews.

Answer: C,D

Click here to view complete Q&A of 1Z0-417 exam
Certkingdom Review, Certkingdom PDF Torrents