You need to install Microsoft SQL Server 2005 Enterprise Edition for test purposes and have moderate storage capabilities. Which of the following systems suits your needs without requiring you to perform any alterations?
A. Pentium 400, 1GB RAM, Internet Explorer 5
B. Pentium 400, 512MB RAM, Internet Explorer 6
C. Pentium 600, 256MB RAM, Internet Explorer 6
D. Pentium 600, 512MB RAM, Internet Explorer 6
You are about to install Microsoft SQL Server 2005 Enterprise Edition on one of the servers in the company. Which of the following systems can you use without needing to upgrade? (Choose all that apply.)
A. Windows 2000 Server, SP4
B. Windows Small Business Server 2003 SP1
C. Windows 2000 Server, SP3
D. Windows Server 2003 Web Edition SP1
E. Windows Server 2003 Standard Edition SP1
You have just installed Microsoft SQL Server 2005 Enterprise Edition for use in the company. You need to set up security to allow access to the server to the employees of the company. The server will contain several databases, some of which contain sensitive information. How do you configure access to the server? (Choose two answers.)
A. Allow access to the Domain Users group and assign users to appropriate applications roles
B. Allow access to the Everyone group and assign appropriate permissions to associated SQL logins
C. Allow access to Active Directory groups that have been created according to company roles and assign permissions according to those groups
D. Disable guest access and assign minimal permissions to the Public role in the sensitive databases
E. Disable guest access and deny permission to the Public role in the sensitive databases
On an existing Microsoft SQL Server 2005 Enterprise Edition instance, you need to prevent non-management individuals from accessing the server. How do you configure access to the server?
A. Disable guest access; grant access to a network group containing the management individuals; deny access to the Public group in each database
B. Disable guest access and grant access to a network group containing the management individuals; ensure that no other access has been granted to other groups
C. Disable guest access and grant access to the Domain Users group; deny database access to anyone not in management
D. Disable guest access and grant access to a network group containing the management individuals; grant access to all other network groups and assign them to the db_denydatareader role in all databases
You are about to install Microsoft SQL Server 2005, and you want to ensure that the configuration is suitable for the installation. Which tool would you use?
A. System Configuration Checker
B. SQL Server Analysis Services
C. SQL Server Migration Assistant
D. SQL Server Profiler
You are attempting to set up the disk drives to attain the best performance while retrieving data. How would you configure the drives that are being used by the data files?
A. Use RAID 0
B. Use RAID 1
C. Use RAID 5
D. Use NTFS (no RAID)
You need to configure access to a second SQL server for an application that will be using the data for a single query. How would you implement the configuration and query? (Choose two answers.)
A. Set up an alias for the server
B. Set up the server as a remote server
C. Set up the server as a linked server
D. Use a four-part name in the query
E. Use a union query
F. Use a join query
Answers to Exam Prep Questions
D. To install SQL Server, you need a minimum of a Pentium 600, 512MB of RAM (although more is recommended), and Internet Explorer 6 or above. See SQL Server Books Online for more information.
A, B, E. As shown in Table 1.1 in the chapter, you need Service Pack 4 for Windows 2000 Server, and the Web Edition of Windows Server 2003 supports only the Express Edition of SQL Server.
C, D. You should never deny permissions to the Public role because, in essence, you would be denying the ability for any user. Instead, you should assign a minimal, base level of permission to this role. You can leverage Active Directory groups to ease administration, but you need to be cautious in using the Domain Users group, which in this example would be invalid. You should never use the Everyone group.
B. You should never deny permissions to the Public role because, in essence, you would be denying the ability for any user. Instead, you should assign a minimal, base level of permission to this role. You can leverage existing Active Directory groups to ease administration, as long as they contain the appropriate individuals.
A. The System Configuration Checker (SCC) can pinpoint conditions that will prevent a successful installation. The Migration Assistant, on the other hand, is used to migrate from other systems such as Access or Oracle. SQL Server Analysis Services provides online analytical processing (OLAP) and data mining functionality. SQL Server Profiler is for monitoring an existing instance of the database engine or Analysis Services.
A. Although other forms of RAID offer fault tolerance, the implementation of the fault tolerance will have an associated performance cost. No RAID at all does not provide performance as good as you can achieve by using multiple drives in a RAID 0 configuration.
C, D. You need to configure a linked server to provide access to data from the second source. Within the query, you address the second source by using four-part names.