题目

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.

提示:未搜索到的试题可在搜索页快速提交,您可在会员中心"提交的题"快速查看答案。
答案
查看答案
相关试题

________是网上支付使用最多的一种方式。
A.信用卡
B.电子支票
C.电子现金
D.电子货币

支付网关是连接银行专用网络与Internet的一组________。
A.通道
B.网络
C.协议
D.服务器

虚拟银行是现代金融业的发展方向它利用________来开展银行业务将导致一场深刻的银行革命。
A.电话
B.电视
C.传真
D.因特网

You are the administrator of a SQL Server 2000 computer. You want to set up snapshot replication on the server. The server will serve as Publisher and Distributor for a minimum of 40 Subscribers.
Currently, you want to publish 3GB of data, but the data is expected to grow over time. Subscribers will receive a new snapshot each month.
You want to minimize the workload on the Publisher/Distributor. Which two actions should you take to configure snapshot replication? (Each correct answer presents part of the solution. Choose two)
A.Store the snapshot in the default folder on the Publisher/Distributor.
B.Store the snapshot in an alternative folder on the Publisher/Distributor.
C.Store the snapshot in a shared folder on a file server.
D.Create pull subscriptions.
E.Create push subscriptions.

You are the administrator of a new Microsoft Windows 2000 server computer named HQSQL5. HQSQL5 is a member server in your company's Windows NT 4.0 domain, which is named HQMAIN.
After installing SQL Server 2000 on HQSQL5, you configure the MSSQLServer service account to use the HQMAINsqladmin user account, which is a member of the local administrators group on HQSQL5.
You can use the HQMAINsqladmin user account to log on the HQSQL5. However, the MSSQLServer service fails to start. You need to start the service. What should you do?
A.Revoke Log on interactivity rights for the HQMAINsqladmin user account.
B.Add the HQMAINsqladmin user account to the HQMAINDomain Admins group.
C.Select the Password Never Expires check box for the HQMAINsqladmin user account.
D.Grant Log on as a service rights to the HQMAINsqladmin user account.

联系我们 会员中心
返回顶部