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

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

相似考题

1.You can ask for an () lateter if you want your parents come for your graduation ceremonyA.invitationB.introductionC.requirementD.application

2.You are the administrator of a SQL Server 2000 computer. Your company purchased an accounting application from a vendor. The application stores its data in a database named Accounting on the server. The tables in this database contain columns that function as primary keys, but PRIMARY KEY and FOREIGN KEY constraints are not used.You need to replicate data from this database to another SQL Server computer. This server will use the replicated data to generate reports. Most reports will run each month, but the accounting department needs to have the ability to run reports at any time. Reports should be accurate through the last full working day.You cannot make any changes to the database, but you need to implement replication. Which two actions should you take? (Each correct answer presents part of the solution. Choose two)A．Implement merge replication.B．Implement snapshot replication.C．Implement transactional replication.D．Schedule replication to run continuously.E．Schedule replication to run during off-peak hours.

3.You administer your company‘s network. All client computers run Microsoft Windows Vista. A standard user reports that they are unable to install an application. You need to install the applicatin.What should you do?（）A.AB.BC.CD.D

4.Your database supports an online transaction processing (OLTP) application.The application is undergoing some major schema changes, such as addition of new indexes and materialized views.You want to check the impact of these changes on workload performance.What should you use to achieve this?（）A. Database replayB. SQL Tuning AdvisorC. SQL Access AdvisorD. SQL Performance AnalyzerE. Automatic Workload Repository compare reports

