Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

Core-based licensing measures the comput

Question 4

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

Accepted Answer

The answer of Microsoft SQL Server is a powerful, _____________...

Question 5

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

Accepted Answer

A) replication server 
B) query handler 
C) control module 
D) database engine 
A) replication server 
B) query handler 
C) control module 
D) database engine

Question 6

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

Accepted Answer

A) Standard Edition 
B) Server Core 
C) Datacenter Edition 
D) Enterprise Edition 
A) Standard Edition 
B) Server Core 
C) Datacenter Edition 
D) Enterprise Edition

Question 7

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

Accepted Answer

The answer of _______________________ is a term used to describe...

Question 8

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

Accepted Answer

User Account Control (UAC)is a Windows S

Question 9

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

Accepted Answer

Developer Edition-The Developer Edition

Question 10

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

Accepted Answer

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

Question 11

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

Accepted Answer

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

Question 12

What is Active Directory Service (AD DS)?

Accepted Answer

Active Directory Domain Service (AD DS)i

Question 13

What is the Server Core version of Windows Server 2008?

Accepted Answer

Microsoft produces a bare-bones version

Question 14

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

Accepted Answer

The Business Intelligence Edition inheri

Question 15

Match between columns
                        Premises: A user-centric licensing model
A widely used network authentication protocol
A server running a version of the Windows Server operating system, with Active Directory Domain Services (AD DS)installed
A stripped-down version of the Windows Server 2008 operating system that does not include the Windows Explorer Shell
A platform that allows a computer system's hardware and software components to interface separately with multiple applications
An isolated guest operating system installed on top of a normal operating system
A software protocol for enabling anyone to locate individuals, and other resources, such as files and devices, on a network
A processor with more than one core processing unit
An occurrence or copy of an object
A database programming language

Accepted Answer

The Answer of Server Core and instance and domain controller is...

Question 16

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

Accepted Answer

SQL Server 2012 differentiates

Question 17

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

Accepted Answer

A) Initial Configuration Tasks 
B) Server Manager 
C) Windows Explorer 
D) Server Core 
A) Initial Configuration Tasks 
B) Server Manager 
C) Windows Explorer 
D) Server Core

Question 18

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

Accepted Answer

The answer of ____________-based licensing replaces processor-based licensing in earlier...

Question 19

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

Accepted Answer

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

Question 20

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?

Accepted Answer

A) Business Intelligence 
B) Standard 
C) Developer 
D) Enterprise 
A) Business Intelligence 
B) Standard 
C) Developer 
D) Enterprise

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

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

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

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

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

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

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

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

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

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

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

What is Active Directory Service (AD DS)?

What is the Server Core version of Windows Server 2008?

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

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

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

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

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

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?

Deploying SQL Server 2012

Architecture and Configuration

Creating SQL Server 2012 Databases

Transact:SQL Primer

SQL Server Security

Performance Monitoring and Optimization

Backup and Recovery

Data Integration

Monitoring SQL Server 2012

Filters

Exam 1: Introduction to SQL Server 2012

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

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

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

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

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

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

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

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

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

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

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

What is Active Directory Service (AD DS)?

What is the Server Core version of Windows Server 2008?

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

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

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

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

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

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?

Deploying SQL Server 2012

Architecture and Configuration

Creating SQL Server 2012 Databases

Transact:SQL Primer

SQL Server Security

Performance Monitoring and Optimization

Backup and Recovery

Data Integration

Monitoring SQL Server 2012

Filters