Tag: technology

Questions Related to technology

The output of the hashing algorithm is called the hash synonyms
technology databases

  1. True

  2. False

Show answer
Correct Option: B

What is the language you should use when you are using a script component?

technology

  1. VB.Net

  2. C#

  3. VB6

  4. VB.Net & C#

Show answer
Correct Option: A

What is the measure you need to use to measure similarity between a set of values in a Fuzzy Lookup?

technology

  1. _Similarity

  2. _Confidence

  3. Similarity

  4. FuzzyComparionFlags

Show answer
Correct Option: A

What is the connection manager you should use to import an Excel 2007 file into SQL Server using SSIS?
technology

  1. Excel Connection Manager with Excel version 2007

  2. Microsoft Jet 2007 OLE DB Provider

  3. Microsoft Office 12.0 Access Database Engine OLE DB Provider with Extended property set to Excel 12.0

  4. File Connection Manager

Show answer
Correct Option: C

Which is the slowly changing dimension method that you can't us in a data flow task in SSIS?
technology

  1. Type 1 dimensions

  2. Type 2 dimensions

  3. Type 3 dimensions

  4. Inferred dimensions

Show answer
Correct Option: C

What is the data flow transformation that needs a sorted data stream?
technology

  1. Aggregate

  2. Merge Join

  3. Condition Split

  4. All need Sorted data streams

Show answer
Correct Option: B

What is a Checkpoint Restart?
technology

  1. Checkpoint information are saved in a file

  2. Checkpoint allows a package to restart without returning tasks that already successfully completed

  3. Any loop containers are started over from the beginning of the current loop

  4. Data flow tasks and Control flow define restart points

Show answer
Correct Option: D

How you can send HTML email messages from SSIS?
technology

  1. Using the Send Mail control task

  2. Using a script control task

  3. Using Database Mail

  4. You cannot send HTML mails from SSIS

Show answer
Correct Option: B

How can you set the value 2007-08-21 02:00 AM in a SSIS variable?
technology

  1. Define a datetime variable and assign the above value

  2. Define a date and time variables and add them together

  3. Define the date time variable and pass it to a script component and add time component

  4. You cannot set the above value from SSIS

Show answer
Correct Option: C

MAX. NO OF ROWS PER PAGE?
technology databases

  1. 127

  2. 136

  3. 100

  4. 38

Show answer
Correct Option: A