多选题Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）AChange in the Oracle Database versionBChange in your network infrastructureCChange in the hardware config

题目
多选题
Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）
A

Change in the Oracle Database version

B

Change in your network infrastructure

C

Change in the hardware configuration of the database server

D

Migration of database storage from non-ASM to ASM storage

E

Database and operating system upgrade

相似考题

1.Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.()A. Change in the Oracle Database versionB. Change in your network infrastructureC. Change in the hardware configuration of the database serverD. Migration of database storage from non-ASM to ASM storageE. Database and operating system upgrade

2. You are analyzing the performance of a SQL Azure database.   You need to recommend an approach for identifying the indexes that should be added to improve database performance.  What should you recommend？（）A、 Use SQL Server Profiler to identify missing indexes.B、 Use the Database Engine Tuning Advisor to identify missing indexes.C、 Use a Dynamic Management View to analyze query plans.D、 Use a DynamicManagement View to ascertain the number of pending I/O requests.

3. A Windows Azure application connects to a SQL Azure database.  The database size has increased significantly.   Some queries in the application no longer complete.   You need to recommend an approach for identifying queries that do not complete.  What should you recommend？（）A、 Use the SQL Server Profiler to capture all SQL activities.B、 Use a Dynamic Management View to analyze performance.C、 Use the Database Engine Tuning Advisor to analyze the workload.D、 Use Microsoft SQL Server Management Studio to analyze the SQL logs.

4.Your database supports an online transaction processing (OLTP) application.The application is undergoing some major schema changes, such as addition of new indexes and materialized views.You want to check the impact of these changes on workload performance.What should you use to achieve this?（）A. Database replayB. SQL Tuning AdvisorC. SQL Access AdvisorD. SQL Performance AnalyzerE. Automatic Workload Repository compare reports

