Update 1Z0-417 Preparation 2021

NEW QUESTION 1
The IT team said that a system appeared OK based on their third-party network and systems management tool; yet customers continue to complain of database performance- related issues. Which two would you implement to find and fix the problem?

• A. Oracle Real User Experience Insight
• B. Oracle Application Testing Suite
• C. Oracle Exadata
• D. Oracle Real Application Clusters
• E. Oracle Diagnostic and Tuning Pack for Oracle Database

Answer: DE

NEW QUESTION 2
SQL Access Advisor takes database workload as input and recommends adding various access structures. Which three does it consider the impact of adding when it generates recommendations?

• A. Materialized views
• B. Indexes
• C. Partitions
• D. Tablespaces
• E. V$ performance views
• F. Hints

Answer: BDE

NEW QUESTION 3
Which is the default statistics gatheringperiod for Automatic Database Diagnostics Monitoring (ADDM)?

• A. every 30 seconds
• B. every 60 minutes
• C. every 30 minutes
• D. every 24 hours
• E. every 40 hours

Answer: A

NEW QUESTION 4
Which one would SQL Access Advisor use as input to provide a recommendation on a partition or index?

• A. SQL Tuning Advisor
• B. Automatic Workload Repository
• C. Automatic Diagnostic Monitor
• D. SQL Tuning Set
• E. SQL Error

Answer: A

NEW QUESTION 5
Which two statements are true about Automatic Statistics collection by the Optimizer?

• A. Statistics are collected during automatic maintenance tasks.
• B. Any fixed objects are disregarded.
• C. Any external tables are incorporated.
• D. All tables in the data dictionary are included by defaults.
• E. Statistics are gathered after table statistics are marked stale.

Answer: AE

Explanation:
Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28274/stats.htm

NEW QUESTION 6
For which two capabilities would you implement Segment Advisor in order to aid a customer trying to find and fix performance issues related to database space?

• A. to determine if objects have unusedspace that can be released
• B. to advise if materialized views can be used to reduce size of views
• C. to review space usage of individual schema objects or tablespaces
• D. to advise if there are any duplicate indexes and automate their removal
• E. to identify any fragmentation in the database cache or swap space

Answer: AC

NEW QUESTION 7
Starting with Oracle Database 11gR2, which are two additional partitioning capabilities that aid Oracle Database Performance and Tuning?

• A. Hash Partitioning
• B. Reference Partitioning
• C. Composite Partitioning
• D. Interval Partitioning
• E. Disk Partitioning

Answer: CD

NEW QUESTION 8
Which four use cases could Database Replay be used to test for database performance changes?

• A. a change in operating system versions
• B. compare Flashback workload
• C. check a workload from a single instance on an Oracle RAC database
• D. check a workload after database parameters have been changed
• E. check a workload from one database release on another database released
• F. upgrade an application

Answer: BCDE

NEW QUESTION 9
As of Oracle Database 12c, which functionality to access database diagnostic and performance has been superseded by Oracle Enterprise Manager Database Express?

• A. SQL Developer
• B. SQL Plus
• C. Database console
• D. SQL Express
• E. Grid Control

Answer: C

Explanation:
Reference: http://dbaora.com/enterprise-manager-database-express-oracle-database-12c- release-1-12-1/

NEW QUESTION 10
Which one is a type of user session and client request supported by Database Replay?

• A. XA transactions
• B. Oracle Call Interface (OCI) based object navigations
• C. SQL-based object access
• D. Flashback queries
• E. Database Resident Connection Pooling (DRCP)

Answer: C

Explanation:
Reference: https://docs.oracle.com/cd/E11882_01/server.112/e41481/dbr_capture.htm#RATUG115

NEW QUESTION 11
Which option is recommended when gathering Optimizer system statistics on a regular basis to ensure optimal performance?

• A. lock out user sessions and gather system statistics overnight
• B. gather system statistics after a performance issue has been reported
• C. gather system statistics for several hours when there is no workload
• D. gather system statistics for several hours during normal workload periods
• E. shut down any running applications prior to collection

Answer: D

Explanation:
Reference: https://docs.oracle.com/database/121/TGSQL/tgsql_stats.htm#TGSQL398

NEW QUESTION 12
Which is a capability that Active Session History (ASH) reports enable you to perform?

• A. Compare database performance between two periods of time, and resolve performance degradation thatmay happen from one time period to another.
• B. Analyze transient performance problems with the database that are short-lived and do not appear in theADDM analysis.
• C. Optimize the performance of data access paths by creating the proper set of materialized views,materialized view logs, and indexes for a given workload.
• D. Analyze transient performance problems that have happened in the database since it has been started.

