Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
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
|
