• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/12

Click to flip

12 Cards in this Set

  • Front
  • Back
How many log files can you have in each filegroup?
None. Filegroups contain only data files, not log files!
How to create a filegroup?
A. alter database ... add file
B. alter database ... modify filegroup
C. alter database ... add filegroup
D. alter database ... remove filegroup
Answer: C
X=(2) Raid-1, Y=(5) Raid-5, & Z=(10) Raid-5 Storage, which is best?
A. X for OS, Y for SQL exec's, and Z for datafiles.
B. X for OS, Y for SQL exec's + data+logs, and Z for db backups.
C. X for OS + Sql exec's, Y for trans logs, and Z for datafiles.
D. X for Logs, Y for OS + Sql exec's, Z for datafiles.
Answer: C. D is incorrect because Log files are write intensive and R1 is better for reads.
Valid filegroup types.
A. Read-Only
B. Write-Only
C. Default
D. Primary
Answer: A,C, & D
Which of following are DB Mail prerequisites?
A. Service Broker
B. Database Mirroring
C. Extended MAPI Profile
D. Microsoft Exchange Server
Answer: A
Which is true for SMTP authentication mechanisms?
A. Db mail accesses SMTP using db engine service credentials by default.
B. Db mail accesses SMTP using SQL Server Agent service by default.
C. Db mail accesses SMTP using SQL Browser service credentials
D. Db mail accesses SMTP using Active Directory Helper service by default.
Answer: A
Which is true for Db Mail?
A. Db Mail account is a collection of Db mail profiles.
B. Each mail db host account must have a Db mail profile associated.
C. Db Mail profile is a collection of Mail Db Host user accounts.
D. Db Mail profile is a collection of Db Mail accounts.
Answer: D
DB Engine auto generates the service master key to encrypt what components?
Linked server passwords.
Connection Strings.
Account Credentials.
All DB Master keys.
What is the fastest data-encryption method?
Symmetric key
When do you need to specify an external data source using a linked server?
A. need to access a different database.
B. need to access a different instance.
C. access a different db schema.
D. access objects of a different user owner.
B
Needed to create a linked server?
A. OLE DB Data Source
B. ODBC Data Source
C. ODBC Provider
D. OLE DB Provider.
A & D
True about linked server security
A. Security mode is defined at the instance level.
B. Default configuration is self-mappinig.
C. Default config is delegation.
D. is defined per linked server
B & D