1.
What is the minimum recommended amount of RAM for SQL Server 2012 Enterprise?
- A.512 MB
- B.1 GB
- C.2 GB
- D.4 GB
- E.8 GB
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
|
A. Incorrect: 512 MB of RAM is the minimum required for SQL Server 2012 Express
edition. The Enterprise edition requires a minimum of 1 GB of RAM. B. Correct: The Enterprise edition requires a minimum of 1 GB of RAM. C. Incorrect: The Enterprise edition requires a minimum of 1 GB of RAM. D. Incorrect: The Enterprise edition requires a minimum of 1 GB of RAM. E. Incorrect: The Enterprise edition requires a minimum of 1 GB of RAM. |
2.
Which of the following editions of SQL Server 2012 can you run on a computer that is
running the Windows 7 Professional (x64) operating system? (Choose all that apply.)
- A.SQL Server 2012 (x64) Developer edition
- B.SQL Server 2012 (x64) Web edition
- C.SQL Server 2012 (x64) Enterprise edition
- D.SQL Server 2012 (x64) Standard edition
- Answer & Explanation
- Report
Answer : [A, D]
Explanation :
Explanation :
|
A. Correct: You can install SQL Server 2012 (x64) Developer on a computer running
the Windows 7 Professional (x64) operating system. B. Incorrect: You cannot install SQL Server 2012 (x64) Web on a computer running the Windows 7 Professional (x64) operating system. C. Incorrect: You cannot install SQL Server 2012 (x64) Enterprise on a computer running the Windows 7 Professional (x64) operating system. D. Correct: You can install SQL Server 2012 (x64) Standard on a computer running the Windows 7 Professional (x64) operating system. |
3.
Which of the following features can you install if you are installing SQL Server 2012
Enterprise edition on a computer running Windows Server 2008 R2 SP1 Enterprise edition
in the Server Core configuration? (Choose all that apply.)
- A.Database Engine Services
- B.SQL Server Replication
- C.Analysis Services
- D.Reporting Services
- Answer & Explanation
- Report
Answer : [A, B, C]
Explanation :
Explanation :
|
A. Correct: You can install Database Engine Services on a computer running
Windows Server 2008 R2 SP1 Enterprise edition in the Server Core configuration. B. Correct: You can install SQL Server Replication on a computer running Windows Server 2008 R2 SP1 Enterprise edition in the Server Core configuration. C. Correct: You can install Analysis Services on a computer running Windows Server 2008 R2 SP1 Enterprise edition in the Server Core configuration. D. Incorrect: You cannot install Reporting Services on a computer running Windows Server 2008 R2 SP1 Enterprise edition in the Server Core configuration. |
4.
On which of the following operating systems can you deploy the 64-bit version of SQL
Server 2012 Enterprise edition? (Choose all that apply.)
- A.Windows 7 Ultimate (x64) edition
- B.Windows Server 2008 R2 SP1 (x64) Standard edition
- C.Windows Server 2008 SP2 (x64) Enterprise edition
- D.Windows Server 2003 R2 (x64) Enterprise edition
- Answer & Explanation
- Report
Answer : [B, C]
Explanation :
Explanation :
|
A. Incorrect: You cannot deploy the 64-bit version of SQL Server 2012 Enterprise edition
on Windows 7 Ultimate (x64) edition. You can install this edition of SQL Server
2012 on Windows Server 2008 and Windows Server 2008 R2 only. B. Correct: You can deploy the 64-bit version of SQL Server 2012 Enterprise edition on Windows Server 2008 R2 SP1 (x64) Standard edition. C. Correct: You can deploy the 64-bit version of SQL Server 2012 Enterprise edition on Windows Server 2008 SP2 (x64) Enterprise edition. D. Incorrect: You cannot deploy the 64-bit version of SQL Server 2012 Enterprise edition on Windows Server 2003 R2 (x64) Enterprise edition. |
5.
You want to simulate read, write, checkpoint, backup, sort, and read-ahead activities
for your organization’s SQL Server 2012 deployment. Which of the following tools
would you use to accomplish this goal?
- A.SQLIO
- B.SQLIOSim
- C.SQLIOStress
- D.chkdsk
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
|
A. Incorrect: SQLIO is used to perform benchmark tests to determine the I/O capacity
of the storage subsystem. B. Correct: You can use SQLIOSim to simulate read, write, checkpoint, backup, sort, and read-ahead activities. C. Incorrect: SQLIOStress is the version of SQLIOSim that was available for SQL Server 2000. You can’t use SQLIOStress with SQL Server 2012. D. Incorrect: Chkdsk is a utility that you can use to check for disk errors. You can’t use Chkdsk to simulate SQL activities as a form of benchmarking. |
|
|
||||||||||||||||||||||||||||
