SSIS Quiz

Question 1
Which is NOT a method that you can use to configure package configurations in SSIS packages? A :SQL Server Table
B :HKEY_LOCAL_MACHINE hive in the windows Registry
C :XML file
D :Environment variable

---

Question 2
You are using SSIS to import a plain text file to SQL Server. You have found that some text files do not have a standard format. For example, the last field orderdate does not exist for some records. What is the best method you should use to import this file to SQL Server? A :You cannot use SSIS to import non-standard text files
B :Use a flat file connection and assign text file for the connection and get the data
C :Use a flat file connection and Transformation option of the script component. The use some code get the orderdate
D :Use fuzzy grouping and a flat file connection to get order date

---

Question 3
What is the language you should use when you are using a script component? A :VB.Net
B :C#
C :VB6
D :VB.Net & C#

---

Question 4
What is the measure you need to use to measure similarity between a set of values in a Fuzzy Lookup? A :_Similarity
B :_Confidence
C :_Similarity_
D :FuzzyComparionFlags

---

Question 5
What is the connection manager you should use to import an Excel 2007 file into SQL Server using SSIS? A :Excel Connection Manager with Excel version 2007
B :Microsoft Jet 2007 OLE DB Provider
C :icrosoft Office 12.0 Access Database Engine OLE DB Provider with Extended property set to Excel 12.0
D :File Connection Manager

---

Question 6
Which is the slowly changing dimension method that you can't us in a data flow task in SSIS? A :Type 1 dimensions
B :Type 2 dimensions
C :Type 3 dimensions
D :Inferred dimensions

---

Question 7
What is the data flow transformation that needs a sorted data stream? A :Aggregate
B :Merge Join
C :Condition Split
D :All need Sorted data streams

---

Question 8
What is a Checkpoint Restart? A :Checkpoint information are saved in a file
B :Checkpoint allows a package to restart without returning tasks that already successfully completed
C :Any loop containers are started over from the beginning of the current loop
D :Data flow tasks and Control flow define restart points

---

Question 9
How you can send HTML email messages from SSIS? A :Using the Send Mail control task
B :Using a script control task
C :Using Database Mail
D :You cannot send HTML mails from SSIS

---

Question 10
How can you set the value 2007-08-21 02:00 AM in a SSIS variable? A :Define a datetime variable and assign the above value
B :Define a date and time variables and add them together
C :Define the date time variable and pass it to a script component and add time component
D :You cannot set the above value from SSIS

---