Exam 1: Introduction to SQL Server 2012
Exam 1: Introduction to SQL Server 201241 Questions
Exam 2: Deploying SQL Server 201230 Questions
Exam 3: Architecture and Configuration41 Questions
Exam 4: Creating SQL Server 2012 Databases41 Questions
Exam 5: Transact:SQL Primer41 Questions
Exam 6: SQL Server Security41 Questions
Exam 7: Performance Monitoring and Optimization41 Questions
Exam 8: Backup and Recovery36 Questions
Exam 9: Data Integration38 Questions
Exam 10: Monitoring SQL Server 201239 Questions
Select questions type
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:
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:
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:
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)
Enterprise Edition is designed for organizations that manage large data _______________.
(Short Answer)
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)
Showing 1 - 20 of 41
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)