Question 1

Which of the following SQL Server 2012 editions is not a good choice if you want to use Data Mining and Master Data Services components?
A)Business Intelligence
B)Standard
C)Developer
D)Enterprise

Accepted Answer

The Standard edition of SQL Server 2012 does not include the Data Mining and Master Data Services components. These features are available in the Business Intelligence, Developer, and Enterprise editions.

Question 2

What type of Windows Server should you NOT install SQL Server 2012 for security reasons?
A)file server
B)application server
C)domain controller
D)authentication controller

Accepted Answer

SQL Server 2012 should not be installed on a domain controller as it can result in security vulnerabilities and can compromise the system's overall security. A domain controller is responsible for managing security policies and user accounts for an entire domain, so installing SQL Server on it can create a risk to the entire domain.

Question 3

Which Windows Server security feature ensures that administrative changes require explicit authorization?
A)Windows Defender
B)WMI Control
C)User Account Control
D)Device Manager

Accepted Answer

User Account Control (UAC) is a security feature in Windows Server that ensures that administrative changes require explicit authorization. It helps prevent unauthorized changes to the system by only allowing trusted administrators to make changes after they have been explicitly granted permission through a UAC prompt. Windows Defender is an antivirus program, WMI Control is a tool for managing Windows Management Instrumentation, and Device Manager is a tool for managing hardware devices on a system.

Question 4

Which SQL Server 2012 edition provides Data Warehouse and Audit components?
A)Enterprise
B)Datacenter
C)Business Intelligence
D)Express

Accepted Answer

The Enterprise edition of SQL Server 2012 provides both Data Warehouse and Audit components. The Datacenter and Business Intelligence editions provide the Data Warehouse component only. The Express edition does not provide either component.

Question 5

Which of the following is the core component within a database that control data storage and access requests from client applications?
A)replication server
B)query handler
C)control module
D)database engine

Accepted Answer

The database engine is the core component within a database that controls data storage and access requests from client applications. It manages the physical storage of data and executes queries to retrieve and manipulate the data. The replication server is used for creating copies of the database for backup or distributed computing purposes. The query handler is responsible for processing and executing queries sent to the database. There is no such thing as a "control module" within a database management system.

Question 6

Which tool in Windows Server 2008 R2 provides a one-stop management interface for querying server status and changing roles and features?
A)Initial Configuration Tasks
B)Server Manager
C)Windows Explorer
D)Server Core

Accepted Answer

Server Manager provides a one-stop management interface for querying server status and changing roles and features in Windows Server 2008 R2.

Question 7

Which SQL Server 2012 edition has only Server and CAL as a licensing model option?
A)Standard
B)Enterprise
C)Business Intelligence
D)Express

Accepted Answer

The Business Intelligence edition of SQL Server 2012 is the only one among the options listed that exclusively uses the Server and Client Access License (CAL) licensing model. This model requires a license for each server and for each user or device accessing the server, which is suitable for organizations with a specific number of users or devices. The other editions, such as Standard and Enterprise, offer both core-based and Server/CAL licensing options, while Express is a free edition and does not require such licensing.

Question 8

What feature of SQL Server 2012 means that it can use AD DS to provide a scalable and integrated security model?
A)user-account control
B)network authentication
C)security enhanced
D)directory-enabled

Accepted Answer

The feature of SQL Server 2012 that allows it to use AD DS is the directory-enabled feature. This feature enables a scalable and integrated security model by allowing SQL Server to use the security groups and user accounts that are defined in Active Directory Domain Services. This simplifies security management and reduces administrative overhead.

Question 9

Which SQL Server 2012 edition is targeted at hosted, Internet-facing deployments?
A)Developer
B)Standard
C)Express
D)Web

Accepted Answer

The SQL Server 2012 edition targeted at hosted, Internet-facing deployments is the Web edition. It is designed and priced for hosting service providers and allows for scalability and manageability of multiple databases. The Developer edition is for development purposes only, the Standard edition is for basic database management, and the Express edition is a free, lightweight version with limitations on database size and resources.

Question 10

At a minimum, Windows Server 2008 SP2 32-bit is required to run SQL Server 2012.

Accepted Answer

SQL Server 2012 requires a minimum of Windows Server 2008 R2 64-bit or later versions to run. Therefore, Windows Server 2008 SP2 32-bit is not sufficient to run SQL Server 2012.

Question 11

Which of the following is NOT a design goal of SQL Server 2012 that builds on the success of SQL Server 2008 R2?
A)improved business intelligence
B)scalability
C)improved multitasking
D)high availability

Accepted Answer

Improved multitasking was not listed as a design goal of SQL Server 2012 that builds on the success of SQL Server 2008 R2. The other options are all design goals that build on the success of the previous version.

Question 12

SQL Server 2012 is only available in 64-bit versions.

Accepted Answer

SQL Server 2012 was available in both 32-bit and 64-bit versions.

