网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
You create a financial report to be represented to board of directors. The accounting manager has asked you to change the number format to show a thousand separator. What is the best method to make this change to the report quickly?()
A

Open the property palette and set the format mask for all the numeric items in the report. 

B

Select the data to be free formatted in the life previewer and lick on the thousand separator icon on the style bar. 

C

Go to the layout model and change the field attributes for the data to be changed on the report. 

D

Rebuild the report using the report wizard setting this format on creation.


参考答案

参考解析
解析: 暂无解析
更多 “单选题You create a financial report to be represented to board of directors. The accounting manager has asked you to change the number format to show a thousand separator. What is the best method to make this change to the report quickly?()A Open the property palette and set the format mask for all the numeric items in the report. B Select the data to be free formatted in the life previewer and lick on the thousand separator icon on the style bar. C Go to the layout model and change the field attributes for the data to be changed on the report. D Rebuild the report using the report wizard setting this format on creation.” 相关考题
考题 You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers.You are also the administrator of Oracle relational database management system (RDBMS) server.This server is used to store your company’s financial information. The financial information is updated frequently throughout the day.You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.You want to create reports on the SQL Server computer by using the minimum amount of disk space.What should you do?A.Set up SQL server replication to replicate the data from the oracle server to the SQL server computer.B.Set up the oracle server as a linked server. Create a view that joins the service contract information and the financial information.C.Set up data transformation services (DTS) package that imports and transforms the database from the oracle server to the SQL server computer. Use SQL server agent to execute the DTS package throughout the day as needed.D.Set up Microsoft ActiveX script. that connects to the oracle server and imports the financial information into SQL server temporary table. Create a view that joins the service contract information and the temporary table.

考题 The sales report needs to display the sales person with the highest order total. Which build report builder component would you use to create a place holder column to display the value?()A、Report wizard. B、Layout model. C、Data model. D、Life previewer.

考题 You are creating a Windows Forms application by using the .Net Framework 3.5.You create an instance of a Backgroundworker component named backgroundWorker1 to process operations that take a long time.You discover that when the application attempts to report the progress,you receive a System.InvalidOperationException exception when executing  the backgroundWorker1.ReportProgress method.You need to configure the BackgroundWorker component appropriately to prevent the application from generating exceptions.What should yo do?()A、Set the Result property of the DoWorkEventArgs instance to True before you attempt to report the progress.B、Set the CancellationPending property of backgroundWorker1 to True before you attempt to report the background processC、Set the WorkerReportsProgress property of backgroundWorker1 to True before you attempt to report the background process.D、Report the progress of the background process in the backgroundWorker1_ProgressChanged event.

考题 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 parameter. C、Create a trigger in the application to execute the report every six hours. D、You cannot schedule a reports execution.

考题 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?() A、the DBNEWID utilityB、the DBVERIFY utilityC、the ANALYZE commandD、the RMAN REPORT commandE、the RMAN CROSSCHECK commandF、the CHECK_OBJECT procedure of the DBMS_REPAIR package

考题 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.

考题 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.

考题 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?()A、 Create a worker role for each report file that constantly polls the queue for requests.B、 Create a workerrole for each report file that checks the queue at scheduled intervals for requests.C、 Create a single worker role that constantly polls the queue for requests and executes the requests on multiple threads.D、 Create a single worker role that checks the queue at scheduled intervals for requests and executes the requests on multiple threads.

考题 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.

考题 You design a SQL Server 2008 Reporting Services (SSRS) solution. You create a report by using Microsoft Visual Studio .NET 2008. The report contains the following components: A dataset named Customer that lists all active customers and their details. The dataset accepts no parameters. A dataset named SalesHistory that lists all sales transactions for a specified time period and accepts year and month as parameters. You need to ensure that a summary of sales transactions is displayed for each customer after the customer details. Which component should you add to the report? ()A、 ListB、 TableC、 MatrixD、 Subreport

考题 You install a new Exchange Server 2010 organization that contains a single server named erver1.Users report that they receive a large number of unsolicited commercial email (UCE) messages.You need to reduce the amount of UCE messages that users in the organization receive.What should you do?()A、Create a journal rule and then create an Outlook Protection RuleB、Create a Transport Protection Rule and then create a journal ruleC、Run the AntispamCommon.ps1 script and then create a Transport Protection RuleD、Run the Install-AntispamAgents.ps1 script and then configure all transport agents

考题 You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services (SSRS) solution. The solution contains a report named Sales Details that displays sales information of all the employees. You create an SSRS report named Sales Summary that displays the total monthly sales of each employee. Users who view the Sales Summary report occasionally require the monthly sales details for a particular employee. You need to ensure that the users can click a value in the month column of the Sales Summary report to open and render the Sales Details report. What should you do?()A、 Use a subreport.B、 Use a bookmark link.C、 Use the drilldown functionality.D、 Use a drillthrough report link.

考题 You need to provide analyst reporting capabilities that fulfill the business requirements. What should you do?()A、Add a Report Viewer control to APP3.B、Add an Internet Explorer ActiveX control to APP3. Set the controls URL to the A Datum Corporation Report Manager.C、Create a hyperlink in APP3 that references the Report Manager.D、Create a proxy class to the Report Server Web service.

