违法和不良信息举报 联系客服
免费注册 登录

You create two resource plans, one for data warehouse loadin

题目
单选题
You create two resource plans, one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity.How would you achieve this?（）
A

Implement job classes

B

Implement Scheduler windows

C

Implement the mapping rule for the consumer groups

D

Set the SWITCH_TIME resource plan directive for both the resource plans

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

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 style
  • D、One per report style + one more

正确答案:B

第2题：

You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）

  • A、MERGE
  • B、SELECT …CROSS JOIN
  • C、INSERT ALL …SELECT
  • D、CREATE VIEW …CONSTRAINT

正确答案:A

第3题：

You must track all transactions that modify certain tables in the sales schema for at least three years.Automatic undo management is enabled for the database with a retention of one day.Which two must you do to track the transactions?（）

A. Enable supplemental logging for the database.

B. Specify undo retention guarantee for the database.

C. Create a Flashback Data Archive in the tablespace where the tables are stored.

D. Create a Flashback Data Archive in any suitable tablespace.

E. Enable Flashback Data Archiving for the tables that require tracking


参考答案：D, E

第4题：

You need to design the consolidation plan for SQL1， SQL2， and SQL3. You need to identify the appropriate combination of SQL Server instances and SQL Server 2005 computers that are needed to fulfill the company’s consolidation plans and security requirements.Which combination should you use？（）

  • A、one SQL Server 2005 computer with one instance
  • B、two SQL Server 2005 computers， each with two instances
  • C、two SQL Server computers， one with one instance and one with three instances
  • D、one SQL Server 2005 computer with two instances

正确答案:D

第5题：

In which scenario will you create a sorted hash cluster？ （）

  • A、 if the application uses queries joining tables only occasionally
  • B、 if the full table scan is executed often on only one table of the clustered tables
  • C、 if the data for all the rows of a cluster key value exceeds one or two Oracle blocks
  • D、 when you want the data to be returned automatically in the chronological order

正确答案:D

第6题：

You need to design a configuration for Exchange Server storage that meets the business and technical requirements. What should you do？（）

  • A、Create a single storage group. Create one database for all users
  • B、Create two storage groups. In each storage group， create one database. Place mailboxes for remote users in one storage group database， and place all other mailboxes in the other storage group database
  • C、Create two storage groups. In each storage group， create one database. Place executive mailboxes in one storage group database， and place all other mailboxes in the other storage group database
  • D、Create two storage groups. In one storage group， create a database， and place all mailboxes for remote users and executives in the database. In the other storage group， create a database for all other mailboxes

正确答案:C

第7题：

Your system performs heavy transaction processing between 8：00 A.M. and 5：00 P.M. but runs batch processing and reports after that. You decide to create a separate resource plan to govern resource allocation for each time period. Which scheduler object will you use to switch automatically between the two resource plans？（）  

  • A、 Window
  • B、 Program
  • C、 Job_Class
  • D、 Window group

正确答案:A

第8题：

You are the administrator of a SQL Server 2000 computer. You have two new hard disks on which you will create a database named inventory. You want to insert, update, and delete data as quickly as possible.

Which two actions should you take? (Each correct answer presents parts of the solution. Choose two)

A. Configure the hard disks as two mirrored NTFS volumes.

B. Configure the hard disks as one mirrored NTFS volumes.

C. Configure the hard disks as two independent NTFS volumes.

D. Configure the hard disks as one extended NTFS volume.

E. Place inventory_data.mdf on the first volume and inventory_log.ldf on the second volume.

F. Place inventory_data.mdf on the first volume and inventory_data2.ndf and inventory_log.ldf on the second volume.

G. Place inventory_data.mdf and inventory_log.ldf on the same volume.


正确答案：CE
C,E 解析：Explanation: Placing log files and the data files on different physical disks or independent volumes, and placing the log file of a drive that does not hold the operating system can improve database performance as it allows the frequently written to log file to exist a disk with its own read/write heads and thus less seek time.

Note: A Windows 2000 supports basic disks, in which physical disks are divided into partitions, and dynamic disks, in which disks are divided into volumes that can comprise an entire disk, two or more entire disks, portions of a disk, or portions of up to 32 physical disks.

A NTFS volume is volume that is formatted with the NTFS file system. Physical database design involves mapping the logical design onto physical media to allow for the data to be physically accessed and maintained as quickly as possible by taking advantage of the available hardware and software features. It is important to correctly design the database and to take advantage of hardware and software features early in the development cycle of a database application, because making changes to these components at a later stage it is difficult.

Incorrect Answers:
A: For redundancy and fault protection the log file can be placed on a mirrored volume. It would not be a good idea to put data files on a mirrored volume though. Performance when accessing the data would suffer.

Note: A mirrored volume is a fault-tolerant volume that duplicates data on two physical disks. It provides data redundancy as it copies the data on one volume to another volume on a different disk. When one of the physical disks fails, the data on the failed disk becomes unavailable, but the system can continue to operate by using the mirror disk. In such a set up, the data file and the log file will reside on the same drive. This will not improve database performance.

B: A mirrored volume cannot comprise of one volume only. It must comprise of two volumes on separate physical disks as a mirrored volume is a fault-tolerant volume that duplicates data on two physical disks. When one of the physical disks fails, the data on the failed disk becomes unavailable, but the system can continue to operate by using the mirror disk.

D: Data is written and read sequentially on extended volumes. As a result the data file and the log file will be placed on the same physical disk.

F: In this scenario the data file is separated into a primary data file, that uses the .mdf extension, and a secondary data file, that uses the .ndf extension. However, the secondary data file is placed on the same volume as the log file. This will lead to performance improvements only in cases where data is not read from the secondary data file.

G: Placing the data file and the log file on the same volume will not improve database performance as it will not allow parallel processing.

第9题：

You need to design a configuration for the mailbox servers. What should you do？（）

  • A、Create two Exchange Server 2003 computers. Place the mailboxes for main office users on one server， and place the mailboxes for remote users on the other server
  • B、Create a Network Load Balancing cluster that contains two Exchange Server 2003 computers. Place half of the user mailboxes on one server， and place half of the user mailboxes on the other server
  • C、Create a Microsoft Cluster Server cluster that contains two Exchange Server 2003 computers. Place all of the user mailboxes on one server and configure the other server as a failover node
  • D、Create a Microsoft Cluster Server cluster that contains two Exchange Server 2003 computers. Place half of the user mailboxes on one server， and place half of the user mailboxes on the other server

正确答案:D

第10题：

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 management data warehouse that uses the data collector to collect performance data. You intend to maintain the management data. You want to implement a data collection process. The process can gather and upload data in the management data warehouse on different schedules.  What process should you implement？（） 

  • A、You should create a cached data collection
  • B、You should create an on-demand non-cached data collection 
  • C、You should create a scheduled non-cached data collection 
  • D、You should create two different SQL Agent jobs that are scheduled stimultaneously

正确答案:A

更多相关问题
相关内容