niusouti.com

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

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

2. You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the Oracle database（）A、Use the external table population.B、Use the Oracle Data Pump export and import utility.C、Use the conventional path data load of the SQL*Loader utility.D、Use the INSERT INTO...SELECT command to load the data

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 tableB、object tableC、external tableD、clustered tableE、global temporary tableF、index-organized table （IOT）

4. 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 tableB、object tableC、external tableD、clustered tableE、global temporary tableF、index­organized table （IOT）

参考答案和解析
正确答案： B
解析： 暂无解析
更多“单选题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 ”相关问题

  • 第1题：

    The customer and order tables are often used in joins， thereby resulting in complex queries. You created views to simplify the writing of queries. These views are stored in（）.

    • A、user tables
    • B、view segment
    • C、table segment
    • D、data dictionary
    • E、object segment
    • F、performance tables

    正确答案:D

  • 第2题：

    You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）

    • A、use the external table population
    • B、use the Oracle Data Pump export and import utility
    • C、use the conventional path data load of SQL*Loader utility
    • D、use the direct path data load of Oracle export and import utility

    正确答案:C

  • 第3题：

    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

  • 第4题：

    Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g？（） 

    • A、 Generate reports on data failure such as data file failures.
    • B、 You can track the Service Request （SR） and implement repairs.
    • C、 You can package and upload diagnostic data to Oracle Support.
    • D、 You can manually run health checks to gather diagnostic data for a problem.

    正确答案:B,C,D

  • 第5题：

    You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-only reference data. You need to design the physical database structure for optimal backup performance. What should you do?（） 

    • A、Create the database by using a single data file and a single log file.
    • B、Create the database by using a single data file and multiple log files.
    • C、Create the database by using a single log file and multiple filegroups.
    • D、Create the database by using a single log file and a filegroup that has multiple data files.

    正确答案:C

  • 第6题：

    A Windows Azure application retrieves data from SQL Azure.   You need to recommend an approach for improving application query performance.  What should you recommend？（）

    • A、 Create a database view to retrieve the data.
    • B、 Use a clustered index on the SQL Azure database tables.
    • C、 Open a new database connection when an operation times out.
    • D、 Create SQL Azure database table indexes basedon application queries

    正确答案:D

  • 第7题：

    单选题
    You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database. What should you？（）
    A

    Configure a Linked Server connection to the application database.

    B

    Write a query that uses an OPENDATASOURCE command.

    C

    Write a query that uses an OPENQUERY command.

    D

    Configure a Remote Server connection to the application database.


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

  • 第8题：

    单选题
    You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database.  While migrating the data， you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database（）
    A

    Use the external table population.

    B

    Use the Oracle Data Pump export and import utility.

    C

    Use the conventional path data load of the SQL*Loader utility.

    D

    Use the INSERT INTO...SELECT command to load the data.


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

  • 第9题：

    单选题
    You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-only reference data. You need to design the physical database structure for optimal backup performance. What should you do?（）
    A

    Create the database by using a single data file and a single log file.

    B

    Create the database by using a single data file and multiple log files.

    C

    Create the database by using a single log file and multiple filegroups.

    D

    Create the database by using a single log file and a filegroup that has multiple data files.


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

  • 第10题：

    单选题
    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
    解析： 暂无解析

  • 第11题：

    单选题
    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
    解析： 暂无解析

  • 第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）


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

  • 第13题：

    You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database.  While migrating the data， you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database（）

    • A、Use the external table population.
    • B、Use the Oracle Data Pump export and import utility.
    • C、Use the conventional path data load of the SQL*Loader utility.
    • D、Use the INSERT INTO...SELECT command to load the data.

    正确答案:C

  • 第14题：

    The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump.  Which option of Data Pump Import would you use to accomplish this？（）  

    • A、 owner
    • B、 touser
    • C、 attach
    • D、 remap_schema

    正确答案:D

  • 第15题：

    Your database is using shared server configuration. Which optional memory structure would you configure to store the User Global Area （UGA） information and improve the shared pool performance？（）

    • A、large pool
    • B、streams pool
    • C、keep buffer cache
    • D、recycle buffer cache

    正确答案:A

  • 第16题：

    You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database. What should you？（）

    • A、Configure a Linked Server connection to the application database.
    • B、Write a query that uses an OPENDATASOURCE command.
    • C、Write a query that uses an OPENQUERY command.
    • D、Configure a Remote Server connection to the application database.

    正确答案:B

  • 第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. 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.

    正确答案:B

  • 第18题：

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


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

  • 第19题：

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


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

  • 第20题：

    单选题
    You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the Oracle database（）
    A

    Use the external table population.

    B

    Use the Oracle Data Pump export and import utility.

    C

    Use the conventional path data load of the SQL*Loader utility.

    D

    Use the INSERT INTO...SELECT command to load the data


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

  • 第21题：

    单选题
    You are the network administrator for your company. The network consists of a single Active Directory domain. The network contains an application server running Windows Server 2003.   Users report intermittent slow performance when they access the application server throughout the day. You find out that the network interface on the application server is being heavily used during the periods of slow performance. You suspect that a single computer is causing the problem.You need to create a plan to identify the problem computer.   What should you do？（）
    A

     Monitor the performance monitor counters on the application server by using System Monitor.  

    B

     Monitor the network traffic on the application server by using Network Monitor.

    C

     Monitor network statistics on the application server by using Task Manager.

    D

     Run network diagnostics on the application server by using Network Diagnostics.


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

  • 第22题：

    单选题
    You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables.  While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）
    A

    use the external table population

    B

    use the Oracle Data Pump export and import utility

    C

    use the conventional path data load of SQL*Loader utility

    D

    use the direct path data load of Oracle export and import utility


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

  • 第23题：

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


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

  • 第24题：

    单选题
    You work with a SQL Server 2005 database that provides banking information for customers. You want customers to see banking reports that combine data that is retrieved from the database with real-time investment information that comes from a Web service provided by a third party. The investment information must be current when the reports are executed. You need to create the appropriate objects that support the reports.  What should you do?（）
    A

     Publish the data in the database as an XML Web service by using the FOR XML AUTO clause. 

    B

     Create a table to store the banking information for each customer. Create a trigger that fires when data is inserted into the table that joins with the data coming from the Web service. 

    C

     Create a Transact-SQL stored procedure that uses a temporary table to store the banking information for each customer. Update the table with the values from the Web service. 

    D

     Have a developer in your company create an assembly that calls the remote Web service. Create aCLR function by using the assembly. Call the CLR function and combine the results with banking information in the database.


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

相关内容