RUN_PRODUCT
SET_REPORT_OBJECT_PROPERTY
RUN_REPORT_OBJECT
FIND_REPORT_OBJECT
REPORT_OBJECT_STATUS
COPY_REPORT_OBJECT_OUTPUT
第1题:
There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database?()
第2题:
You need to provide ad hoc reporting capabilities to fulfill business requirements. What should you do?()
第3题:
You create a Web application. The Web application enables users to change fields in their personal profiles. Some of the changes are not persisting in the database. You need to raise a custom event to track each change that is made to a user profile so that you can locate the error.Which event should you use? ()
A. WebAuditEvent
B. WebEventManager
C. WebBaseEvent
D. WebRequestEvent
第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? ()
第5题:
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?()
第6题:
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?()
第7题:
You are responsible for managing the database schema for an order entry application in a SQL Server 2005 database. After a design review, a member of the development staff asks you to add a new column named CommissionRate to the Product table. Because the actual commission rates for all products are not known at this time, each product has a default commission rate of 12 percent. The rate can be modified as necessary. You add the new column. You need to configure the table to assign the default value as efficiently as possible. What should you do?()
第8题:
Using the reports server how would you force the orders report in the orders entry application to run every six hours?()
第9题:
You are planning the migration of an existing application to Windows Azure and SQL Azure. The application produces report files at the request of remote systems. Requests for report files will be placed into a single Windows Azure Queue. You must minimize the compute resources and storage transactions required to process the requests. You need to recommend an approach for processing the requests. What should you recommend?()
第10题:
You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. You create a window named ManageOrders that contains a Button control named showOtherSide. You add an animation named FlipSides as a resource of ManageOrders. You need to ensure that the following requirements are met: FlipSides runs each time a user clicks showOtherSide. FlipSides runs only when a user clicks showOtherSide. What should you do?()