Question 13

SQL Server 2012 Express Edition is available free but the database size is constrained to 10GB.

Accepted Answer

SQL Server 2012 Express Edition is available for free but with a database size constraint of 10GB.

Question 14

A common reason that SQL Server 2012 installation might fail is because the Windows OS is not up to date with service packs or security updates.

Accepted Answer

SQL Server 2012 requires certain updates and service packs to be installed on the Windows OS in order to function properly. If these updates are not present, the installation may fail.

Question 15

Which of the following can be described as an isolated guest operating system installed on top of a normal operating system?
A)virtual machine
B)physical server
C)host computer
D)emulated PC

Accepted Answer

A virtual machine is an isolated guest operating system installed on top of a normal operating system. It allows multiple operating systems to run on one physical machine, each in its own virtual environment. A physical server refers to the actual hardware and is not installed on top of another operating system. A host computer is the computer that the virtual machine is running on, but it is not specifically describing the virtual machine itself. An emulated PC is a type of virtual machine, but it refers specifically to emulating a computer's hardware rather than just the operating system.

Question 16

The Windows security feature called User Account Control requires you to login as a user that is a member of Server Operators before running administrative tasks on applications.

Accepted Answer

User Account Control (UAC) does not require you to log in as a user that is a member of Server Operators. It prompts users who are attempting to perform tasks that require administrative privileges, regardless of their group membership, to approve the action.

Question 17

Which of the following ultimately determines which SQL Server 2012 edition is most suited for a particular application?
A)business requirements
B)application version
C)product cost
D)system requirements

Accepted Answer

The business requirements of the application will determine the necessary features and capabilities of the SQL Server 2012 edition needed for optimal performance. Factors such as data volume, number of users, and security requirements will influence the selection of the appropriate edition.

Question 18

Which of the following is an edition of SQL Server 2012?
A)Datacenter
B)Public
C)Enterprise
D)Essential

Accepted Answer

Enterprise is an edition of SQL Server 2012, offering comprehensive database and analytics capabilities for large-scale and mission-critical applications. Datacenter was an edition in previous versions but not in 2012, and Public and Essential are not recognized editions of SQL Server.

Question 19

Which Windows Server 2008 R2 version has a smaller footprint, reduces the number of security vulnerabilities, and does not include the Windows Explorer Shell?
A)Standard Edition
B)Server Core
C)Datacenter Edition
D)Enterprise Edition

Accepted Answer

The Server Core version of Windows Server 2008 R2 has a smaller footprint as it only installs necessary components for running specific server roles. This reduces the number of security vulnerabilities by reducing the attack surface. Additionally, Server Core does not include the Windows Explorer Shell, further reducing the potential for security vulnerabilities. Standard, Datacenter, and Enterprise editions all include the Windows Explorer Shell and additional components, making them less secure in comparison.

Question 20

To which section of Server Manager would you go to view the event log or run device manager?
A)Diagnostics
B)Configuration
C)Features
D)Server Summary

Accepted Answer

The Diagnostics section in Server Manager includes options to view the Event Viewer and Device Manager, as well as other troubleshooting tools.

Quiz 1: Introduction to SQL Server 2012

Which of the following SQL Server 2012 editions is not a good choice if you want to use Data Mining and Master Data Services components?

What type of Windows Server should you NOT install SQL Server 2012 for security reasons?

Which Windows Server security feature ensures that administrative changes require explicit authorization?

Which SQL Server 2012 edition provides Data Warehouse and Audit components?

Which of the following is the core component within a database that control data storage and access requests from client applications?

Which tool in Windows Server 2008 R2 provides a one-stop management interface for querying server status and changing roles and features?

Which SQL Server 2012 edition has only Server and CAL as a licensing model option?

What feature of SQL Server 2012 means that it can use AD DS to provide a scalable and integrated security model?

Which SQL Server 2012 edition is targeted at hosted, Internet-facing deployments?

At a minimum, Windows Server 2008 SP2 32-bit is required to run SQL Server 2012.

Which of the following is NOT a design goal of SQL Server 2012 that builds on the success of SQL Server 2008 R2?

SQL Server 2012 is only available in 64-bit versions.

SQL Server 2012 Express Edition is available free but the database size is constrained to 10GB.

A common reason that SQL Server 2012 installation might fail is because the Windows OS is not up to date with service packs or security updates.

Which of the following can be described as an isolated guest operating system installed on top of a normal operating system?

The Windows security feature called User Account Control requires you to login as a user that is a member of Server Operators before running administrative tasks on applications.

Which of the following ultimately determines which SQL Server 2012 edition is most suited for a particular application?

Which of the following is an edition of SQL Server 2012?

Which Windows Server 2008 R2 version has a smaller footprint, reduces the number of security vulnerabilities, and does not include the Windows Explorer Shell?

To which section of Server Manager would you go to view the event log or run device manager?