You are the administrator of a SQL Server 2000 computer. Your company uses the server to s

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.

  • 悬赏:0 答案豆
  • 提问人:00****09
  • 发布时间:2013-01-08
您可能感兴趣的试题
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 HQMAIN\sqladmin user account, which is a member of the local administrators group on HQSQL5.You can use the HQMAIN\sqladmin 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 HQMAIN\sqladmin user account.

B.Add the HQMAIN\sqladmin user account to the HQMAIN\Domain Admins group.

C.Select the Password Never Expires check box for the HQMAIN\sqladmin user account.

D.Grant Log on as a service rights to the HQMAIN\sqladmin user account.

继续查找其他问题的答案?

请先输入下方的验证码查看最佳答案

图形验证:看不清?点击更换 换一换
免验证查看
开通上学吧会员
已为用户解答试题的人次:
1532188378
选择会员套餐:
推荐
¥39.8
1.3元/天
1个月
¥49.8
¥100
3个月
¥99.8
¥200
1年
选择支付方式:
微信付款
支付宝付款
会员特权: 会员须知
可退款
账号未使用的话,支持退款
免注册
支付后,系统自动注册账号给您
无限看题
不限次数随时看题
智能搜题
下载APP,可拍照、语音搜题
随时随地
电脑、手机、平板均可使用
免广告
纯净体验,自动屏蔽广告
开通上学吧会员
已为用户解答试题的人次:
1532188378
已选择:
请使用微信扫码支付¥49.8
订单号:
更改套餐或支付方式
会员特权: 会员须知
可退款
账号未使用的话,支持退款
免注册
支付后,系统自动注册账号给您
无限看题
不限次数随时看题
智能搜题
下载APP,可拍照、语音搜题
随时随地
电脑、手机、平板均可使用
免广告
纯净体验,自动屏蔽广告
恭 喜 您 获 得
扫 码 免 费 领 取
会 员 或 搜 题 次 数
本弹窗关闭将不再弹出
请不要关闭本页面,支付完成后请点击【支付完成】按钮
遇到问题请联系在线客服
常用手机号:
用于找回密码
图片验证码:
看不清?点击更换
短信验证码:
新密码:
 
绑定后可用手机号登录
谢谢您的反馈

您认为本题答案有误,我们将认真、仔细核查,如果您知道正确答案,欢迎您来有偿纠错