Sql Server 2012 70-462

Front 1

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

Back 1

scaling up

Front 2

Enables you to increase capacity by using multiple SQL servers.

Back 2

scaling out

Front 3

What is the main difference between scaling up and scaling out?

Back 3

Scaling up involves increasing capacity by upgrading the current hardware to more powerful hardware. Scaling out involves increasing capacity by deploying additional database servers.

Front 4

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

Back 4

524,272
16
32,767

Front 5

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

Back 5

16
253
32,767

Front 6

You can use database ______ to maintain a single standby database for a corresponding production database

Back 6

mirroring

Front 7

You can also use _____to maintain one or more warm standby databases. This type of standby database is known as a secondary database.

Back 7

log shipping

Front 8

A readable secondary database that can service reporting queries requires the use of _______availability groups

Back 8

AlwaysOn

Front 9

A benefit of _____ is that it allows you to identify hardware or I/O configuration issues before you deploy SQL Server 2012.

Back 9

SQLIO

Front 10

SQLIO allows you to measure I/O against one or more test files to measure ___per second (IOPs), ____ (MB/s), and _______

Back 10

I/Os
throughput
latency

Front 11

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.

Back 11

SQLIOSim

Front 12

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.

Back 12

1
512

Front 13

You can configure a database to shrink automatically, but this is likely to lead to _______.

Back 13

index fragmentation

Front 14

Databases use _____files (.mdf), ____ files (.ndf), and _________files (.ldf).

Back 14

primary
secondary
transaction log

Front 15

When SQL Server 2012 is deployed on Windows Server 2008 R2, it uses a ________account, which is a locally managed account, by default

Back 15

virtual

Front 16

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

Back 16

SQLIO
SQLIOSim