Question 1

How should SQL services be configured with respect to service accounts?&#10;A)use a single managed service account for all services&#10;B)use the Authenticated Users account for all services&#10;C)use a separate service account for each service&#10;D)use the default Windows service account

Accepted Answer

Each SQL service should have its own service account for better security and auditing purposes. Using a single managed service account or the default Windows service account can be a security risk as it gives too much access to multiple services. Using the Authenticated Users account is also not recommended as it gives too much access to other users.

Question 2

Which of the following is NOT a setup type for SQL Server 2012?&#10;A)install&#10;B)patch&#10;C)upgrade&#10;D)uninstall

Accepted Answer

"Patch" is not a setup type for SQL Server 2012. The other three options (install, upgrade, and uninstall) are all valid setup types for SQL Server 2012.

Question 3

Which SQL Server 2012 component provides a centralized means to manage and validate data?&#10;A)Failover Cluster Instance&#10;B)Reporting Services&#10;C)Analysis Services&#10;D)Master Data Services

Accepted Answer

Master Data Services (MDS) provides a centralized means to manage and validate data by creating a master data hub that can be used by various applications to ensure consistency and accuracy of data.

Question 4

You can uninstall an individual instance of shared SQL Server features on a host.

Accepted Answer

Yes, it is possible to uninstall an individual instance of shared SQL Server features on a host using Programs and Features in the Control Panel.

Question 5

______________ databases contain the data associated with a client application.

Accepted Answer

The answer of ______________ databases contain the data associated with...

Question 6

Which of the following is a high-availability and disaster recovery solution available in SQL Server 2012?&#10;A)AlwaysOn&#10;B)SystemRecovery&#10;C)HighTolerance&#10;D)ClusterService

Accepted Answer

AlwaysOn is a high-availability and disaster recovery solution available in SQL Server 2012. SystemRecovery and HighTolerance are not specific solutions offered by SQL Server 2012. ClusterService is a general term and does not specifically refer to a solution in SQL Server 2012.

Question 7

Which of the following is NOT true about an SQL Server 2012 installation?&#10;A)there is an installation wizard&#10;B)you can install from the command prompt&#10;C)you can use SysPrep for rapid deployment&#10;D)the wizard provides an unattended install option

Accepted Answer

The installation wizard in SQL Server 2012 does not provide an unattended install option. Unattended installations are typically performed using the command prompt with a configuration file, not through the graphical installation wizard.

Question 8

What happens if a client connects to the database server without specifying a named instance?&#10;A)a new instance is created&#10;B)it connects to the default instance&#10;C)the client application is terminated&#10;D)the user is prompted for a named instance

Accepted Answer

If the client does not specify a named instance, it will automatically connect to the default instance of the database server.

Question 9

It's best to just install SQL Server 2012 using default settings and fine-tune it later.

Accepted Answer

It is recommended to customize the installation based on the specific requirements and resources of the system. This can include configuring instance settings, security options, and database options.

Question 10

Microsoft recommends that SQL server be installed on a ____________ server that is not shared with other Windows services.

Accepted Answer

The answer of Microsoft recommends that SQL server be installed...

Question 11

SQL Server 2012 stores the majority of configuration values within one of the user databases that was created automatically during installation.

Accepted Answer

The answer of SQL Server 2012 stores the majority of...

Question 12

User databases contain data associated with a client application.

Accepted Answer

The answer of User databases contain data associated with a...

Question 13

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 14

Which of the following is the first step in SQL Server 2012 installation planning?&#10;A)Edition and licensing model selection&#10;B)Hardware and software design&#10;C)Business requirements&#10;D)Feature identification

Accepted Answer

The answer of Which of the following is the first...

Question 15

Which of the following is the core service component of SQL Server 2012?&#10;A)user databases&#10;B)database engine&#10;C)graphical interface&#10;D)reporting services

Accepted Answer

The answer of Which of the following is the core...

Question 16

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

Accepted Answer

