Question 1
Which feature of SQL Server 2012 can use AD DS to provide a scalable and integrated security model?
- User Account Control
- security-enhanced
- network authentication
- Selected: directory-enabledThis answer is correct.
Correct! AD DS is also required to install directory-enabled applications, such as SQL Server 2012.
1/1
Question 2
Which of the following is a high-availability and disaster recovery solution available in SQL Server 2012?
- Selected: AlwaysOnThis answer is correct.
- HighTolerance            Â
- SystemRecovery
- ClusterService            Â
Correct! AlwaysOn is a high-availability and disaster recovery solution that significantly alters the design requirements of a deployment’s physical infrastructure, because it requires additional servers and storage devices that are connected over a network.
1/1
Question 3
What feature of virtualization software allows you to revert to a previous point in time in the event you make an unrecoverable error?
- recovery points
- backups
- Selected: snapshotsThis answer is correct.
- restore instance
Correct! Building a test environment as a virtual machine is good practice when evaluating new software, because it isolates the environment from your host operating system and enables rollback to a previous snapshot of the system if needed.
1/1
Question 4
To which section of Server Manager would you go to view the event log or run device manager?
- Selected: DiagnosticsThis answer is correct.
- Features
- Configuration
- Server Summary
Correct! Diagnostics provides an event log viewer, hardware performance monitoring capabilities, and a device manager; this is one of the most useful features of Server Manager for day-to-day server management.
1/1
Question 5
Which of the following is NOT a recommended minimum requirement for running SQL Server 2012?
- 1 GB memory
- 6 GB hard disk space
- Selected: 500 MHz processorThis answer is correct.
- IE 7
Correct! The recommended system requirements for installing SQL Server 2012 include 2 GHz (x86-64) processor, 1GB memory, 6 GB hard disk space, and IT 7 or above.
0/1
Question 6
How should SQL services be configured with respect to service accounts?
- Selected: Use a single managed service account for all services.This answer is incorrect.
- Use a separate service account for each service.
- Use the Authenticated Users account for all services.
- Use the default Windows service account.    Â
Actually, look again. The virtual service accounts are created automatically during the installation process. A separate service account is created for each SQL Server service. Review Module 1 again, and specifically, page 38 in Chapter 2 of the textbook.
1/1
Question 7
Which feature of SQL Server 2012 provides a failover environment consisting of a group
of primary user databases with up to four replicas?
- FCI
- ETLÂ Â Â
- Selected: AGThis answer is correct.
- IS
Correct! Availability Groups (AG) provides a failover environment consisting of a group of primary user databases with up to four replicas that are used in the event the primary user database fails.
1/1
Question 8
Which of the following is a recommendation for installing SQL Server 2012 for optimal logical security?
- Selected: Install it on a dedicated server not shared with other services.This answer is correct.
- Install it on a domain controller.         Â
- Install it on hardware with appropriate physical access controls.
- Install it on a server with several other services.         Â
Correct! Logical security is the second dimension to consider. Microsoft recommends that SQL Server be installed on a dedicated server that is not shared with other Windows services, such as a domain controller.
1/1
Question 9
Which of the following is NOT true about a SQL Server 2012 installation?
- There is an installation wizard.
- You can use SysPrep for rapid deployment.  Â
- You can install from the command prompt.
- Selected: The wizard provides an unattended install option.   This answer is correct.
Correct! The activities in Chapter 2 guide you through an attended installation using the installation wizard, and then through a second installation using the command prompt.
1/1
Question 10
Which of the following is the first step in SQL Server 2012 installation planning?
- edition and licensing model selection
- Selected: business requirementsThis answer is correct.
- hardware and software design
- feature identification
Correct! Considering the business requirements is the first step in SQL Server 2012 installation planning.
1/1
Question 1
Which SQL Server 2012 component offers the capability to extract, transform, and load data from external sources?
- Analysis Services
- Selected: Integration Services               This answer is correct.
- Reporting Services
- Transformation Services        Â
Correct! Integration Services offers the capability to Extract, Transform, and Load (ETL) data from external sources.
1/1
Question 2
What does a CD/DVD drive emulator allow you to do with an ISO file?
- copy it
- Selected: mount itThis answer is correct.
- delete it
- repair it
Correct! A virtual CD/DVD drive emulator is software that emulates a physical drive and enables a disk image to be mounted; it is often used for installing software distributed as an ISO file.
1/1
Question 3
Which SQL Server 2012 edition provides data warehouse and audit components?
- Selected: EnterpriseThis answer is correct.
- Business Intelligence
- Datacenter
- Express
Correct! SQL Server 2012 Enterprise edition has data warehouse and audit components.
1/1
Question 4
Which of the following ultimately determines the SQL Server 2012 edition that is most suited for a particular application?
- Selected: business requirementsThis answer is correct.
- product cost
- application version
- system requirements
Correct! Business requirements will ultimately determine which edition is most suited for a particular application.
1/1
Question 5
Which feature of SQL Server 2012 can use AD DS to provide a scalable and integrated security model?
- User Account Control
- security-enhanced
- network authentication
- Selected: directory-enabledThis answer is correct.
Correct! AD DS is also required to install directory-enabled applications, such as SQL Server 2012.
1/1
Question 6
Which SQL Server 2012 component provides a centralized means to manage and validate data?
- Failover Cluster Instance
- Analysis Services
- Reporting Services
- Selected: Master Data ServicesThis answer is correct.
Correct! Master Data Services provides a centralized means to manage and validate data.
1/1
Question 7
Which Windows Server security feature ensures that administrative changes require explicit authorization?
- Windows Defender
- Selected: User Account ControlThis answer is correct.
- WMI Control
- Device Manager
Correct! User Account Control (UAC) is a Windows Server security feature that ensures any administrative changes to the configuration of the server—such as software installations—require explicit authorization.
1/1
Question 8
To which section of Server Manager would you go to view the event log or run device manager?
- Selected: DiagnosticsThis answer is correct.
- Features
- Configuration
- Server Summary
Correct! Diagnostics provides an event log viewer, hardware performance monitoring capabilities, and a device manager; this is one of the most useful features of Server Manager for day-to-day server management.
1/1
Question 9
Which feature of SQL Server 2012 provides a failover environment consisting of a group
of primary user databases with up to four replicas?
- FCI
- ETLÂ Â Â
- Selected: AGThis answer is correct.
- IS
Correct! Availability Groups (AG) provides a failover environment consisting of a group of primary user databases with up to four replicas that are used in the event the primary user database fails.
1/1
Question 10
Which term is used to describe the outsourcing of tasks to a distributed, undefined group of people?
- forum-allocation
- support-distribution
- online-tasking
- Selected: crowd-sourcingThis answer is correct.
Correct! Crowd-sourcing is a general term for the outsourcing of tasks to a distributed, undefined group of people.