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

问题:

[单选] You need to cleanse and standardize the data on potential survey participants prior to inserting it into the staging database. What should you do?()

A . Import the data into a staging table by using the OPENROWSET BULK statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.
B . Import the data into a staging table by using the BULK INSERT statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.
C . Create a SQL Server Integration Services (SSIS) package to import, standardize, and cleanse the data.
D . Create a CLR stored procedure to import the data into a staging table, to cleanse and standardize the data, and to insert the data into the database.

Your company has two SQL Server 2005 computers named SQL1 and SQL2. A user in your company named Eric writes many ad hoc queries against the company databases. Eric has access to the Customer database on SQL1. He does not have access to the Sales database on SQL2. You need to ensure that Eric can write queries that join information from both servers. What should you do first?() Create a linked server on SQL1 to SQL2. Configure the linked server to use impersonation. 。 Create a linked server on SQL1 to SQL2. Configure the linked server to use mapped logins. 。 Instruct Eric to write the queries on SQL2 by using the OPENQUERY statement and specifying SQL1 as the server name. 。 Instruct Eric to specify SQL Server object names by using four-part notation.&e。 组织开展《教师专业标准》专题学习活动可以采取()等多种形式。 An administrator is notified that a resource group has failed over from the home node, Node1 to a standbynode, Node2 and that Node1 has been powered off. Upon restarting Node1 the administrator checks the AIXerror log and the cluster.log Which of the following is the most likely cause of the failure of Node1?() The operating system crashed。 A disk failure forced a volume group off line。 The System Resource Controller executed a system halt。 The topology services daemon has crashed due to an ODM mismatch。 中华人民共和国药典》收载的处方属于() 法定处方。 医师处方。 协定处方。 急诊所方。 普通处方。 You need to ensure that the company’s standard password policy is enforced for all logins that areused to access SQL Server 2005.Which two actions should you perform?() Set the appropriate local password policies for all computers on which SQL Server is installed.。 Set the server authentication mode of all SQL Server instances to Windows Authentication mode.。 Install all instances of SQL Server 2005 on computers that run Windows Server 2003 or later.。 Create SQL Server logins that have CHECK_POLICY enabled.。 You need to cleanse and standardize the data on potential survey participants prior to inserting it into the staging database. What should you do?()
参考答案:

  参考解析

本题暂无解析

在线 客服