Question 1

How should SQL services be configured with respect to service accounts?
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

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?
A)install
B)patch
C)upgrade
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?
A)Failover Cluster Instance
B)Reporting Services
C)Analysis Services
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?
A)AlwaysOn
B)SystemRecovery
C)HighTolerance
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?
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

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?
A)a new instance is created
B)it connects to the default instance
C)the client application is terminated
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

SQL Server 2012 stores the majority of configuration values in the system databases such as master, msdb, and model. Some configuration values may also be stored in the Windows registry or in configuration files.

Question 12

User databases contain data associated with a client application.

Accepted Answer

User databases are designed to store data related to a particular client application or website. This data can include user account information, preferences, activity logs, and more.

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?
A)Edition and licensing model selection
B)Hardware and software design
C)Business requirements
D)Feature identification

Accepted Answer

The first step in SQL Server 2012 installation planning is to identify the business requirements, such as the purpose of the database, the number of users, and the size of the data to be stored. This will help determine the appropriate edition and licensing model, as well as the hardware and software design needed to support the installation. Feature identification comes later in the planning process once the business requirements have been identified.

Question 15

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

Accepted Answer

The database engine is the core service component of SQL Server 2012. It is responsible for processing queries, managing database files, and maintaining data consistency and integrity. The other options (user databases, graphical interface, and reporting services) are all components of SQL Server 2012, but they are not the core service component.

Question 16

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

Accepted Answer

Integration Services is a component of SQL Server 2012, but it is not the core service. The core service of SQL Server is the Database Engine. Integration Services is used for data integration and workflow applications.

Question 17

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

Accepted Answer

Installing SQL Server 2012 on a dedicated server not shared with other services is the best choice for optimal logical security, as it reduces the surface area for potential attacks and allows for more precise access controls. Installing it on hardware with appropriate physical access controls is also important for physical security, but not directly related to logical security. Installing it on a domain controller or a server with several other services can increase the risk of security vulnerabilities and should be avoided.

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?
A)FCI
B)AG
C)ETL
D)IS

Accepted Answer

AG (AlwaysOn Availability Groups) is a feature of SQL Server 2012 that provides a failover environment consisting of a group of primary user databases with up to four replicas. FCI (Failover Cluster Instances) is another feature that provides high availability, but it only supports two-node clusters and requires shared storage. ETL (Extract, Transform, Load) and IS (Integration Services) are not related to providing high availability or failover environments in SQL Server 2012.

Question 20

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

Accepted Answer

Integration Services (SSIS) is a SQL Server 2012 component that provides the capability to extract, transform, and load (ETL) data from external sources. It includes tools to extract data from a variety of sources, transform the data through various operations, and load the transformed data into one or more destinations. SSIS also provides features for data profiling, data cleansing, and other data-related tasks. Analysis Services provides analytical capabilities and OLAP processing, while Reporting Services provides tools for creating and distributing reports. Transformation Services is not a valid SQL Server component.

Quiz 2: Deploying SQL Server 2012

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

Which of the following is NOT a setup type for SQL Server 2012?

Which SQL Server 2012 component provides a centralized means to manage and validate data?

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

______________ databases contain the data associated with a client application.

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?

What happens if a client connects to the database server without specifying a named instance?

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

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

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

User databases contain data associated with a client application.

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

Which of the following is the first step in SQL Server 2012 installation planning?

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

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

Which of the following is a recommendation for installing SQL Server 2012 for optimal logical security?

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

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

Which SQL Server 2012 component offers the capability to extract, transform, and load data from external sources?