What are two common reporting requirements?（）A、the database connectivity methodB、the number of users in the solutionC、the number of reports being installed D、ability to send completed reports by e-mailE、reporting output available in Microsoft Excel

第1题：

Which two are differences between IGMPv2 and IGMPv3 reports？（）

• A、IGMPv3 has the ability to include or exclude source lists.
• B、All IGMPv3 hosts send reports to destination address 224.0.0.22.
• C、Only IGMPv2 reports may contain multiple group state records.
• D、All IGMPv3 hosts send reports to destination address 224.0.0.23.
• E、IGMPv2 does not support the Leave Group message.

第2题：

A customer is looking to build a virtual desktop infrastructure on an IBM platform. What metrics will be most useful in determining the storage platform recommendation?（）

• A、number of users, type of applications to be used
• B、performance per user, network bandwidth available
• C、number of users, storage capacity per user, network bandwidth available
• D、number of users, number of applications per user, network bandwidth available

第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题：

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

第5题：

You are adatabase solutions architect.Your company plans to develop asolution by using a SQLServer 2008 instance. The solutionhas the following business requirements: Import datafromvarious datasources suchas MicrosoftOffice Excel, Microsoft SQL Server2000, Microsoft SQL Server 2005, and CSV files. Profile the source data before it is imported. Provide collaboration andoffline capabilities to mobile users. Allowmobile users to use heterogeneous data stores. You need to configure the appropriate SQL Server components to accomplish the business requirements. You want to achieve this goal by using the minimum amount of administrative effort. Which two SQL Server components should you use?（）

• A、Analysis Services
• B、Reporting Services
• C、Integration Services
• D、Notification Services
• E、Microsoft Sync Framework

第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题：

Which application is installed with IBM Enterprise Asset Management for providing reporting capability?（）

• A、Open Database Platform
• B、External Report Integration 
• C、Business Objects/Crystal Reports
• D、Business Intelligence Reporting Tool

第14题：

在MSCserver中，Event reporting的哪个event number记录的是关于SCCP层的问题？（）

• A、EVENT NUMBER=145
• B、EVENT NUMBER=201
• C、EVENT NUMBER=100
• D、EVENT NUMBER=1029

第15题：

You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database12c. Your database supports a mixed workload. During the day, lots of insert, update, and deleteoperations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause ofperformance degradation, you want to collect basic statistics such as the level of parallelism, totaldatabase time, and the number of I/O requests for the ETL jobs. How do you accomplish this?（）

• A、Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.
• B、Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.
• C、Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.
• D、Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information.

第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题：