itgle.com

Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.Wh

题目

Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?（）

A. Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.

B. Run the Automatic Workload Repository Monitor (ADDM).

C. Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.

D. Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.

相似考题

1.7． Hi! This is_______ new teacher．__________ name is Linda．A． your; MyB． his; YourC． your ; HerD． her; His

2.The plan ()the cooperation of young and old.A. putsB. keepsC. getsD. involves知识点: Newassignment1

3.What's ( )job? Are ( ) British?A. your, yourB. you, yourC. your, you

4.Nice to meet____(your)．

参考答案和解析
参考答案：D
更多“Your database supports a DSS workload that involves the execution of complex queries: Curr ”相关问题

  • 第1题：

    A general purpose MySQL instance is configured with the following options:—log-slow-queries—long-query-time=,0001—log-slow-admin-queries—general-log—log-bin—binlog-format=STATEMENT—innodb-flush-log-at-trx-commit=1Which three statements are true（）。

    A.The General Query Log records more data than the Binary Log

    B.The binary Log records more data than the General Query Log

    C.The Slow Query Log records more data than the General Query Log

    D.The General Query Log records more data than the Slow Query Log

    E.The Slow Query Log records more data than the Binary Log

    F.The Binary Log records more data than the Slow Query Log


    参考答案：A, D, E

  • 第2题：

    For which of the following is a data warehouse optimized?()

    A.Backup and recovery

    B.Transactions

    C.Security

    D.Queries


    参考答案：D

  • 第3题：

    （ ） – Is Miss White __________ English teacher, Maria?

    – No, she teaches __________ geography.

    A．your；my

    B．you；mine

    C．you；us

    D．your；us


    正确答案：D

  • 第4题：

    WhatisakeydifferentiatorbetweenaDS8700andDS8800foracustomerlookingforahighcapacitysolutionatthelowestcost()

    A.DS8700supportsSATAdrives

    B.DS8800supportsmorephysicaldrives

    C.DS8700supports2.5"diskdrives

    D.DS8800supports4GbpsFCdrives


    参考答案：A

  • 第5题：

    Which command will display EIGRP packets sent and received, as well as statistics on hello packets, updates, queries, replies, and acknowledgments?()

    A. debug eigrp packets

    B. show ip eigrp traffic

    C. debug ip eigrp

    D. show ip eigrp interfaces


    参考答案：B

  • 第6题：

    The committee comprises five persons.

    A:.absorbs
    B: concerns
    C: excludes
    D: involves

    答案：D
    解析：
    句意为：委员会由五个人组成。画线单词comprise意为“包含，由……组成”。absorb 意为“吸收”;concern意为“关注”;exclude意为“排除”;involve意为“包含”。根据画线单词意思，只有involve与其同义，可进行替换。因此D项正确。

相关内容