| Terms |
Definitions |
|
Witness Server
|
Governs automatic failover.
|
|
Registered Servers:(VIEW)
|
shows currently registered servers; allow you to switch between servers of a particular type
|
|
___ defines the character set supported for this DB.
|
Collation Sequence
|
|
Note that endpoints are used for ________connections only
|
inbound
|
|
what is the recommended file extension for Log files?
|
.ldf
|
|
Maximum transaction throughput for any database is bound by the amount of data per second that can be written to the ___________
|
Transaction logs
|
|
Conditions:
|
are the equivalent of a WHERE clause in aDML statement They define the criteria that need to be checked
|
|
job schedule properties
|
1. Frequency type2. Recurrence within a frequency3. Recurrence within a day on minute or hourly basis4. Start and end date for the schedule to be valid
|
|
Log files:
|
• Store the transactions that are executed against the database• Log the information used to recover the database• Must be at least one log file for each DB• Recommended file name extension is .ldf
|
|
true or false, BULK INSERT is faster than BCP
|
true
|
|
what option could you use to enable a best effort restore
|
CONTINUE_AFTER_ERROR
|
|
NORECOVERY option:
|
if used, db is left in a RECOVERINGstate Omits the undo phase to preserve uncommitted transactions Allows you to apply differential and/or transaction log backups
|
|
how many trace modules do you get in SQL Server?
|
9
|
|
what does the merge operator do?
|
it drops a partition
|
|
What was it called when delegates from all colonies except Georgia met to discuss problems with Great Britain and to promote independence?
|
Continental Congress
|
|
Creating a Partitioned Table, Assign the table to a partition scheme
|
by using the ON clause
|
|
name two options for performing transactional replication?
|
immediate update and queued update
|
|
T or F, you can recover to a specific point in time using Simple Recovery Model
|
False
|
|
Analysis Services Deployment Wizard:
|
to deploy the output from an Analysis Services project to a target server
|
|
if there are 9 boundary points, how many partitions are there?
|
10 partitions,partition function create one more partition than the number of boundary points you defined
|
|
what is the name that is unique number assigned to every row in the transaction log
|
LSN, Log Sequence Number
|
|
name 4 commonly used criteria for horizontally partitioning data?
|
1. date ranges2. price ranges3. integer ranges4. character-based values
|
|
during a restore, how do you make sure that the database doesn't go online immediately
|
you use the NORECOVERY option
|
|
true or false, during the Sliding Window Effect, the table goes offline & is unavailable throughout the process
|
false, the tables stays online & available throughout the process
|
|
what are the five agents used in replication?
|
1. Snapshot Agent2. Log Reader Agent3. Distribution Agent4. Merge Agent5. Queue Reader Agent
|
|
Profiler lets you load both _______ and ______
|
trace logs and Perf Mon logs (you need the start time)
|
