当前位置:MCITP(70-447)题库

问题:

[单选]

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A vendor company’s application is utilized, and the application is based on a proprietary database. Data is queried from the application database and the data is imported into a SQL Server 2005 database. A new OLE DB driver is offered by the application vendor, and the new OLE DB driver will be utilized when the application database is queried. According the company requirements, the connections between the SQL Server database and the application database is prohibited, except when this data is queried. You should think out a method to have data queried from the application database. 
Which action should be performed to achieve the goal?()

A . To achieve the goal, a Linked Server connection should be configured to the application database.
B . To achieve the goal, a query should be written, and an OPENQUERY command is utilized by the query.
C . To achieve the goal, a Remote Server connection to the application database should be configured.
D . To achieve the goal, a query should be written, and an OPENDATASOURCE command is utilized by the query.

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?() large pool。 streams pool。 keep buffer cache。 recycle buffer cache。 国家电网公司对风电场电压运行范围的规定是什么? Which is a valid CREATE TABLE statement? () CREATE TABLE EMP9$# AS (empid number(2));。 CREATE TABLE EMP*123 AS (empid number(2));。 CREATE TABLE PACKAGE AS (packid number(2));。 CREATE TABLE 1EMP_TEST AS (empid number(2))。 患者,男性,39岁。因车祸发生脾破裂,急诊入院。T36.4℃,BP70/50mmHg,P100/min,R24/min,患者口渴,烦躁不安,皮肤苍白,四肢湿冷。该患者的表现提示其处于() 休克代偿期。 休克早期。 休克失代偿期。 DIC。 多器官功能受损。 A customer needs to test the failover capabilities of their cluster. Which of the following AIX commands, whenissued from the command line, will simulate a node crash and cause the cluster resource group running onthat server to fail over to another node?() clstop。 halt -q。 shutdown -F。 stopsrc -s cluster。

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A vendor company’s application is utilized, and the application is based on a proprietary database. Data is queried from the application database and the data is imported into a SQL Server 2005 database. A new OLE DB driver is offered by the application vendor, and the new OLE DB driver will be utilized when the application database is queried. According the company requirements, the connections between the SQL Server database and the application database is prohibited, except when this data is queried. You should think out a method to have data queried from the application database. 
Which action should be performed to achieve the goal?()

参考答案:

  参考解析

本题暂无解析

在线 客服