Exam 1: Introduction to SQL Server 2012

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

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

Free
(Short Answer)
4.8/5
(32)
Correct Answer:
Verified

domain

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

Free
(Multiple Choice)
4.9/5
(40)
Correct Answer:
Verified

B

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

Free
(Multiple Choice)
4.7/5
(39)
Correct Answer:
Verified

D

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.

(True/False)
4.8/5
(35)

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

(Multiple Choice)
5.0/5
(40)

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

(Multiple Choice)
4.8/5
(38)

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

(Multiple Choice)
4.9/5
(37)

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

(Multiple Choice)
4.8/5
(41)

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.

(True/False)
4.8/5
(44)

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

(True/False)
4.8/5
(32)

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

(Short Answer)
4.8/5
(39)

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

(Multiple Choice)
4.8/5
(39)

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

(True/False)
4.8/5
(38)

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

(Essay)
4.8/5
(30)

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

(Essay)
4.8/5
(37)

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

(Multiple Choice)
4.8/5
(37)

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

(Multiple Choice)
4.9/5
(33)

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

(Multiple Choice)
4.8/5
(35)

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

(Multiple Choice)
4.9/5
(42)

Describe the process and purpose of crowd-sourcing.

(Essay)
4.9/5
(31)
Showing 1 - 20 of 41
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)