SKILL 3.1 PART 1 QUIZ

/in /by

QUESTION 1

  1. SQL Server requests resources from the system to execute queries.

     

     

5 points   

QUESTION 2

  1. There are __________wait types in SQL Server.

    150

    300

    600

    900

5 points   

QUESTION 3

  1. This wait type is commonly associated with disk I/O bottlenecks.

    CXPACKET

    LCK

    PAGEIOLATCH

    None of the above

5 points   

QUESTION 4

  1. This wait type is specific to the internal thread scheduling mechanism within SQL Server, and means that there are no available threads in the server’s thread pool, which can lead to queries not being run.

    WRITELOG

    THREADPOOL

    OLEDB

    PAGELATCH

5 points   

QUESTION 5

  1. A _____________is the ability to group physical disks together to form a pool of resource storage.

    Resource pool

    Storage pool

    Memory initiator

    None of the above

5 points   

QUESTION 6

  1. The majority of the waits that exist in SQL Server exist in Azure SQL Database and are grouped by:

    Resource waits

    Queue waits

    External waits

    All of the above

5 points   

QUESTION 7

  1. Which is provisioning type option?

    Fixed

    Thin

    Both A and B

    None of the above

5 points   

QUESTION 8

  1. How many storage layout options are there?

    One

    Two

    Three

    Four

5 points   

QUESTION 9

  1. A ________________backup captures only the data that has changed since the full backup.

    Partial

    Full

    Differential

    Transaction Log

5 points   

QUESTION 10

  1. A backup strategy is incomplete without backing up the system databases.

     

     

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

Order Now