SKILL 3.1 PART 2 QUIZ

/in /by

QUESTION 1

  1. How many DMVs are specifically related to database performance information?

    5

    10

    15

    20

5 points   

QUESTION 2

  1. Index and IO DMVs cannot be broken out into their own category.

     

     

5 points   

QUESTION 3

  1. There are over __________DMVs that provide insight into execution-related activity within the database.

    10

    20

    30
    *b. 40

5 points   

QUESTION 4

  1. What are the primary maintenance tasks for maintaining indexes?

    Identifying and removing index fragmentation

    Identifying and creating missing indexes

    Identifying and removing unused indexes

    Identifying and updating outdated indexes and column statistics

    All of the above

    None of the above

5 points   

QUESTION 5

  1. The SQL Server Maintenance Plan Wizard creates and configures a maintenance plan that the SQL Server Agent can run either singly or on a regular schedule.

     

     

5 points   

QUESTION 6

  1. The Database Engine Tuning Advisor can be started from either SQL Server Profiler or from SQL Server Management Studio.

     

     

5 points   

QUESTION 7

  1. DBAs like to automate the following tasks.

    Backups

    Maintaining indexes

    Checking database integrity

    Managing database and disk space

    Updating statistics

    All of the above

5 points   

QUESTION 8

  1. The DBA should update statistics when:

    The performance of a query is slow

    After maintenance

    Insert operations on ascending or descending columns

    All of the above

    None of the above

5 points   

QUESTION 9

  1. Recovering from database corruption is all about applying a ________________strategy to make recovery a winning situation.

    Offensive

    Defensive

    Strategic

    None of the above

5 points   

QUESTION 10

  1. This backup strategy depends on how active a database is:

    Full backup

    Differential backup

    Transaction log backup

    None of the above

"Get Help With Your Essay
. If you need assistance with writing your essay, our professional essay writing service is here to help!

Order Now