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
您可能感兴趣的试题
1
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.

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

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

图形验证:看不清?点击更换 换一换
免验证查看
  • 49.8

    ¥75 每天只需0.6元
    3个月 推荐
  • 39.8

    ¥60
    1个月
  • 99.8

    ¥150
    1年

选择支付方式

  • 微信付款
  • 支付宝付款
郑重提醒:支付后,系统自动为您完成注册

请使用微信扫码支付(元)

订单号:
支付后,系统自动为您完成注册
遇到问题请联系在线客服

恭 喜 您 获 得
扫 码 免 费 领 取
会 员 或 搜 题 次 数
本弹窗关闭将不再弹出
请不要关闭本页面,支付完成后请点击【支付完成】按钮
遇到问题请联系在线客服
常用手机号:
用于找回密码
图片验证码:
看不清?点击更换
短信验证码:
新密码:
 
扫码看答案