SQL chapter 1 and 2 test

Features that are shared

(eg., management tools).

What application(s) could be used to identify both the currently installed instances and features of SQL Server? A. Resource Monitor B. SQL Server Configuration Manager C. SOL Server Features Discovery Report D. Both options b and c

C

Each instance has a set of features that is unique to that instance

(e.g., Database Engine, Analysis Services, Integration Services, and Reporting Services),

Up to ______ instances of SQL Server 2012 can be installed and run concurrently on the same host.

50

What is the primary objective of the planning process? A. Ensure that the SQL Server 2012 deployment meets business requirements. B. Obtain the lowest quote for the required hardware. C. Address physical and logical security issues. D. Define the configuration parameter values for the SQL Server installation.

A

2. Service Pack 1 is a prerequisite if installing SQL Server 2012 Enterprise (64-bit) Edition on Windows Server 2008 R2. True or false?

True

It is possible to upgrade previous versions of SQL Server to SQL Server 2012. True or False?

True

Why should you consider setting up a virtual test environment? A. It requires less system resources because it is virtualized. B. It segregates the test environment trom the host operating system and allows you to roll back to an earlier snapshot in the event of an unrecoverable problem. C. Microsoft has a more cost-effective licensing model for virtualized systen D. A virtual environment minimizes the attack surtace area of the svstem and is theretore more secure

B

Changes to the server should be validated after

An installation using Windows management tools such as the Registry Editor, Performance Monitor, Resource Monitor, and SQL Server Configuration Manager.

How many default instances of a SQL Server 2012 can a single server host? A. Fifty B. One C. Depends on the SQL Server 2012 edition D. Unlimited

B

What were the maior areas of focus in the SOL Server 2012 version release? A. Support tor UNIX, Linux, Solaris, and Mac OS X operating systems B. High availability and Business Intelligence C. Discontinued support for the x86 32-bit processor D. All of the above

B

What would happen if you attempted to connect to a SQL Server host without specifying a named instance in the connection string? a. The connection would fail. b.You would be connected to the default instance. C. You would connect to the first available named instance. d. It depends upon the network protocol that is used.

B

How would you uninstall a SQL Server 2012 instance? A. Delete the instance directory in C:\Program Files\Microsoft SQL Serverl. B. Open the SQL Server Installation Center from the installation media and select Uninstall from the navigation menu in the left pane. C. Use the Uninstall or Change a Program feature that can be accessed from the Windows Server 2008 R2 Control Panel. D. Use the Uninstall menu in the SQL Server Configuration Manager.

C

Which of the following is not a function available through the Windows Server 2008 R2 Server Manager? A. Using the Event Viewer to analyze the application event log for errors B. Restarting a service C. Mounting an ISO image as a virtual drive in order to install new softw D. Adding a new local user and assigning the local Administrators role

C

Which of the following types of installation would be best suited for rapid deployment of multiple instances of SQL Server that use a standard configuration? a. An attended installation using the installation wizard b. An attended installation using the command prompt C.An unattended installation using the command prompt or the SysPrep utility d. Both options b and c

C

Microsoft makes which of the following licensing models available for the main editions of SQL Server 2012? A. Core-based licensing B. GNU General Public License C. Server and Client Access License (CAL) licensing D. Both options a and c

D

What does the Repair SQL Server 2012 operation do? A. Replaces missing or corrupt files B. Replaces missing or bad configuration parameters with the default settings C. Replaces missing or corrupt Registry keys D. All of the above

D

What is the primary function of SQL Server 2012? A. Business Intelligence B. Managing requests from client applications to access data C. Storing data D. Both options b and c

D

Where does Microsott publish its product documentation? A. TechNet B. w3schools C. MSDN D. Both options a and c

D

Which of the following are valid options to install SQL Server 2012? A. Use the command prompt B. Use Windows Deployment Services C. Launch the SQL Server Installation Wizard from the SQL Server Installation Center D. Both options a and c

D

Which of the following features are shared between SQL Server instances? a. SQL Server Integration Services b. SQL Server Reporting Services C. Master Data Services d. Both options a and c

D

SQL is a

Database programming language

Which of the following components must be installed for every SQL Server 2012 instance? A. SQL Server Integration Services B. Database engine C. SQL Server Reporting Services D. All of the above

B

Which of the following statements is incorrect? a. SOL Server should be installed on a dedicated server. b. A domain controller should be installed on the same host as SQL Server. C.You should only install the features necessary to meet the business requirements. d.Up to 50 instances of SQL Server 2012 may be installed and run concurrently on a single host.

B

The command prompt and SysPrep can also be used for

an instance or features in unattended mode.

The use of (AD DS) or (AD LDS) in Windows Server 2008 R2 provides

an integrated security environment for authentication, mapping of network users and services to roles, and man- aging of permissions to schema objects.

Always take a full backup of all databases before making any

changes in a production environment--for example, when adding or removing features.

SQL Server 2012 is offered via two licensing models:

core-based licensing, which is based on processing power, and Server and Client Access License (CAL) licensing, which is based on the number of end users.

Physical security considerations should be addressed by placing

hardware in a secure location with physical access controls.

Microsoft TechNet and MSDN Web sites are useful online resources for

information pertaining to software downloads, partners, future direction of SQL, product information, edition descriptions, and support for SQL Server 2012.

SOL Server 2012 can be installed using

installation wizard or the command prompt in attended mode.

The planning stage of a SQL Server 2012 installation consists of

interdependent activities that include requirements analysis, selection of the edition and license model, feature selection, and hardware and software architecture design. All of these activities are driven by business requirements.

Logical security considerations should include

minimizing the security footprint of the installation, isolating the services using individual service accounts, and installing SQL Server on a dedicated server.

SQL Server 2012 is tightly integrated with

the Windows operating system and must be installed on a compatible version.

Each edition of SQL Server 2012 includes

the core database engine and a suite of management tools, and is bundled with features from other components.

Books Online for SQL Server 2012 provides

the latest recommended system requirements for a SOL Server 2012 installation.

Windows Server 2008 R2 is the

the latest version of the Windows Server operating system. And it includes features that improve security and manageability.

Physical and logical security should be factored into each stage of

the planning process.

Building a test environment as a virtual machine is good practice

when evaluating new software because it isolates the environment from your host operating system and enables rollback to a previous snapshot of the system if needed.

Running the System Configuration Checker prior to installation ensures that

your host meets the necessary prerequisites and allows you to fix any issues prior to undertaking an installation.

AD DS stands for

Active Directory Domain Services

(AD LDS) stands for

Active Directory Lightweight Director Service

Microsoft SQL server 2012 is a

Relational database server with the primary function of storing data and managing access requests from client applications.

A repair operation can be run from the

SOL Server Installation Center to replace corrupt or missing files and bad settings with their defaults.

SQL Server 2012 is the latest release of SQL Server and is available in three main editions:

Standard, Business Intelligence, and Enterprise.

Windows Server 2008 R2 is available in 3 main editions

Standard, Enterprise, and Datacenter.

What does SQL stand for?

Structured Query Language

The SQL Server Features Discovery Report can be run

To list the installed instances, features, and shared features on the server.

An uninstall operation should always use the functionality provided by the

Uninstall or Change a Program feature that can be accessed from the Windows Server 2008 R2 Control Panel.

Corrupt or missing application files and Registry settings, or bad configuration parameter values, may cause

a SQL Server 2012 instance to fail to start.

Server Manager provides a

a one-stop management interface, introduced in Windows Server 2008, that provides quick access to tools for performing common tasks, such as querying server status, retrieving diagnostic information, starting or stopping services, and changing server roles and features.