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 p

第1题：

How are messages displayed when you use the SRW.MESSAGE packaged procedure? （）

• A、Dialogue box that implicitly determines report execution. 
• B、Message line that implicitly determines report execution. 
• C、Message line that suppresses the default oracle message. 
• D、Dialogue box that does not terminate report execution. 
• E、Dialogue box that suppresses the default oracle message.

第2题：

Which built-in would you reference in your trigger code to remove a report from the Reports Server queue dynamically?（）

• A、FIND_REPORT_OBJECT 
• B、CANCEL_REPORT_OBJECT 
• C、REPORT_OBJECT_STATUS 
• D、SET_PROPERTY OBJECT_PROPERTY

第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 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.

第5题：

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.

第6题：

You are a network administrator for ExamSheet.net's Windows 2000 network.  You use a user account named User1 to log on tot a Windows 2000 Professional computer. The computer is used by different students in a classroom. User1 does not have administrative rights. However, you prefer to use this account for your daily activities. Using the Task Scheduler you schedule a task to run a command file named AddUsers.cmd that automatically adds six more student user accounts. You configure the task to run as the administrator account.  After the task was scheduled to have run you open the Task Scheduler and discover a status of "Could not start" for the task. You also discover account logon failure audit events in the computer's Security log.You want the scheduled task to successfully run AddUsers.cmd. You want to accomplish this with the least amount of administrative effort.  What should you do?（）

• A、Schedule the task using theATcommand.
• B、Reenter the password for the administrator account using the Task Scheduler.
• C、Log on with an administrative account and reschedule the task.
• D、Log on by using the local Administrator account. Then schedule the task to run under User1.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Your business has departmental reports that are generated every day. Each department must use the same set of queries， but access a different subset of data in the tables， depending on which department generates the report. The format of the reports is being developed； currently， the format changes daily. How would you configure the database to ensure that each department generates its report （based on its target data） using the most recent report format every day？（）

• A、 By having each user run the report generation procedure at the scheduled time， supplying the necessary input variables.
• B、 By creating a program using DBMS_JOB that accepts one or more variables， and creating a job that calls this program using DBMS_JOB.
• C、 By having each user schedule a job using DBMS_JOB that accepts one or more input variables and calls a procedure that generates the report.
• D、 By having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the report.
• E、 By creating a program using DBMS_SCHEDULER that accepts one or more variables， and creating a job that calls this program using DBMS_SCHEDULER.

第14题：

You design a Business Intelligence （BI） solution by using SQL Server 2008. You plan to design the report strategy for a new report project that will be used by a financial application. The application uses five calculations that are implemented in Microsoft .NET Framework 3.5 assemblies. The assemblies are written in the C# language and use the static methods. You need to ensure that the calculations can be used by the expressions in all reports. You also need to ensure consistency within the reports by using the least amount of development effort. What should you do？（）

• A、 Add a reference to the assemblies in the Report Properties References tab. 
• B、 Write the calculation logic used by the calculations by using T-SQL functions. 
• C、 Write the code of the calculation logic into the Report Properties Custom Code tab.
• D、 Write the calculation logic in each report by using the mathematical functions available natively to SQL Server 2008 Reporting Services （SSRS）.

第15题：

You are a network administrator for your company. The company has a main office and two branch offices. The branch offices are connected to the main office by T1 lines. The network consists of three Active Directory sites， one for each office. All client computers run either Windows 2000 Professional or Windows XP Professional. Each office has a small data center that contains domain controllers， WINS， DNS， and DHCP servers， all running Windows Server 2003.   Users in all offices connect to a file server in the main office to retrieve critical files. The network team reports that the WAN connections are severely congested during peak business hours. Users report poor file server performance during peak business hours. The design team is concerned that the file server is a single point of failure. The design team requests a plan to alleviate the WAN congestion during business hours and to provide high availability for the file server.   You need to provide a solution that improves file server performance during peak hours and that provides high availability for file services. You need to minimize bandwidth utilization.   What should you do？ （）

• A、 Purchase two high-end servers and a shared fiber-attached disk array. Implement a file server cluster in the main office by using both new servers and the shared fiber-attached disk array.
• B、 Implement Offline Files on the client computers in the branch offices by using Synchronization Manager. Schedule synchronization to occur during off-peak hours.
• C、 Implement a stand-alone Distributed File System （DFS） root in the main office. Implement copies of shared folders for the branch offices. Schedule replication of shared folders to occur during off-peak hours by using scheduled tasks.
• D、 Implement a domain Distributed File System （DFS） root in the main office. Implement DFS replicas for the branch offices. Schedule replication to occur during off-peak hours.

第16题：

TestKing.com uses SQL Server 2005. Users report that report execution is slow. You investigate and discover that some queries do not use optimal execution plans. You also notice that some optimizer statistics are missing and others are out of date.  You need to correct the problem so that reports execute more quickly. Which two Transact-SQL statements should you use？（）

• A、DBCC CHECKTABLE
• B、ALTER INDEX REORGANIZE
• C、UPDATE STATISTICS
• D、CREATE STATISTICS
• E、DBCC SHOW STATISTICS
• F、DBCC UPDATEUSAGE

第17题：

You need to design the Service Broker queues that will be used to submit requests for long-running reports. Your solution must minimize complexity of using the queues by applications. What should you do?（）

• A、Specify one queue for each client application that can submit report requests.
• B、Specify one queue for each of the two report-generation services.
• C、Specify one queue for all long-running report requests.
• D、Specify eight queues：One for each service， and one for each client application.

第18题：

You are using Windows 2000 Professional on your desktop computer. You are working on the company’s financial report and you want other users on the network to able to modify your documents for the report. You want users to share the financial report folder on the network. Because the network contains confidential information you want to prevent users from the enabling off line access for the network share that contains the financial report. What should you do？（）

• A、Use Windows Explorer to receive the offline files
• B、Using the Windows Explorer, disable the cache for the reports on the network share
• C、Use the Windows NT explorer to grant the special access for the reports on the network  share
• D、Use the synchronization manager to configure synchronization not to occur when users are  connected to the LAN connection. 

第19题：

第20题：

第21题：

第22题：

第23题：