Study your flashcards anywhere!

Download the official Cram app for free >

  • 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/16

Click to flip

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