You need to select appropriate processing methods for the Em

题目
单选题
You need to select appropriate processing methods for the EmployeeAssignment measure group and the Employee dimension. Which method should you choose?()
A

Run a Process Update against the Employee dimension. Run a Process Full against the EmployeeAssignment measure group.

B

Run a Process Full against the EmployeeAssignment measure group. Run a Process Update against the Employee dimension.

C

Run a Process Full against the Employee dimension. Run a Process Incremental against the EmployeeAssignment measure group.

D

Run a Process Incremental against the EmployeeAssignment measure group. Run a Process Full against the Employee dimension.

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

What is necessary for your query on an existing view to execute successfully? ()

A. The underlying tables must have data.

B. You need SELECT privileges on the view.

C. The underlying tables must be in the same schema.

D. You need SELECT privileges only on the underlying tables.


参考答案:B

第2题:

In order to improve the performance of a network server, you need to select bus or local bus. The appropriate local bus is(69).

A.VESA

B.ISA

C.EISA

D.PCI


正确答案:D
解析:译文:为了改善网络服务器的性能,需要选择总线或者本地总线。合适的本地总线是:PCI。

第3题:

●In order to improve the performance of a network server,you need to select bus or local bus.The appropriate local bus is (69) .

(69) A.VESA

B.ISA

C.EISA

D.PCI


正确答案:D
【解析】译文:为了改善网络服务器的性能,需要选择总线或者本地总线。合适的本地总线是:PCI。

第4题:

What is necessary for your query on an existing view to execute successfully?()

  • A、The underlying tables must have data.
  • B、You need SELECT privileges on the view.
  • C、The underlying tables must be in the same schema.
  • D、You need SELECT privileges only on the underlying tables.

正确答案:B

第5题:

You need to share a financial spreadsheet with other employees of your company. The material is of a sensitive nature and you want to prevent the ability of users to use offline caching. How do you do this?()

  • A、Assign Special Permissions.
  • B、Select Shared folder properties, caching, deselect “Allow Caching”.
  • C、Select Manual Caching for Documents.
  • D、Select Manual Caching for Programs.

正确答案:B

第6题:

You are the administrator of a SQL Server 2000 computer. You are creating a data transformation services package. As the first step in this process, you need to load data from text files into a database table. These text files contain data on new stores that join your franchise. The text files list the data columns in the following format StoreID, StoreName, Address, City, State, PostalCode, ManagerID, StoreTypeID, FacilityID.

The destination table is configured as shown in the exhibit.

You want to load the data into the table as quickly as possible. What should you do?

A.Use a Bulk Insert Task to read the data into a temporary table. Use an Execute SQL task to import the appropriate data into the destination table.

B.Create and edit a format file to select the columns you want to import. Use a Bulk Insert Task, and then specify the format file to import the appropriate data into the destination table.

C.Use a transform. data task to import the data. Use Microsoft ActiveX transformation scripts to write the appropriate data to the appropriate columns in the destination table.

D.Create and edit a format file to select the columns you want to import. Use a transform. data task, and then specify the format file to import the appropriate data into the destination table.


正确答案:B
解析:Explanation:TheBulkInsertTaskisthefastestmechanismforcopyinglargeamountsofdataintoaSQLServer2000tableorview.However,transformationscannotbeperformedonthedatawhileitismovedfromthesourcefiletothetableorview,asthiswouldslowdownthedatacopyprocess.ThusthetextfilemustbeformattedbeforetheBulkInsertTaskisused.TheformatfileprovidesthedefaultinformationusedeithertobulkcopythedatainthedatafileintoaninstanceofSQLServer2000ortobulkcopydataoutfromthetable.TheformatfilealsoprovidesawaytobulkcopydataselectivelyfromadatafiletoaninstanceofSQLServer.Thisallowsforthetransferofdatatoatablewhenthereisamismatchbetweenfieldsinthedatafileandcolumnsinthetable.Byusingaformatfile,itispossibletobulkcopydataintoaninstanceofSQLServerwithouthavingtoaddordeleteunnecessarydata,orreorderexistingdata,inthedatafile.IncorrectAnswers:A:TheBulkInsertTaskisthefastestmechanismforcopyinglargeamountsofdataintoaSQLServer2000tableorview.Itcanmakeuseofaformatfilethatallowsforthetransferofdatatoatablewhenthereisamismatchbetweenfieldsinthedatafileandcolumnsinthetable.Byusingaformatfile,itispossibletobulkcopydataintoaninstanceofSQLServerwithouthavingtoaddordeleteunnecessarydata,orreorderexistingdata,inthedatafile.Itthusmakestheneedtofirstimportthedataintoatemporarytableobsolete.C:TheTransform.Datataskisusedtocopydatabetweenasourceanddestinationandtooptionallyapplycolumn-leveltransformationstothedata.TheTransform.DatataskisthemostbasicimplementationofthedatapumpengineinDataTransformationServices(DTS)andisoptimizedforinsert-basedcopyingandtransformingofcolumn-leveldatabetweencommercialdatabases,spreadsheets,andtextfiles.However,theBulkInserttaskprovidesthebestperformanceforbulkinsertingtextfilesintoSQLServer2000,althoughitcannotbeusedtotransform.data.D:TheBulkInsertTaskisthefastestmechanismforcopyinglargeamountsofdataintoaSQLServer2000tableorview.Itcanmakeuseofaformatfilethatallowsforthetransferofdatatoatablewhenthereisamismatchbetweenfieldsinthedatafileandcolumnsinthetable.Byusingaformatfile,itispossibletobulkcopydataintoaninstanceofSQLServerwithouthavingtoaddordeleteunnecessarydata,orreorderexistingdata,inthedatafile.

第7题:

You are developing a Windows Presentation Foundation (WPF) application for a travel reservation systemYou need to ensure that users can select a range of travel dates.What should you do ?()

A. Add single DatePicker control to the design surface

B. Add single Calendar control to the design surface

C. Add single MediaElement control to the design surface to display a calendar

D. Add the appropriate Windows Forms references to the project references. Add a single Windows Forms DateTimePicker control to the design surface


参考答案:B

第8题:

You have recently created an application, and want to capture all debugging text messages generated by it.You would like these debugging messages to display on the command line. The application that you created contains the following code:Debug.WriteLine ("Start the processing");Console.WriteLine ("Generated by Console.WriteLine");Debug.WriteLine ("End the processing");You need to ensure that you are able to capture all debugging messages to the command line.What should you do?()

A.

B.

C.

D.


参考答案:C

第9题:

You are building a Front Controller using a JSP page and you need to determine if the user’s session hasNOT been created yet and perform some special processing for this case. Which scriptlet code snippet willperform this test?()

  • A、<% if ( request.getSession(false) == null ) {// special processing} %>
  • B、<% if ( request.getHttpSession(false) == null ) {// special processing} %>
  • C、<% if ( requestObject.getSession(false) == null ) { // special processing} %>
  • D、<% if ( requestObject.getHttpSession(false) == null ) { // special processing} %>

正确答案:A

第10题:

You are planning the configuration of SQL1.You need to use the most appropriate Windows account for the SQL Server service. Which account should you use?()

  • A、a domain user account
  • B、a local user account
  • C、the NETWORK SERVICE account
  • D、the LOCAL SYSTEM account

正确答案:A

更多相关问题