The answer of Integration Services is the core service component...

Question 17

Which of the following is a recommendation for installing SQL Server 2012 for optimal logical security?&#10;A)install it on a dedicated server not shared with other services&#10;B)install it on hardware with appropriate physical access controls&#10;C)install it on a domain controller&#10;D)install it on a server with several other services

Accepted Answer

The answer of Which of the following is a recommendation...

Question 18

The database engine hosts several _______________ databases, created during the installation process.

Accepted Answer

The answer of The database engine hosts several _______________ databases,...

Question 19

Which feature of SQL Server 2012 provides a failover environment consisting of a group of primary user databases with up to four replicas?&#10;A)FCI&#10;B)AG&#10;C)ETL&#10;D)IS

Accepted Answer

The answer of Which feature of SQL Server 2012 provides...

Question 20

Which SQL Server 2012 component offers the capability to extract, transform, and load data from external sources?&#10;A)Analysis Services&#10;B)Reporting Services&#10;C)Integration Services&#10;D)Transformation Services

Accepted Answer

The answer of Which SQL Server 2012 component offers the...

Question 21

Match between columns&#10;                        Premises: A data mining and analytical component of SQL Server 2012&#10;A data mining and analytical component of SQL Server 2012&#10;A data mining and analytical component of SQL Server 2012&#10;A data mining and analytical component of SQL Server 2012&#10;A data mining and analytical component of SQL Server 2012&#10;A data mining and analytical component of SQL Server 2012&#10;A data mining and analytical component of SQL Server 2012&#10;A data mining and analytical component of SQL Server 2012&#10;A data mining and analytical component of SQL Server 2012&#10;A data mining and analytical component of SQL Server 2012&#10;A SQL Server 2012 component that provides extract, transform, and load capabilities&#10;A SQL Server 2012 component that provides extract, transform, and load capabilities&#10;A SQL Server 2012 component that provides extract, transform, and load capabilities&#10;A SQL Server 2012 component that provides extract, transform, and load capabilities&#10;A SQL Server 2012 component that provides extract, transform, and load capabilities&#10;A SQL Server 2012 component that provides extract, transform, and load capabilities&#10;A SQL Server 2012 component that provides extract, transform, and load capabilities&#10;A SQL Server 2012 component that provides extract, transform, and load capabilities&#10;A SQL Server 2012 component that provides extract, transform, and load capabilities&#10;A SQL Server 2012 component that provides extract, transform, and load capabilities&#10;A database setting that specifies the character set, sort order behavior, and how characters are evaluated in comparison operations&#10;A database setting that specifies the character set, sort order behavior, and how characters are evaluated in comparison operations&#10;A database setting that specifies the character set, sort order behavior, and how characters are evaluated in comparison operations&#10;A database setting that specifies the character set, sort order behavior, and how characters are evaluated in comparison operations&#10;A database setting that specifies the character set, sort order behavior, and how characters are evaluated in comparison operations&#10;A database setting that specifies the character set, sort order behavior, and how characters are evaluated in comparison operations&#10;A database setting that specifies the character set, sort order behavior, and how characters are evaluated in comparison operations&#10;A database setting that specifies the character set, sort order behavior, and how characters are evaluated in comparison operations&#10;A database setting that specifies the character set, sort order behavior, and how characters are evaluated in comparison operations&#10;A database setting that specifies the character set, sort order behavior, and how characters are evaluated in comparison operations&#10;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&#10;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&#10;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&#10;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&#10;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&#10;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&#10;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&#10;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&#10;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&#10;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&#10;A database instance on a server other than the default instance&#10;A database instance on a server other than the default instance&#10;A database instance on a server other than the default instance&#10;A database instance on a server other than the default instance&#10;A database instance on a server other than the default instance&#10;A database instance on a server other than the default instance&#10;A database instance on a server other than the default instance&#10;A database instance on a server other than the default instance&#10;A database instance on a server other than the default instance&#10;A database instance on a server other than the default instance&#10;A SQL Server 2012 component that provides a centralized means to manage and validate data&#10;A SQL Server 2012 component that provides a centralized means to manage and validate data&#10;A SQL Server 2012 component that provides a centralized means to manage and validate data&#10;A SQL Server 2012 component that provides a centralized means to manage and validate data&#10;A SQL Server 2012 component that provides a centralized means to manage and validate data&#10;A SQL Server 2012 component that provides a centralized means to manage and validate data&#10;A SQL Server 2012 component that provides a centralized means to manage and validate data&#10;A SQL Server 2012 component that provides a centralized means to manage and validate data&#10;A SQL Server 2012 component that provides a centralized means to manage and validate data&#10;A SQL Server 2012 component that provides a centralized means to manage and validate data&#10;A component of AlwaysOn functionality&#10;A component of AlwaysOn functionality&#10;A component of AlwaysOn functionality&#10;A component of AlwaysOn functionality&#10;A component of AlwaysOn functionality&#10;A component of AlwaysOn functionality&#10;A component of AlwaysOn functionality&#10;A component of AlwaysOn functionality&#10;A component of AlwaysOn functionality&#10;A component of AlwaysOn functionality&#10;A set of redundant nodes that can be used to host the database instance&#10;A set of redundant nodes that can be used to host the database instance&#10;A set of redundant nodes that can be used to host the database instance&#10;A set of redundant nodes that can be used to host the database instance&#10;A set of redundant nodes that can be used to host the database instance&#10;A set of redundant nodes that can be used to host the database instance&#10;A set of redundant nodes that can be used to host the database instance&#10;A set of redundant nodes that can be used to host the database instance&#10;A set of redundant nodes that can be used to host the database instance&#10;A set of redundant nodes that can be used to host the database instance&#10;A configuration value associated with a particular Windows software application&#10;A configuration value associated with a particular Windows software application&#10;A configuration value associated with a particular Windows software application&#10;A configuration value associated with a particular Windows software application&#10;A configuration value associated with a particular Windows software application&#10;A configuration value associated with a particular Windows software application&#10;A configuration value associated with a particular Windows software application&#10;A configuration value associated with a particular Windows software application&#10;A configuration value associated with a particular Windows software application&#10;A configuration value associated with a particular Windows software application&#10;An auto-managed local service account&#10;An auto-managed local service account&#10;An auto-managed local service account&#10;An auto-managed local service account&#10;An auto-managed local service account&#10;An auto-managed local service account&#10;An auto-managed local service account&#10;An auto-managed local service account&#10;An auto-managed local service account&#10;An auto-managed local service account

