单选题You created a tabular report for the sales department to display each customer and the sales person assign to the customer. The data is sorted by customer using the order by clause in this query. This is department manager asks you to alter the report 

第1题：

You are creating a tabular report for the sales department with a department break group. You need to ensure that if al least six sales records will not fit at the button of a page, the group will start on the next page. Which printing frame property would you alter to achieve these results?（）

• A、Source 
• B、Print direction 
• C、Maximum records per page 
• D、Minimum Widow records 
• E、Column mode

第2题：

You are the network administrator for The sales department stores data on a server that runs Windows Server 2003. The backup schedule for the server includes a normal backup on Sundays and incremental backups on every other day of the week. The sales department data includes a report that is created by an automated process. The report is included in the standard backup schedule for the server. The automated process runs on Wednesdays and Sundays. The process overwrites the previous version of the report. You need to be able to restore the report if the standard backup is unavailable. You need to create an additional backup for the report. The backup for the report cannot interfere with other backup jobs. What should you do?（）

• A、Perform a normal backup on Wednesday night and on Sunday night.
• B、Perform a differential backup on Wednesday night and on Sunday night.
• C、Perform a incremental backup on Wednesday night and on Sunday night.
• D、Perform a copy backup on Wednesday night and on Sunday night.

第3题：

The IT department requested a report to list each server name and the name of each department that utilizes resources from each server. You create a tabular layout that breaks on the server name. You ran the report and noticed that the department field is too large for most of the department names. Which field size setting would you use to allow the field to be smaller but not larger than the field layout size?（）

• A、Fixed 
• B、Expand 
• C、Contract 
• D、Variable

第4题：

You are the network administrator for Testking.com. The network consists of a single Active Directory domain named testking.com. The sales department is hiring employees. An OU named TestKingSales is created to hold objects for the new sales department users. Each sales department user has a portable computer. Each portable computer runs Windows XP Professional. The sales department users are responsible for joining their portable computers to the domain. You need to ensure that the computer accounts for the Sales department user's portable computers are created in the TestKingSales OU. You need to achieve this goal without granting any unnecessary permissions. What should you do?（）

• A、Assign the sales department users the Allow - Read permissions for the Computer container.
• B、Configure the sales department users' user accounts to be trusted for delegation
• C、Prestage the computer accounts in the TestKingSales OU for the sales department users' portable computers.
• D、Assign the sales depertment users the Allow - Create all Child Objects permission for the TestKingSales OU.

第5题：

You created a tabular report for human resources department. After viewing layout users have requested that you change the label of the dept column to something more meaningful. How would you change the label in the live previewer?（）

• A、Use the report wizard to change the column label. 
• B、Click and high light the column label and replace it with desired text. 
• C、Click the column label and alter its property palette. 
• D、Click the dept column and alter its property palette. 

第6题：

You work in Dublin at the main office of TestKing.com. You are responsible for managing a SQL Server 2005 database. The sales department wants a report that compares customer activity in the previous quarter between the main office in Dublin and the branch office in Buenos Aires. They want the data sorted by surname and first name.You restore a recent backup of the Buenos Aires database onto your server. You write queries to build the report， ordering the data by the Surname and FirstName columns. You review the data and notice that the customer list from the Buenos Aires database is sorted differently. The sales department needs the revised data within 15 minutes for a presentation.  You need to implement the fastest possible solution that ensures that the data from both databases is sorted identically. What should you do？（）

• A、Use the Copy Database Wizard to copy the data in the Buenos Aires database to a new database with the same collation as the Dublin database.
• B、Use the SQL Server Import and Export Wizard to copy the data from the Buenos Airesdatabase into new tables， specifying the same collation as the Dublin database.
• C、Modify the format file to specify the same collation as the Dublin database. Import the table again.
• D、Modify the query on the Buenos Aires database to use the COLLATE setting in the ORDER BY clause. In the query， specify the same collation as the Dublin database.

第7题：

You created a report from the human resources department based on all the columns in the EMP table. After viewing the report users requested that the cmp_ID columns peers first in the output. How would you change the position of the column?（）

• A、After the query. 
• B、Enter the report and change the column's position in the field tab. 
• C、Alter the column's position in the object navigator. 
• D、Enter the report wizard and change the column's position in the data tab. 
• E、Alter the column's position within its group and change the layout. 

第8题：

The sales report needs to display the sales person with the highest order total. Which build report builder component would you use to create a place holder column to display the value?（）

• A、Report wizard. 
• B、Layout model. 
• C、Data model. 
• D、Life previewer.

第9题：

The order entry department requested a report to display the average time to enter an order from each order entry clerk sorted by supervisor with a group average after viewing the report users requested to bold the value for each supervisors group average. Where would you make this change?（）

• A、In the template used. 
• B、In the data model. 
• C、In the life previewer. 
• D、In the field property palette.

第10题：

You are the administrator of your company's network. You want to configure a Security Policy for the Windows 2000 Professional Computers that are in the sales department.   On one of the computers, you use Security Templates to configure the Security Policy based on the desired security settings. You then export those settings to an .inf file that will be used on all of the Computers in the sales department. You want to configure each Computer to have a customized Security Policy. What steps should you follow in order to achieve your goal?（）

• A、Use Secedit.exe to import the security settings from the .inf file to the computers in the sales department.
• B、Use a text editor to change the default security settings to the desired security settings. Then export those settings to the Computers in the sales department.
• C、Create an organizational unit （OU） named Sales. Add the users in the sales department to the Sales OU. Then apply the security template to the users in the Sales OU.
• D、Create an organizational unit （OU） named Sales. Add the computers in the sales department to the Sales OU. Then apply the security template to computers in the Sales OU.