单选题The character mode sales report is stored on the network drive as a .REX. You need to make changes to the report layout. Using the report builder how would you change this file?（）A Open the file using the menu option file->open make the changes and rec

第1题：

You create a financial report to be represented to board of directors. The accounting manager has asked you to change the number format to show a thousand separator. What is the best method to make this change to the report quickly?（）

• A、Open the property palette and set the format mask for all the numeric items in the report. 
• B、Select the data to be free formatted in the life previewer and lick on the thousand separator icon on the style bar. 
• C、Go to the layout model and change the field attributes for the data to be changed on the report. 
• D、Rebuild the report using the report wizard setting this format on creation.

第2题：

Using the report wizard you create a tabular report to display all the columns in the EMP table. The records are ordered by the deptname and job columns. You need to create a hierarchical report that breaks on the deptname and job values. Using the data model how would you create this break structure?（）

• A、Specify the break order on the gemp group Property palette. 
• B、Specify a break order on the dept_name and job columns property palettes. 
• C、Click and drag the dept_name and jobs column out and above of the gemp group to create a new parent group. 
• D、Change the position of the dept_name and the job columns within the gemp group.

第3题：

You need to provide ad hoc reporting capabilities to fulfill business requirements. What should you do?（）

• A、Create a SQL Server Reporting Services （SSRS） report. Enable customers to modify the report by using Report Builder.
• B、Create an ASP.NET application that will enable customers to view and modify reports by calling the SQL Server Reporting Services （SSRS） API.
• C、Create an ASP.NET application that will enable customers to view and modify reports by using a SQL Server Reporting Services （SSRS） ActiveX control.
• D、Create a SQL Server Reporting Services （SSRS） Report Model. Enable customers to modify reports based on the model by using Report Builder.

第4题：

You have a server that runs Windows Server 2003 Service Pack 2 (SP2). A server application creates report files. The application saves the report files in a folder named Report. A service account is listed as the owner of all report files. You need to assign ownership of the report files to a user in a department named Audit. You must achieve this goal by using the minimum amount of administrative effort. What should you do? （）

• A、Rewrite the application.
• B、Create a scheduled task to run Attrib.exe.
• C、Create a scheduled task to run Icacls.exe.
• D、Use the Advanced Security settings to change the owner of each file.

第5题：

You are the network administrator for The network consists of a single Active Directory domain All network servers run Windows Server 2003. TestKing operates offices in London, Paris, and Amsterdam. Each office is configured as a separate Active Directory site. Each office has a file server for local users. ChiFile is the file server in London. It hosts a shared folder. Users report that they can no longer connect to the shared folder. A help desk technician who is a member of the Power Users group reports that he cannot connect to ChiFile. However, you are able to make a successful connection with ChiFile by using Terminal Services. How should you solve this problem?（）

• A、Add Windows Server 2003 licenses to the Site License server for London.
• B、Change the licensing mode on ChiFile from Per Device or User to Per Server.
• C、Change the licensing mode on ChiFile from Per Server to Per Device or User.
• D、Install a Terminal Services Enterprise license server on the London domain controller

第6题：

You have a computer that runs Windows 7. You log on to the computer by using a user account that is amember of Administrators group. From Windows Explorer you open C:/windows system32/drivers/etc/hostsin Notepad. You attempt to save the file and receive the Save As dialog box. You need to ensure that youcan save changes to C:/windows/system32/drivers/etc hosts. What should you do?（　）

• A、Stop the Windows Search service.
• B、Remove the inherited permissions from the file.
• C、Start Windows Notepad by using elevated privileges.
• D、Change the User Account Control （UAC） settings to Notify me only when program try to make changesto my computer.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Using the reports server how would you force the orders report in the orders entry application to run every six hours?（）

• A、Schedule the report's execution in the queue manager. 
• B、Schedule the reports execution using the R30RQM command line with scheduled parameter. 
• C、Create a trigger in the application to execute the report every six hours. 
• D、You cannot schedule a reports execution.

第14题：

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. 

第15题：

You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution. You create reports by using Microsoft Visual Studio .NET 2008. The development team of your company must create 50 SSRS reports. You need to ensure that the company logo and the company name are included in the page header of all the reports. What should you do？（）

• A、 Create an SSRS report and include the required page header in the report. Use the report as a template for all the reports.
• B、 Create an SSRS report and include the required page header in the report. Create a subreport that refers to the report. Include the subreport to all the reports.
• C、 Create a SSRS report and include the required page header in the report. Copy the report definition to an XML file.Add the XML file as a data source for all the reports.
• D、 Create a SSRS report and include the required page header in the report. Create a class library that includes the report.Add the class library as an assembly reference for all the reports.

第16题：

You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution. The solution contains a report named Sales Details that displays sales information of all the employees. You create an SSRS report named Sales Summary that displays the total monthly sales of each employee. Users who view the Sales Summary report occasionally require the monthly sales details for a particular employee. You need to ensure that the users can click a value in the month column of the Sales Summary report to open and render the Sales Details report. What should you do？（）

• A、 Use a subreport.
• B、 Use a bookmark link.
• C、 Use the drilldown functionality.
• D、 Use a drillthrough report link.

第17题：

You are using windows installer to deploy an application to 750 Windows 2000 Professional computers on your network. The network includes organizational unit （OU） named sales. A Group Policy object （GPO） is created for the Sales OU. The software deployment of the application is unsuccessful. During the deployment， some users in the Sales OU report that the installation is aborting with random errors midway through the installation process. The remaining users in the Sales OU report that the software is installing， but is giving them general protection fault errors. What should you do？（）

• A、Repackage and re-deploy the application's .msi file to the Sales OU
• B、Repackage and re-deploy the application's .mst file to the Sales OU
• C、Re-deploy the application by using the Group Policy object (GPO for the Sales OU)
• D、Restart Windows Installer on all computers in the Sales OU. Then re-deploy the application's .zap file to the sales OU. 

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：