1. Installing and Configuring SQL Server 2008 (10 percent) Flashcards
• Install SQL Server 2008 and related services. o This objective may include but is not limited to: file locations; default paths; service accounts • Configure SQL Server instances. o This objective may include but is not limited to: sp_configure, DMVs • Configure SQL Server services. o This objective may include but is not limited to: configuration manager; SQL browser • Configure additional SQL Server components. o This objective may include but is not limited to: SQL Server Int
<p>
What does the Resorce Govenor do?</p>
<p>
Resource Governor provides control of the amount of CPU, and memory is allocated with SQL Server 2008 workload without any application changes.</p>
<p>
How should I prepare for the upgrade process?</p>
<p>
First run the SQL Server 2008 Upgrade Advisor to identify any issues and provide guidance on resolving any problems.</p>
<p>
Which SQL Server 2008 edition supports IA64?</p>
<p>
<br></br>
A. Web and Compact Editions<br></br>
B. Standard and Workgroup Editions<br></br>
C. Enterprise and Developer editions<br></br>
D. All of the above</p>
<p>
<strong>C</strong></p>
<p>
</p>
<p>
The Enterprise and Developer Editions<br></br>
support IA64.</p>
<p>
</p>
<p>
How many instances can be created in SQL Server 2008 Standard Edition?</p>
<p>
<br></br>
A. 1<br></br>
B. 4<br></br>
C. 16<br></br>
D. Unlimited</p>
<p>
<strong>C. </strong></p>
<p>
</p>
<p>
SQL Server 2008 Standard Edition supports<br></br>
16 instances, as do the Workgroup, Web, and Express Editions.The Enterprise Edition can have up to 50.</p>
<p>
How many SQL Server default instances can be installed on a single, nonclustered server?</p>
<p>
A. 1<br></br>
B. 4<br></br>
C. 16<br></br>
D. Unlimited</p>
<p>
<strong>A. </strong></p>
<p>
</p>
<p>
There can only be one default instance of<br></br>
SQL Server on any SQL Server installation.</p>
<p>
Which of the following editions has all the features and functionality but is not licensed for production?</p>
<p>
<br></br>
A. Compact Edition<br></br>
B. Web Edition<br></br>
C. Developer Edition<br></br>
D. Workgroup Edition</p>
<p>
<strong>C. </strong></p>
<p>
</p>
<p>
The Developer Edition has all the features<br></br>
and functionality of SQL Server 2008 Enterprise Edition, but it is not licensed for production use.</p>
<p>
Which SQL Server 2008 edition is best suited for mobile applications?</p>
<p>
<br></br>
A. Compact Edition<br></br>
B. Web Edition<br></br>
C. Developer Edition<br></br>
D. Workgroup Edition</p>
<p>
<strong>A. </strong></p>
<p>
</p>
<p>
The Compact 3.5 Edition is best used for<br></br>
desktop and mobile applications because of its smaller footprint than the other versions. This is critical in mobile devices where disk space is at a<br></br>
premium.</p>
<p>
Which SQL Server 2008 edition provides the most Analysis Services features?</p>
<p>
<br></br>
A. Enterprise Edition<br></br>
B. Standard Edition<br></br>
C. Workgroup Edition<br></br>
D. Web Edition<br></br>
E. Express Edition</p>
<p>
<strong>A. </strong></p>
<p>
</p>
<p>
Only the Enterprise and Developer<br></br>
Editions provide all the Analysis Services features.</p>
<p>
Which tool should be on an existing SQL Server 2000 or 2005 database instance prior to upgrading to SQL Server 2008?</p>
<p>
<br></br>
A. Integration Services<br></br>
B. Reporting Services<br></br>
C. Analysis Services<br></br>
D. Upgrade Advisor Tool</p>
<p>
<strong>D. </strong></p>
<p>
</p>
<p>
The Upgrade Advisor Tool should be used<br></br>
on an existing SQL Server 2000 and 2005 instance to provide guidance prior<br></br>
to an upgrade to SQL Server 2008.</p>
<p>
Which of the following is a command line utility used to run PowerShell command and scripts? </p>
<p>
<br></br>
A. sqlcmd<br></br>
B. SQLdiag<br></br>
C. Ssms<br></br>
D. sqlps</p>
<p>
<strong>D. </strong></p>
<p>
<strong>sqlps </strong>is used to run PowerShell commands and scripts. Sqlcmd is used to execute T-SQL command and procedures. Ssms is used to start the SQL Server Management Studio, and SQLdiag is used to collect diagnostic information to supply to Microsoft Customer Service and Support.</p>
<p>
Which of the following editions does not support any Reporting Services features?</p>
<p>
<br></br>
A. Enterprise Edition<br></br>
B. Standard Edition<br></br>
C. Workgroup Edition<br></br>
D. Web Edition<br></br>
E. Express Edition</p>
<p>
<strong>E. </strong></p>
<p>
SQL Server 2008 Express Edition does not<br></br>
provide any Reporting Services features. Enterprise Edition provides all the features, while Standard, Workgroup, and Web have limited features of<br></br>
Reporting Services.</p>
<p>
Which of the following accounts has the least privilege when used as a service account?</p>
<p>
</p>
<p>
A. Domain user account</p>
<p>
B. Local user account</p>
<p>
C. Local service account</p>
<p>
D. Administrator account</p>
<p>
E. Local system account</p>
<p>
<strong>B. </strong></p>
<p>
</p>
<p>
Local user account has only local user<br></br>
privileges, which are not sufficient for a service account.</p>
<p>
Which of the following accounts should be used to perform a SQL Server 2008 installation or upgrade?</p>
<p>
<br></br>
A. Domain user account<br></br>
B. Local user account<br></br>
C. Local service account<br></br>
D. Administrator account<br></br>
E. Local system account</p>
<p>
<strong>D, </strong></p>
<p>
</p>
<p>
Administrator account. An account with Administrator privileges is required to install SQL Server 2008.</p>
<p>
In which of the following directories are the default instance database data and log files located?</p>
<p>
<br></br>
<span>A. <drive>:\Program Files\Microsoft SQL Server\\100\Setup Bootstrap\<br></br>
LOG\Files\<br></br>
B. <drive>:\Program Files\Microsoft SQL Server\MSSQL10.<br></br>
MSSQLSERVER\Data<br></br>
C. <drive>:\Program Files\Microsoft SQL Server\MSSQL9.DEFAULT\Data<br></br>
D. <drive>:\Program Files\Microsoft SQL Server\MSAS10.<br></br>
MSSQLSERVER\Data<br></br>
E. <drive>:\Program Files\Microsoft SQL Server\MSRS10.<br></br>
MSSQLSERVER\Data</span></p>
<p>
<strong>B. </strong></p>
<p>
</p>
<p>
SQL Server 2008’s default directory is<br></br>
under the Program Files\Microsoft SQL Server. The name of the database directory is prefaced with the SQL Server Version ID of MSSQL10, plus a period and the name of the database. The default database name is always<br></br>
MSSQLSERVER.</p>
<p>
What additional software is required for SQL Server’s Business Intelligence Developer’s Tool?</p>
<p>
<br></br>
A. .NET Framework 2.0<br></br>
B. Microsoft Installer 4.5<br></br>
C. Microsoft Internet Explorer 6 SP1 or later<br></br>
D. Windows PowerShell 2.0<br></br>
E. Windows Vista Enterprise SP1 or greater</p>
<p>
<strong>C, </strong></p>
<p>
</p>
<p>
Microsoft Internet Explorer 6 SP1 or<br></br>
later. …NET Framework 3.5, Microsoft Installer 4.5, and Windows PowerShell 1.0 are required as part of the installation of SQL Server 2008.</p>
