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;
16 Cards in this Set
- Front
- Back
Involves increasing the system resources on the current server. For example, you might add additional and faster processors and more RAM as a method
of improving capacity. As an alternative, you might migrate the existing database to a newer, more powerful server |
scaling up
|
|
Enables you to increase capacity by using multiple SQL servers.
|
scaling out
|
|
What is the main difference between scaling up and scaling out?
|
Scaling up involves increasing capacity by upgrading the current hardware to more powerful hardware. Scaling out involves increasing capacity by deploying additional database servers.
|
|
A database cannot exceed _____ terabytes, no single data file can exceed ____terabytes, and you can host a maximum of _____ databases on a single instance of SQL Serve
|
524,272
16 32,767 |
|
Capacity constraints can also influence database
development, with a limit of ___columns per primary key, a maximum of ___foreign key references per table, and a maximum of ____user connections |
16
253 32,767 |
|
You can use database ______ to maintain a single standby database for a corresponding production database
|
mirroring
|
|
You can also use _____to maintain one or more warm standby databases. This type of standby database is known as a secondary database.
|
log shipping
|
|
A readable secondary database that can service reporting queries requires the use of _______availability groups
|
AlwaysOn
|
|
A benefit of _____ is that it allows you to identify hardware or I/O configuration issues before you deploy SQL Server 2012.
|
SQLIO
|
|
SQLIO allows you to measure I/O against one or more test files to measure ___per second (IOPs), ____ (MB/s), and _______
|
I/Os
throughput latency |
|
You can use ______ to perform readability and integrity tests on disk subsystems. It enables you to simulate read, write, checkpoint, backup, sort, and read-ahead activities for SQL Server 2012 deployments.
|
SQLIOSim
|
|
All editions of SQL Server 2012 have a minimum RAM requirement of _____GB except the Express editions, which have a minimum RAM requirement of ____ MB.
|
1
512 |
|
You can configure a database to shrink automatically, but this is likely to lead to _______.
|
index fragmentation
|
|
Databases use _____files (.mdf), ____ files (.ndf), and _________files (.ldf).
|
primary
secondary transaction log |
|
When SQL Server 2012 is deployed on Windows Server 2008 R2, it uses a ________account, which is a locally managed account, by default
|
virtual
|
|
You can use _____ to benchmark the I/O subsystem prior to SQL Server 2012 deployment, and you can use _______ to simulate read, write, checkpoint, backup, sort, and
read-ahead activities |
SQLIO
SQLIOSim |