Answer: A

NEW QUESTION 13
For which one would you use an index fast full scan to improve performance?

• A. a query having all the columns of an index in the where clause
• B. a query that does not need to access table rows
• C. a query that needs to access table rows along with an index
• D. a column in an index that is compressed

Answer: A

Explanation:
All of the columns required by SQL must reside in the index tree; that is, all columns in the SELECT and WHERE clauses must exist in the index.
Reference: http://www.dba-oracle.com/t_index_fast_full_scan.htm

NEW QUESTION 14
Which action can beperformed by using Oracle Enterprise Manager Database Express Performance Hub?

• A. View health status and performance of an Oracle Database instance via Database Control.
• B. Launch and view STATSPACK reports.
• C. View real-time and historical Oracle Database performance information.
• D. View only real-time Oracle Database performance information.
• E. View only historical Oracle Database performance information.
• F. Consolidate ADDM, AWR, and ASH repositories within an enterprise and enable centralized performancereporting.

Answer: C

NEW QUESTION 15
Which is a true statement about the difference in the functionality of Active Session History (ASH) and SQL Trace/TKPROF?

• A. ASH provides time based data, SQL Trace/TKPROF does not
• B. ASH provides detailed session level data, SQL Trace/TKPROF does not
• C. ASH is always on, SQL Trace/TKPROF is not
• D. ASH identifies Bind variables that are available, SQL Trace/TKPROF does not
• E. ASH counts and has occurrence data, SQL Trace/TKPROF does not

Answer: B

NEW QUESTION 16
Which option do customers need to license in order to implement SQL Performance Analyzer and Database Replay functionalities?

• A. Oracle Database Diagnostics Pack for Oracle Database
• B. Oracle Database Replay and Testing Suite
• C. Oracle SQL Developer
• D. Oracle Real Application Testing
• E. Oracle SQL Tuning Pack for Oracle Database

Answer: D

Explanation:
Reference: https://docs.oracle.com/cd/B19306_01/license.102/b14199/options.htm

NEW QUESTION 17
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

NEW QUESTION 18
What are three activities an Oracle Database Performance and Tuning solution enables a customer to perform?

• A. standardize database troubleshooting and diagnostics
• B. control database clouds.
• C. automate database performance management
• D. perform global database backup
• E. outsource database operations
• F. replay and test actual workloads to assure database performance and consolidatios.

Answer: CDE

NEW QUESTION 19
Instead of a database automatically publishing statistics when statistics collection ends, you want to test queries a satisfactory result before they are made available to the entire database. Which would you configure for that to occur?

• A. SetOPTIMIZER_USE_PENDING_STATISTICStoTRUE.
• B. SetAUTO_UPDATE_STATISTICStoFALSE.
• C. Use aHOLD HINTin the SQL.
• D. SetAUTOMATIC_WORKLOAD_REPOSITORY_COLLECTIONtoPAUSE.

Answer: A

NEW QUESTION 20
Select two scenarios that an Oracle Database Performance and Tuning solution implementation addresses.

• A. After migration off a legacy system, an ERP team complains that they have no ability to isolate performanceproblems in the new distributed Oracle Database architecture.
• B. An HR Team claims that it can hire staff fast enough to meet business demands.
• C. Development Team members demand that their SQL should run fast while the DBAs blame SQL as theroot of performance issues.
• D. To prepare for an upcoming code audit, developers need to review their SQL and PL/SQL code for syntaxand runtime errors.
• E. Systems and Storage teams report that over the past 12 month, it is taking 40% longer time to back up theservers with Oracle databaseson them.

Answer: BC

NEW QUESTION 21
An Oracle Database customer's VP of Development mentions that they've moved to AGILE development methodology and DevOps requires an ability to view, test, or validate performance in their own development environment. Which two do you implement?

• A. Oracle Application Infrastructure Tester
• B. Oracle Application Testing Suite
• C. SQL Developer
• D. Oracle Real Application Testing
• E. APEX and SQL Developer
• F. Oracle Testing Pack

Answer: BD

NEW QUESTION 22
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 willdisable that process upon database boot.
• C. Using the appropriate architectureimplement 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 databaseand forward database monitoring SNMP traps.

Answer: BE

NEW QUESTION 23
Which are two strategies to maintain performance and improve a table segment's compression ratio when you are using Advanced Row Compression on a table segment?

• A. Use smaller database block size.
• B. Use larger database block size.
• C. Use direct-path inserts wherepossible.
• D. IncreasePCTFREEon the table segment.
• E. Increase the size of the tablespace.

Answer: AE

NEW QUESTION 24
......