当前位置:MCTS(70-452)题库

问题:

[单选] You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Integration Services (SSIS) package to perform an extract, transform, and load (ETL) process to load data to a DimCustomer dimension table that contains 1 million rows. Your data flow uses the following components: A SQL Destination data flow task to insert new customers An OLE DB Command transform that updates existing customers On average, 25 percent of existing customer records is updated each night. You need to reduce the amount of time required to update customer records. What should you do?()

A .  Modify the UPDATE statement in the OLE DB Command transform to use the PAGLOCK table hint. 
B .  Modify the UPDATE statement in the OLE DB Command transform to use the TABLOCK table hint. 
C .  Stage the data in the data flow. Replace the OLE DB Command transform in the data flow with an Execute SQL task in the control flow.
D .  Stage the data in the data flow. Replace the UPDATE statement in the OLE DB Command transform with a DELETE statement followed by an INSERT statement.

Your company has a single active directory forest that has an active directory domain named na.contoso.com zone. you have enabled DNS scavenging on Server1. Three weeks later, you notice that the stale resource records remain in na.contoso.com. You need to ensure that the stale resource records are removed from na.contoso.com. What should you do? ()  Stop and restart the DNS service on Server1.。  Enable DNS scavenging on the na.contoso.com zone.。  Run the dnscmd Server1 /AgeAllRecords command on Server1.。  Run the dnscmd Server1 /StartScavenging command on Server1.。 同性恋 Your network consists of a single Active Directory domain. All domain controllers run Windows Server  2008 R2.   You need to plan an auditing strategy that meets the following requirements: èAudits all changes to Active Directory Domain Services (AD?DS) èStores all auditing data in a central location. What should you include in your plan?() Configure an audit policy for the domain. Configure Event Forwarding.。 Configure an audit policy for the domain controllers. Configure Data Collector Sets.。 Implement Windows Server Resource Manager (WSRM) in managing mode.。 Implement Windows Server Resource Manager (WSRM) in accounting mode.。 下列因素中,影响盈亏平衡点产量的因素是()。 员工数量。 所得税。 设计生产能力。 产品价格。 王某通过房屋抵押向甲银行贷款购买了一套价值100万元的房屋,王某自付30万元,贷款70万元。一年后王某偿还贷款20万元。那么,此时银行对房屋的保险利益额度是() 50万元。 80万元。 70万元。 100万元。 You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Integration Services (SSIS) package to perform an extract, transform, and load (ETL) process to load data to a DimCustomer dimension table that contains 1 million rows. Your data flow uses the following components: A SQL Destination data flow task to insert new customers An OLE DB Command transform that updates existing customers On average, 25 percent of existing customer records is updated each night. You need to reduce the amount of time required to update customer records. What should you do?()
参考答案:

  参考解析

本题暂无解析

在线 客服