Question 1

The ______________ prompt provides a means of installing SQL Server 2012 by referencing parameters in a text configuration file.

Accepted Answer

The answer of The ______________ prompt provides a means of...

Question 2

Which of the following is a high-availability and disaster recovery solution available in SQL Server 2012?

Accepted Answer

A) AlwaysOn 
B) SystemRecovery 
C) HighTolerance 
D) ClusterService 
A) AlwaysOn 
B) SystemRecovery 
C) HighTolerance 
D) ClusterService

Question 3

Which of the following is NOT true about an SQL Server 2012 installation?

Accepted Answer

A) there is an installation wizard 
B) you can install from the command prompt 
C) you can use SysPrep for rapid deployment 
D) the wizard provides an unattended install option 
A) there is an installation wizard 
B) you can install from the command prompt 
C) you can use SysPrep for rapid deployment 
D) the wizard provides an unattended install option

Question 4

Integration Services is the core service component of SQL Server 2012.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is the core service component of SQL Server 2012?

Accepted Answer

A) user databases 
B) database engine 
C) graphical interface 
D) reporting services 
A) user databases 
B) database engine 
C) graphical interface 
D) reporting services

Question 6

Match between columns
                        Premises: A data mining and analytical component of SQL Server 2012
A SQL Server 2012 component that provides extract, transform, and load capabilities
A database setting that specifies the character set, sort order behavior, and how characters are evaluated in comparison operations
The instance of SQL Server 2012 to which a client who connects to the database will connect to if they don? 't specify a named instance
A database instance on a server other than the default instance
A SQL Server 2012 component that provides a centralized means to manage and validate data
A component of AlwaysOn functionality
A set of redundant nodes that can be used to host the database instance
A configuration value associated with a particular Windows software application
An auto-managed local service account

Accepted Answer

The Answer of default instance and collation and virtual account is...

Question 7

What are the two categories of database hosted on an SQL Server and what type of information do they hold?

Accepted Answer

The database engine hosts several system

Question 8

Which feature of SQL Server 2012 provides a failover environment consisting of a group of primary user databases with up to four replicas?

Accepted Answer

A) FCI 
B) AG 
C) ETL 
D) IS 
A) FCI 
B) AG 
C) ETL 
D) IS

Question 9

List, in order the SQL Server 2012 installation planning steps.

Accepted Answer

Business requirements SQL Serv

Question 10

How should SQL services be configured with respect to service accounts?

Accepted Answer

A) use a single managed service account for all services 
B) use the Authenticated Users account for all services 
C) use a separate service account for each service 
D) use the default Windows service account 
A) use a single managed service account for all services 
B) use the Authenticated Users account for all services 
C) use a separate service account for each service 
D) use the default Windows service account

The ______________ prompt provides a means of installing SQL Server 2012 by referencing parameters in a text configuration file.

Which of the following is a high-availability and disaster recovery solution available in SQL Server 2012?

Which of the following is NOT true about an SQL Server 2012 installation?

Integration Services is the core service component of SQL Server 2012.

Which of the following is the core service component of SQL Server 2012?

What are the two categories of database hosted on an SQL Server and what type of information do they hold?

Which feature of SQL Server 2012 provides a failover environment consisting of a group of primary user databases with up to four replicas?

List, in order the SQL Server 2012 installation planning steps.

How should SQL services be configured with respect to service accounts?

Introduction to SQL Server 2012

Architecture and Configuration

Creating SQL Server 2012 Databases

Transact:SQL Primer

SQL Server Security

Performance Monitoring and Optimization

Backup and Recovery

Data Integration

Monitoring SQL Server 2012

Filters

Exam 2: Deploying SQL Server 2012

The ______________ prompt provides a means of installing SQL Server 2012 by referencing parameters in a text configuration file.

Which of the following is a high-availability and disaster recovery solution available in SQL Server 2012?

Which of the following is NOT true about an SQL Server 2012 installation?

Integration Services is the core service component of SQL Server 2012.

Which of the following is the core service component of SQL Server 2012?

What are the two categories of database hosted on an SQL Server and what type of information do they hold?

Which feature of SQL Server 2012 provides a failover environment consisting of a group of primary user databases with up to four replicas?

List, in order the SQL Server 2012 installation planning steps.

How should SQL services be configured with respect to service accounts?

Introduction to SQL Server 2012

Architecture and Configuration

Creating SQL Server 2012 Databases

Transact:SQL Primer

SQL Server Security

Performance Monitoring and Optimization

Backup and Recovery

Data Integration

Monitoring SQL Server 2012

Filters