单选题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

第1题：

You write a procedure that will be called from two level triggers and a database trigger. Where should you store this code? （）

• A、On the Oracle server. 
• B、Locally in each form module. 
• C、In an attached PL/SQL library 
• D、On your file network server.

第2题：

You are developing a tax report for the payroll application. You created a before parameter form report trigger to create three temporary tables to store text that are need while the report is executed. Which report trigger would you use to delete these temporary tables?（）

• A、Before parameter form. 
• B、After parameter form. 
• C、Before report. 
• D、After report.

第3题：

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

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

第6题：

You work as a Web Application Developer at Certkiller.com. You make use of .NET Frameworkv3.5 to create an ASP.NET application.  You decide to create a Web user control named KingShare. KingShare is compiled as a library.The code segment below is written for KingShare. （The line numbers is included for reference purposes） 1 protected override void OnInit（EventArgs e） 2 { 3 base.OnInit（e）； 4 5 }  The master pages in the application contains the <%@ Master Language="C#" EnableViewState="false" %> directive. You receive an instruction from the network administratorto make sure that the KingShare state is able to persist on the pages that reference the masterpage. You should thus identify the appropriate code segment you need to add to line 4 to achievethis.  What should you do？（）

• A、Your best option would be to insert Page.RegisterRequiresPostBack(this)
• B、Your best option would be to insert Page.RegisterRequiresControlState(this)
• C、Your best option would be to insert Page.UnregisterRequiresControlState(this)
• D、Your best option would be to insert Page.RegisterStartupScript("KingShare","server")

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You are developing a bonus report for the payroll application to calculate and display the bonus issue to each envelope. Employees with a salary of less than 50000$ earn a bonus of 15% and the employees who earn 50000$ or more earn out 10% bonus. Which type of trigger would you use to conditionally assign a bonus percentage?（）

• A、Report level trigger. 
• B、Group filter. 
• C、Format trigger. 
• D、None of the above.

第14题：

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

第15题：

You need to call an unmanaged function from your managed code by using platform invoke services. What should you do？（）

• A、Create a class to hold DLL functions and then create prototype methods by using managed code.
• B、Register your assembly by using COM and then reference your managed code from COM
• C、Export a type library for your managed code.
• D、Import a type library as an assembly and then create instances of COM object.

第16题：

You create a server control that inherits from WebControl. You need to enable the server control to emit markup for a new kind of mobile device. You must not alter the code in the server controls. Which two actions should you perform?（）

• A、Create a class that inherits HtmlTextWriter and that can emit the new markup.
• B、Create a class that inherits StreamWriter and that can emit the new markup.
• C、Reference the class in the <capabilities> element of the new device's browser definition file.
• D、Reference the class in the <controlAdapters> element of the new device's browser definition file.

第17题：

You develop a Windows Communication Foundation (WCF) service to generate reports. Client applications call the service to initiate report generation but do not wait for the reports to be generated. The service does not provide any status to the client applications. The service class is defined as follows. (Line numbers are included for reference only.) 01 [ServiceContract] 02 public class ReportGeneratorService 03 { 04 ... 05 private int GenerateReports(int clientID) 06 { 07 ... 08 return 0; 09 } 10 } You need to ensure that client applications can initiate reports without waiting for status. Which two actions should you perform (Each correct answer presents part of the solution. Choose two.) （）。

• A、Insert the following code at line 04. [OperationContract(IsOneWay=true)]
• B、Insert the following code at line 04. [OperationContract(AsyncPattern=false)]
• C、At line 05, change the GenerateReports method from private to public.
• D、Remove line 08. At line 05, change the return type of GenerateReports method to void.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：