Accepted Answer

The Answer of Integration Services and Analysis Services and Failover is...

Question 22

Compare and contrast an attended installation and an unattended installation of SQL Server 2012.

Accepted Answer

The answer of Compare and contrast an attended installation and...

Question 23

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

Accepted Answer

The answer of List, in order the SQL Server 2012...

Question 24

What is a Failover Cluster Instance?

Accepted Answer

The answer of What is a Failover Cluster Instance?...

Question 25

What are the three commonly selected components installed in a SQL Server 2012 instance?

Accepted Answer

The answer of What are the three commonly selected components...

Question 26

Describe the process of SQL Server 2012 uninstallation, including uninstalling single or multiple instances.

Accepted Answer

The answer of Describe the process of SQL Server 2012...

Question 27

The ____________ contains a few important configuration values such as the authentication mode, network settings, and paths to the application directories.

Accepted Answer

The answer of The ____________ contains a few important configuration...

Question 28

Describe how to perform an SQL Server 2012 repair and why this might be necessary.

Accepted Answer

The answer of Describe how to perform an SQL Server...

Question 29

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

Accepted Answer

The answer of What are the two categories of database...

Question 30

Describe the physical and logical security consideration when planning an SQL Server 2012 installation.

Accepted Answer

The answer of Describe the physical and logical security consideration...

Deck 2: Deploying SQL Server 2012