参考答案和解析
正确答案： E,D
解析： 暂无解析
更多“多选题Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）AChange in the Oracle Database versionBChange in your network infrastructureCChange in the hardware config”相关问题

  • 第1题：

    You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the Oracle database（）

    • A、Use the external table population.
    • B、Use the Oracle Data Pump export and import utility.
    • C、Use the conventional path data load of the SQL*Loader utility.
    • D、Use the INSERT INTO...SELECT command to load the data

    正确答案:C

  • 第2题：

    Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets （STS） from the previous version. After changing the  OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer， you observed performance regression for a few SQL statements.  What would you do with these SQL statements？（）

    • A、 Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.
    • B、 Capture the plans from the previous version using STS and then load them into the stored outline.
    • C、 Capture the plans from the previous version using STS and then load them into SQL Management Base （SMB）
    • D、 Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

    正确答案:C

  • 第3题：

    You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database.  While migrating the data， you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database（）

    • A、Use the external table population.
    • B、Use the Oracle Data Pump export and import utility.
    • C、Use the conventional path data load of the SQL*Loader utility.
    • D、Use the INSERT INTO...SELECT command to load the data.

    正确答案:C

  • 第4题：

    Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements. What would you do with these SQL statements?（）

    • A、Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.
    • B、Capture the plans from the previous version using STS and then load them into the stored outline.
    • C、Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB).
    • D、Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

    正确答案:C

  • 第5题：

    Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）

    • A、Change in the Oracle Database version
    • B、Change in your network infrastructure
    • C、Change in the hardware configuration of the database server
    • D、Migration of database storage from non-ASM to ASM storage
    • E、Database and operating system upgrade

    正确答案:A,C,E

  • 第6题：

    You are a database administrator for your company. The company runs a popular database-driven Web site against a SQL Server 2005 computer named SQL2. You need to ensure a quick response time and appropriate audit trail in the event that SQL2 experiences excessive traffic due to denial-of-service （DoS） attacks. Which two actions should you perform？（）

    • A、Create a new performance alert to monitor the Current Bandwidth counter.
    • B、Create a new performance alert to monitor the Bytes Total/sec counter.
    • C、Configure the new performance alert to start a SQL Server Profiler trace.
    • D、Configure the new performance alert to start a Network Monitor capture.

    正确答案:B,D

  • 第7题：

    多选题
    You are a database administrator for your company. The company runs a popular database-driven Web site against a SQL Server 2005 computer named SQL2. You need to ensure a quick response time and appropriate audit trail in the event that SQL2 experiences excessive traffic due to denial-of-service （DoS） attacks. Which two actions should you perform？（）
    A

    Create a new performance alert to monitor the Current Bandwidth counter.

    B

    Create a new performance alert to monitor the Bytes Total/sec counter.

    C

    Configure the new performance alert to start a SQL Server Profiler trace.

    D

    Configure the new performance alert to start a Network Monitor capture.


    正确答案： A,C
    解析： 暂无解析

  • 第8题：

    单选题
    A Windows Azure application retrieves data from SQL Azure.   You need to recommend an approach for improving application query performance.  What should you recommend？（）
    A

     Create a database view to retrieve the data.

    B

     Use a clustered index on the SQL Azure database tables.

    C

     Open a new database connection when an operation times out.

    D

     Create SQL Azure database table indexes basedon application queries


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the Oracle database（）
    A

    Use the external table population.

    B

    Use the Oracle Data Pump export and import utility.

    C

    Use the conventional path data load of the SQL*Loader utility.

    D

    Use the INSERT INTO...SELECT command to load the data


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables.  While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）
    A

    use the external table population

    B

    use the Oracle Data Pump export and import utility

    C

    use the conventional path data load of SQL*Loader utility

    D

    use the direct path data load of Oracle export and import utility


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    A Windows Azure application connects to a SQL Azure database.  The database size has increased significantly.   Some queries in the application no longer complete.   You need to recommend an approach for identifying queries that do not complete.  What should you recommend？（）
    A

     Use the SQL Server Profiler to capture all SQL activities.

    B

     Use a Dynamic Management View to analyze performance.

    C

     Use the Database Engine Tuning Advisor to analyze the workload.

    D

     Use Microsoft SQL Server Management Studio to analyze the SQL logs.


    正确答案： C
    解析： 暂无解析

  • 第12题：

    多选题
    Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）
    A

    Change in the Oracle Database version

    B

    Change in your network infrastructure

    C

    Change in the hardware configuration of the database server

    D

    Migration of database storage from non-ASM to ASM storage

    E

    Database and operating system upgrade


    正确答案： A,E
    解析： 暂无解析

  • 第13题：

    You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance.  Which advisor would you use to determine the suitable size of the SGA？（）

    • A、 SQL Tuning Advisor
    • B、 Undo Advisor
    • C、 ADDM
    • D、 Memory Advisor

    正确答案:D

  • 第14题：

    Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?（）

    • A、Database replay
    • B、SQL Tuning Advisor
    • C、SQL Access Advisor
    • D、SQL Performance Analyzer
    • E、Automatic Workload Repository compare reports

    正确答案:E

  • 第15题：

    You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）

    • A、use the external table population
    • B、use the Oracle Data Pump export and import utility
    • C、use the conventional path data load of SQL*Loader utility
    • D、use the direct path data load of Oracle export and import utility

    正确答案:C

  • 第16题：

    You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance？（）

    • A、run Segment Advisor
    • B、run SQL Tuning Advisor on top SQL statements
    • C、run the Automatic Workload Repository （AWR） report
    • D、run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements

    正确答案:B

  • 第17题：

    A Windows Azure application connects to a SQL Azure database.  Connections to the database are being dropped due to throttling.   You need to recommend an approach for identifying the root cause of the problem.   Which two actions should you recommend？（）

    • A、 Use Dynamic Management Views to analyze performance issues.
    • B、 Decrease the connection timeout in the database connection string.
    • C、 Make sure the application is closing database connections that are not needed.
    • D、 Use SQL Profiler to analyze performance issues by configuring it to connect to SQL Azure.

    正确答案:A,C

  • 第18题：

    A Windows Azure application retrieves data from SQL Azure.   You need to recommend an approach for improving application query performance.  What should you recommend？（）

    • A、 Create a database view to retrieve the data.
    • B、 Use a clustered index on the SQL Azure database tables.
    • C、 Open a new database connection when an operation times out.
    • D、 Create SQL Azure database table indexes basedon application queries

    正确答案:D

  • 第19题：

    单选题
    You work in a data warehouse environment that involves the execution of complex queries. The current content of the SQL cache holds the ideal workload for analysis. You want to analyze only few most resource-intensive statements. What would be your suggestion to receive recommendations on the efficient use of indexes and materialized views to improve query performance？（）
    A

    Run the SQL Access Advisor.

    B

    Run the SQL Tuning Advisor （STA）.

    C

    Run the Automatic Workload Repository （AWR） report.

    D

    Run the Automatic Database Diagnostic Monitor （ADDM）.


    正确答案： B
    解析： 暂无解析

  • 第20题：

    单选题
    You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database.  While migrating the data， you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database（）
    A

    Use the external table population.

    B

    Use the Oracle Data Pump export and import utility.

    C

    Use the conventional path data load of the SQL*Loader utility.

    D

    Use the INSERT INTO...SELECT command to load the data.


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance.  Which advisor would you use to determine the suitable size of the SGA？（）
    A

     SQL Tuning Advisor

    B

     Undo Advisor

    C

     ADDM

    D

     Memory Advisor


    正确答案： C
    解析： 暂无解析

  • 第22题：

    多选题
    A Windows Azure application connects to a SQL Azure database.  Connections to the database are being dropped due to throttling.   You need to recommend an approach for identifying the root cause of the problem.   Which two actions should you recommend？（）
    A

    Use Dynamic Management Views to analyze performance issues.

    B

    Decrease the connection timeout in the database connection string.

    C

    Make sure the application is closing database connections that are not needed.

    D

    Use SQL Profiler to analyze performance issues by configuring it to connect to SQL Azure.


    正确答案： C,A
    解析： 暂无解析

  • 第23题：

    单选题
    You are analyzing the performance of a SQL Azure database.   You need to recommend an approach for identifying the indexes that should be added to improve database performance.  What should you recommend？（）
    A

     Use SQL Server Profiler to identify missing indexes.

    B

     Use the Database Engine Tuning Advisor to identify missing indexes.

    C

     Use a Dynamic Management View to analyze query plans.

    D

     Use a DynamicManagement View to ascertain the number of pending I/O requests.


    正确答案： A
    解析： 暂无解析

  • 第24题：

    单选题
    Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets （STS） from the previous version. After changing the  OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer， you observed performance regression for a few SQL statements.  What would you do with these SQL statements？（）
    A

     Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.

    B

     Capture the plans from the previous version using STS and then load them into the stored outline.

    C

     Capture the plans from the previous version using STS and then load them into SQL Management Base （SMB）

    D

     Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.


    正确答案： C
    解析： 暂无解析

相关内容