更多“In your datawarehousing application， you generate reports fr”相关问题

  • 第1题：

    You work as a Web Developer at Certkiller.com. You are in the process of creating a Webapplication using Microsoft ASP.NET 3.5.  You host the Web application in Microsoft Internet Information Services （IIS） 6.0. You browse theapplication and receive the following error message：  Server Application Unavailable  The web application you are attempting to access on this web server is currently unavailable.Please hit the "Refresh" button in your web browser to retry your request.  You view the Application event log and discover the following message：  It is not possible to run two different versions of ASP.NET in the same IIS process. Please use theIIS Administration Tool to reconfigure your server to run the application in a separate process.  To ensure productivity you need to solve this problem as quick as possible.  What should you do？（）

    • A、You should change the IIS isolation mode.
    • B、You should assign the application to another application pool.
    • C、You should configure all applications that are part of your application's application pool in orderto use the same version of ASP.NET.
    • D、You should run the Aspnet_regiis.exe Tool.
    • E、You should restart the application pool that hosts the application.

    正确答案:B,C

  • 第2题：

    If you want to reset your configuration back to the factory defaults but keep your logs and reports，Which CLI command should you use？（）

    • A、resetconfig
    • B、restoreconfig
    • C、loadconfig
    • D、reload

    正确答案:A

  • 第3题：

    In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables.  What is the best table structure that you can use to gain optimal performance？（）

    • A、heap table
    • B、object table
    • C、external table
    • D、clustered table
    • E、global temporary table
    • F、index-organized table （IOT）

    正确答案:A

  • 第4题：

    Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?（）

    • A、Database replay
    • B、SQL Tuning Advisor
    • C、SQL Access Advisor
    • D、SQL Performance Analyzer
    • E、Automatic Workload Repository compare reports

    正确答案:E

  • 第5题：

    You recently installed an application on your computer. The application is configured to automatically start. This application might cause your computer to run slower.  You need to prevent the application from auto starting without uninstalling the application.  What should you do？（）

    • A、Use the Microsoft Windows Task Manager application to end the task for the application.
    • B、Use the Control Panel application to uninstall the application. Reboot the computer.
    • C、Use the Software Explorer application to disable the application. Reboot the computer.
    • D、Use the Services application to disable the Application Experience service， and then launch the application.

    正确答案:C

  • 第6题：

    You are the desktop administrator for your company. Your company’s software developers use Windows XP Professional and IIS on their client computers to develop Web-based applications. All client computers use Microsoft Internet Explorer 6. 0 or later as their Web browser. One of the developers reports that he can no longer access the Web-based application on his desktop by using his Web browser. When you attempt to access the application by using your Web browser, you receive the following error message: “Cannot find server or DNS Error.” You verify that the World Wide Web Publishing Service is started on the developer’s computer. You also verify that you are using the correct URL to access the developer’s computer by using your Web browser. You need to ensure that the developer can access the Web application by using his Web browser. How should you configure the developer’s computer?（） 

    • A、Start the default Web site.
    • B、Start the IIS Admin Service.
    • C、Run the IPconfig /registerdns command.
    • D、In the default Web site properties，disable the host header setting.

    正确答案:A

  • 第7题：

    单选题
    What is a prerequisite for using the application availability analysis tool in HACMP？（）
    A

     Tivoli is required to generate reports from the data collected.

    B

     An application monitor must be associated with the application to monitor.

    C

     An aaatd daemon must be started and added in as a post event to node_up_complete.

    D

     Resource group is present on all of the systems in the cluster that have the desired application.


    正确答案： B
    解析： 暂无解析

  • 第8题：

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


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    You have created an Oracle 10g database named SALES， which will be used by an application named SalesOrders. Users of the SalesOrders application complain that application response time is slow when they generate reports. The SalesOrders application accesses a table that contains 10 million rows. You decide to create an index on this table using the NOLOGGING option so that the index creation process is completed in the least amount of time. Which of the following is NOT true about an index created with the NOLOGGING option？（）
    A

     The index can be changed from NOLOGGING to LOGGING

    B

     The index cannot be recovered even in the ARCHIVELOG mode.

    C

     The index can only be created if the base table is created with the NOLOGGING option.

    D

     The index can be recovered if you perform a backup after the CREATE INDEX statement.


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance.  Which advisory component would you refer to， in order to determine the appropriate indexes？（）
    A

    Memory Advisor

    B

    Segment Advisor

    C

    SQL Access Advisor

    D

    Automatic Workload Repository （AWR）

    E

    Automatic Database Diagnostic Monitor （ADDM）


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine the appropriate indexes？（）
    A

     Memory Advisor

    B

     Segment Advisor

    C

     SQL Access Advisor

    D

     Automatic Workload Repository （AWR）

    E

     Automatic Database Diagnostic Monitor （ADDM）


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables.  What is the best table structure that you can use to gain optimal performance？（）
    A

    heap table

    B

    object table

    C

    external table

    D

    clustered table

    E

    global temporary table

    F

    index­organized table （IOT）


    正确答案： E
    解析： 暂无解析

  • 第13题：

    In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables.  What is the best table structure that you can use to gain optimal performance？（）

    • A、heap table
    • B、object table
    • C、external table
    • D、clustered table
    • E、global temporary table
    • F、index­organized table （IOT）

    正确答案:A

  • 第14题：

    What is a prerequisite for using the application availability analysis tool in HACMP？（）  

    • A、 Tivoli is required to generate reports from the data collected.
    • B、 An application monitor must be associated with the application to monitor.
    • C、 An "aaatd" daemon must be started and added in as a post event to "node_up_complete".
    • D、 Resource group is present on all of the systems in the cluster that have the desired application.

    正确答案:B

  • 第15题：

    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.

    正确答案:A

  • 第16题：

    You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance.  Which advisory component would you refer to， in order to determine the appropriate indexes？（） 

    • A、Memory Advisor
    • B、Segment Advisor
    • C、SQL Access Advisor
    • D、Automatic Workload Repository （AWR）
    • E、Automatic Database Diagnostic Monitor （ADDM）

    正确答案:C

  • 第17题：

    You administer your companys network. All client computers run Microsoft Windows Vista. A standard user reports that they are unable to install an application. You need to install the application.  What should you do？ （）

    • A、While the standard user is logged on， at the consent prompt， click Continue and install the application.
    • B、While the standard user is logged on， at the credential prompt， provide administrative credentials.
    • C、Create a .pwl file that stores administrative credentials. Double-click the installation file.
    • D、Copy the contents of the CD-ROM to the local hard disk. Run the application installation from  the local hard disk.

    正确答案:B

  • 第18题：

    You need to generate the utilization report for the application servers. What should you use to generate the report？（）

    • A、Microsoft Assessment and Planning Toolkit （MAP）
    • B、Microsoft Desktop Optimization Pack （MDOP）
    • C、Microsoft System Center Virtual Machine Manager
    • D、Microsoft System Center Operations Manager

    正确答案:D

  • 第19题：

    单选题
    You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. The application contains a custom control that is used to display customer information. You discover that the custom control is not rendering correctly. You need to identify the WPF element that is causing the issue. You want to achieve this goal by using the minimum amount of administrative effort. What should you do?（）
    A

     Start the application in debug mode.Place a breakpoint at the main entry point of the application.Use the debugger to step through the application code.

    B

     Start the application in debug mode.Place a breakpoint at the main entry point of the application.Use the WPF Tree Visualizer tool.

    C

     Enable IntelliTrace and configure Visual Studio to generate a trace log.Start the application in debug mode.

    D

     Enable IntelliTrace and configure Visual Studio to generate a trace log.Start the application by double-clicking the executable file (.exe).


    正确答案： D
    解析： 暂无解析

  • 第20题：

    单选题
    In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables. What is the best table structure that you can use to gain optimal performance？（）
    A

     Heap table

    B

     Object table

    C

     External table

    D

     Clustered table

    E

     Global temporary table

    F

     Index-organized table （IOT）


    正确答案： D
    解析： 暂无解析

  • 第21题：

    多选题
    You are designing a Windows Azure web application.  All users authenticate by using their Active Directory Domain Services （AD DS） credentials.  You need to recommend an approach for enabling single sign-on for domain-authenticated users.   Which two actions should you recommend？（）
    A

    Use Forms authenticationto generate claims.

    B

    Use Active Directory Federation Services （AD FS） to generate claims.

    C

    Use SqlMembershipProvider in the web application.

    D

    Use Windows Identity Foundation in the web application.


    正确答案： D,C
    解析： 暂无解析

  • 第22题：

    单选题
    Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?（）
    A

    Database replay

    B

    SQL Tuning Advisor

    C

    SQL Access Advisor

    D

    SQL Performance Analyzer

    E

    Automatic Workload Repository compare reports


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    In order to achieve his objectives, your boss expects that you will _____.
    A

    do your best in your work

    B

    show your management skills

    C

    get along with your colleagues

    D

    write reports to upper management


    正确答案： A
    解析：
    信息提取题。由第一句“Your boss also needs you to perform at your best in order to accomplish his objectives”可知，为了达到上司的目标，上司需要你尽力做到最好。A项是对题目的同义替换，因而是最佳选项。B、C项在文中都没有提到。D项张冠李戴，定位到第三段第二句“He needs your feedback in order to provide realistic and useful reports to upper management”，他需要你的反馈来向高管提供实际有用的报告，很明显是他给上层管理部门写报告而不是你，故排除。

  • 第24题：

    单选题
    You are the desktop administrator for your company's sales department. The IT manager for the sales department needs to distribute a custom application to the Windows XP Professional computers in the sales department. He deploys the software by using Group Policy. Susan is a user in the sales department. She reports that the custom application is not available. You examine her computer, and you verify that the application is not present on her computer. You want to ensure that the software is deployed the next time Susan logs on. Which command should you run?（）
    A

    Secedit /refreshpolicy user_policy /enforce

    B

    Secedit /refreshpolicy machine_policy /enforce

    C

    Gpupdate /target:computer /sync

    D

    Gpupdate /target:user /sync


    正确答案： D
    解析： 暂无解析

相关内容