Deck 1: Introduction to SQL Server 2012

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

Answer 1

B

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

Answer 2

C

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

Answer 3

C

Question 4

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

A)Enterprise
B)Datacenter
C)Business Intelligence
D)Express

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

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

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

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

Question 9

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

A)Developer
B)Standard
C)Express
D)Web

Question 10

At a minimum, Windows Server 2008 SP2 32-bit is required 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

Question 12

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

Question 13

SQL Server 2012 Express Edition is available free but the database size is constrained to 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.

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

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.

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

Question 18

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

A)Datacenter
B)Public
C)Enterprise
D)Essential

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

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

Question 21

What is Active Directory Service (AD DS)?

Question 22

What feature of virtualization software allows you to revert to a previous point in time in the event you make an unrecoverable error?

A)recovery points
B)snapshots
C)backups
D)restore instance

Question 23

Microsoft SQL Server is a powerful, _____________ database management system (RDBMS).

Question 24

What does a CD/DVD drive emulator allow you to do with an ISO file?

A)copy it
B)delete it
C)mount it
D)repair it

Question 25

How is SQL Server 2012 different from other commercial database systems?

Question 26

Which of the following is NOT a recommended minimum requirement for running SQL Server 2012?

A)1 GB memory
B)500 MHz processor
C)6 GB hard-disk space
D)IE 7

Question 27

List two online sources for Microsoft SQL Server 2012 product documentation.

Question 28

What is the term used to describe the outsourcing of tasks to a distributed, undefined group of people?

A)forum-allocation
B)online-tasking
C)support-distribution
D)crowd-sourcing

Question 29

List and describe the three specialized editions of SQL Server 2012.

Question 30

What is the purpose of User Account Control on Windows Server 2008? How do you use applications that require it?

Question 31

Describe the Business Intelligence Edition of SQL Server 2012 and how it differs from Standard Edition.

Question 32

Which of the following is a portal that hosts online documentation, tutorials, and user forums for Microsoft products?

A)TechNet
B)MSN
C)MicroForums
D)NetInfo

Question 33

AD DS uses a __________ controller, a server running a version of Windows Server with AD DS installed.

Question 34

Enterprise Edition is designed for organizations that manage large data _______________.

Question 35

How do you work with Microsoft software that is available as an ISO image file?

Question 36

____________-based licensing replaces processor-based licensing in earlier versions of SQL Server.

Question 37

What is core-based licensing and which SQL Server 2012 edition requires it?

Question 38

What is the Server Core version of Windows Server 2008?

Question 39

Describe the process and purpose of crowd-sourcing.

Question 40

_______________________ is a term used to describe a system that must be online and available for users access at most times.