考题 单选题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?()A  Create a worker role for each report file that constantly polls the queue for requests.B  Create a workerrole for each report file that checks the queue at scheduled intervals for requests.C  Create a single worker role that constantly polls the queue for requests and executes the requests on multiple threads.D  Create a single worker role that checks the queue at scheduled intervals for requests and executes the requests on multiple threads.

考题 单选题You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services (SSRS) solution. The solution contains a report named Sales Details that displays sales information of all the employees. You create an SSRS report named Sales Summary that displays the total monthly sales of each employee. Users who view the Sales Summary report occasionally require the monthly sales details for a particular employee. You need to ensure that the users can click a value in the month column of the Sales Summary report to open and render the Sales Details report. What should you do?()A  Use a subreport.B  Use a bookmark link.C  Use the drilldown functionality.D  Use a drillthrough report link.

考题 单选题Upon hearing the abandon ship signal,you put on your life jacket and report to your station. After the cover is removed you board your open lifeboat boat. The FIRST thing to do is to().A release the gripesB release tricing pendantsC put the cap on the drainD lift the brake handle

考题 单选题Using the report wizard you create a tabular report to display all the columns in the EMP table. The records are ordered by the deptname and job columns. You need to create a hierarchical report that breaks on the deptname and job values. Using the data model how would you create this break structure?()A Specify the break order on the gemp group Property palette. B Specify a break order on the dept_name and job columns property palettes. C Click and drag the dept_name and jobs column out and above of the gemp group to create a new parent group. D Change the position of the dept_name and the job columns within the gemp group.

考题 单选题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?()A the DBNEWID utilityB the DBVERIFY utilityC the ANALYZE commandD the RMAN REPORT commandE the RMAN CROSSCHECK commandF the CHECK_OBJECT procedure of the DBMS_REPAIR package

考题 单选题You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to create a SQL Server 2008 Reporting Services (SSRS) solution. Developers generate random reports against a data source that contains 200 tables. Power users generate random reports against four of the 200 tables. You need to design a strategy for the SSRS solution to meet the following requirements: ·Uses minimum amount of development effort. ·Provides two sets of tables in SSRS to the developers group and the power users group. Which strategy should you use?()A  Create two Report Builder models.Include the four frequently used tables in the first model and all the tables in the second model.B  Create a Report Builder model by using all the tables.Create a perspective within the model to use only the four frequently used tables.C  Create a Report Builder model by using all the tables. Create two folders.Place the four frequently used tables in the first folder and the remaining tables in the second folder.D  Create two Data Source Views.Include all the tables in one Data Source View and the four frequently used tables in the other Data Source View.Create two Report Builder models so that each model uses one of the Data Source Views.

考题 单选题You use a Windows 2000 Professional computer to run a weekly accounts table. The report has the name ap_financial_reports. You also want the use the computer to run a task named perf_log to connect to network routers and retrieve their performance logs. When the ap_financial_report is running on the computer 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.

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

考题 单选题You want to create a template to be used as a standard for all company reports, which are many different styles. How many different templates must you have if you plan to use multiple report styles?()A Two B One C One per report styleD One per report style + one more

考题 单选题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 filesB Using the Windows Explorer, disable the cache for the reports on the network shareC Use the Windows NT explorer to grant the special access for the reports on the network  shareD Use the synchronization manager to configure synchronization not to occur when users are  connected to the LAN connection. 

考题 单选题36 You are creating a report wizard to create a matrix report. The query build, you select the patient_name column from the patient table; the doctor_name from the doctors table; and the doctor_ID, patient_ID and ID columns from the procedure table. In the report wizard you select patient_name as the row value, doctor_ID as the column values and the count as the cell values. You need to add a total for each doctors column. In the wizard report which tab will allow you to create the summary column?()A Rows B Totals C Columns D Cells E Data

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

考题 多选题You need to create a trigger to locate the Product report in the Rpt_Server, run the report, and test the status of the report. Which three built-ins would you use to accomplish this task?()ARUN_PRODUCTBSET_REPORT_OBJECT_PROPERTYCRUN_REPORT_OBJECTDFIND_REPORT_OBJECTEREPORT_OBJECT_STATUSFCOPY_REPORT_OBJECT_OUTPUT

考题 单选题You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services (SSRS) solution by using SQL Server 2008. Several reports on the server use a shared data source named DSProduction. You modify an existing report that uses the DSProduction data source. After deployment, the modified report must use an alternate data source. You need to prevent the modified report from affecting other reports. What should you do?()A  Update the connection string of the DSProduction shared data source to point to the alternate data source.B  Update the modified report to use a report-specific data source. Update the connection string of the report-specific data source to point to the alternate data source.C  Create a new shared data source named DSProduction in the same folder as that of the modified report. Update the connection string of the new shared data source to point to the alternate data source.D  Disable the DSProduction data source. Update the modified report to use a report-specific data source. Update the connection string of the report-specific data source to point to the alternate data source.