多选题What are two common reporting requirements?（）Athe database connectivity methodBthe number of users in the solutionCthe number of reports being installedDability to send completed reports by e-mailEreporting output available in Microsoft Excel

第1题：

What two statistics appear in show frame-relay map output?（）

• A、The number of FECN packets that are received by the router
• B、The number of BECN packets that are received by the router.
• C、The ip address of the local router
• D、The value of the local DLCI
• E、The status of the PVC that is configured on the router

第2题：

What two statistics appear in show frame-relay map output?（）

• A、The number of FECN packets that are received by the router
• B、The number of BECN packets that are received by the router
• C、The ip address of the local router
• D、The value of the local DLCI
• E、The status of the PVC that is configured on the router

第3题：

An administrator notices that some of their systems are reporting a number in the eferred Level?column on the HMC pdates?panel. WhatAn administrator notices that some of their systems are reporting a number in the ?eferred Level?column on the HMC ?pdates?panel. What is the meaning of the eferred Level?is the meaning of the ?eferred Level?（）

• A、The number denotes the firmware level which will be activated when AIX is next rebooted.
• B、The number denotes the firmware level which will be activated when all LPARs are next started.
• C、The number denotes the firmware level which will be activated when the managed system is next restarted.
• D、The number denotes how many days have elapsed since the firmware was installed without the LPARs being reactivated.

第4题：

In your datawarehousing application， you generate reports frequently. The data is static in the tables being used to generate reports. You are currently using joins， resulting in a large performance overhead. What kind of database structure would you use to reduce the response time of the query？（）

• A、hash clusters
• B、index clusters
• C、partitioned tables
• D、index­organized table （IOT）

第5题：

You use a Windows 2000 Professional computer to run a weekly accounts table. The report has the name ap_financial_reports. You also want to use the computer to run a task named perf_log to connect to network routers and retrieve their performance logs. When the ap_financial_reports is running on the computer, the perf_log task stops responding the eventually times out. When you run only the perf_log task, the task completes successfully. You use the task manager to view your system resources. You want to resolve the performance log time out problem by using task manager. What should you do?（）

• A、Decrease the base priority of the ap_financial_reports task.
• B、Decrease the number of threads available for the ap_financial_reports task.
• C、Increase the base priority of the perf_log task.
• D、Increase the number of threats available for perf_log task.

第6题：

ou share a computer with other users.  You need to ensure that all application and device driver failure reports for this computer are submitted to Microsoft Problem Reports and Solutions.  What should you do？（）

• A、After each error occurs， perform a Microsoft Windows Update scan.
• B、Turn on the Windows Problem Reporting feature for all users.
• C、Configure the computer to take part in the Microsoft Windows Customer Experience Improvement Program.
• D、Create a standard user account. Instruct all users to log on by using this standard user account. Configure auditing for this user account.

第7题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a single Database Mail profile. Reports are sent to all the company employees by using the Mail profile. During office hours, a large volume of reports are sent by the sp_send_dbmail stored procedure. Now you notice that it takes a long time for the reports to be sent to the company manager. As the technical support, you have to speed up the delivery. So what action should you perform to achieve this goal?（）  

• A、Another SMTP account should be added to the existing Database Mail profile 
• B、When you send the reports to the manager, you should use the @importance = high parameter. 
• C、You should change the Account Retry Attempts option of the Database Mail system properties 
• D、You should configure a new Database Mail profile. The new one will be used for sending the reports to the manager. 

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

What is the maximum number of users that can be added to an autonomous access point that is being used as a local authenticator？（）

• A、75
• B、100
• C、25
• D、50

第14题：

What are two common reporting requirements?（）

• A、the database connectivity method
• B、the number of users in the solution
• C、the number of reports being installed 
• D、ability to send completed reports by e-mail
• E、reporting output available in Microsoft Excel

第15题：

You query the ORDERS table and discover that order number 1101 is missing. One of your reports， generated at 5：00 A.M. on April 23， 2005 using Oracle Reports， includes this order number in the output. You have inserted 100 new orders into the ORDERS table since generating this report. Which flashback technology would you use to recover order number 1101 into the ORDERS table without losing the 100 orders that you added after the report was generated？（）  

• A、 Flashback Table
• B、 Flashback Query
• C、Flashback Version Query
• D、 Flashback Transaction Query

第16题：

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.

第17题：

You design a Business Intelligence （BI） solution by using SQL Server 2008.  You plan to create a SQL Server 2008 Reporting Services （SSRS） solution that contains five sales dashboard reports.  Users must be able to manipulate the reports’ parameters to analyze data. You need to ensure that the following requirements are met： Users can manipulate the parameters for data analysis in a single trip to the data source.  Reports are automatically rendered as soon as they are accessed for the first time. Which two tasks should you perform？（）

• A、 Filter data by using expressions.
• B、 Specify the default values for each parameter.
• C、 Create an available values list for each parameter.
• D、 Create report parameters by using query parameters to filter data at the data source.

第18题：

You are a database administrator for your company. The company uses a SQL Server 2005 computer that runs Reporting Services. Reporting Services is used to produce hundreds of reports each day. You discover that the ReportServerTempDB database is growing. You need to minimize the size of the ReportServerTempDB database. What should you do？（）

• A、Decrease the time between transaction log backups of the database.
• B、Delete report snapshot history each week.
• C、Minimize the use of session caching in the reports.
• D、Minimize the use of report snapshots in the reports.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：