0

technology Online Quiz - 1841

Description: technology Online Quiz - 1841
Number of Questions: 20
Created by:
Tags: technology
Attempted 0/20 Correct 0 Score 0

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

  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


Correct Option: C

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

  1. Type 1 dimensions

  2. Type 2 dimensions

  3. Type 3 dimensions

  4. Inferred dimensions


Correct Option: C

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

  1. Aggregate

  2. Merge Join

  3. Condition Split

  4. All need Sorted data streams


Correct Option: B

What is a Checkpoint Restart?

  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


Correct Option: D

How you can send HTML email messages from SSIS?

  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


Correct Option: B

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

  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


Correct Option: C

Which is NOT a method that you can use to configure package configurations in SSIS packages?

  1. SQL Server Table

  2. HKEY_LOCAL_MACHINE hive in the windows Registry

  3. XML file

  4. Environment variable


Correct Option: B

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?

  1. You cannot use SSIS to import non-standard text files

  2. Use a flat file connection and assign text file for the connection and get the data

  3. Use a flat file connection and Transformation option of the script component. The use some code get the orderdate

  4. Use fuzzy grouping and a flat file connection to get order date


Correct Option: C

How many tabs are there in Test Settings (File->Settings) window?

  1. 7

  2. 6

  3. 5

  4. 8


Correct Option: A

AI Explanation

To determine the number of tabs in the Test Settings window, we can refer to the File->Settings menu.

Option A) 7 - This option is correct. The Test Settings window typically contains 7 tabs.

Option B) 6 - This option is incorrect. There are more than 6 tabs in the Test Settings window.

Option C) 5 - This option is incorrect. There are more than 5 tabs in the Test Settings window.

Option D) 8 - This option is incorrect. There are fewer than 8 tabs in the Test Settings window.

Therefore, the correct answer is A) 7, as it accurately represents the number of tabs in the Test Settings window.

  1. Properties, Run, Resources, Parameters, Environment, Web, Recovery

  2. Properties, Run, Resources, Parameters, Environment, Web

  3. Properties, Run Options, Resources, Parameters, Environment, Web,

  4. Properties, Run, Resources, Input Parameters, Environment, Web, Recovery


Correct Option: A

The following are the four main columns in the Keyword view

  1. Item, Operation, Value, Comments

  2. Item, Operation, Value, Documentation

  3. Item, Operation, Property, Documentation

  4. Number, Operation, Value, Documentation


Correct Option: B

AI Explanation

To answer this question, we need to understand the structure and purpose of the Keyword view in a software testing tool.

The Keyword view is a component of a software testing tool that allows testers to create and manage test cases using a visual interface. It consists of columns that represent different aspects of a test case.

Let's go through each option to understand why it is correct or incorrect:

Option A) Item, Operation, Value, Comments - This option is incorrect because it includes the column "Comments" instead of "Documentation".

Option B) Item, Operation, Value, Documentation - This option is correct because it accurately represents the four main columns in the Keyword view.

Option C) Item, Operation, Property, Documentation - This option is incorrect because it includes the column "Property" instead of "Value".

Option D) Number, Operation, Value, Documentation - This option is incorrect because it includes the column "Number" which is not a standard column in the Keyword view.

The correct answer is B) Item, Operation, Value, Documentation. This option is correct because it accurately represents the four main columns in the Keyword view.

RFID stands for...

  1. Radio Frequency Identifier

  2. Radio Frequency Identity Device

  3. Radio Frequency Infrared Device

  4. Radio Frequency Identification


Correct Option: D

Capability of simultaneous reading of multiple tags is called

  1. agility

  2. anti-collision

  3. multi path

  4. polarizations


Correct Option: B

High Frequency (HF) RFID tags use

  1. 125 kHz

  2. 915 MHz

  3. 2.54 GHz

  4. 13.56 MHz


Correct Option: D

Which of the following has no effect on the read-range?

  1. ambient RF noise

  2. transmitted power from the reader

  3. tag memory

  4. tag antenna size


Correct Option: C

when was the First Email sent?

  1. 1985

  2. 1990

  3. 1971

  4. 1975


Correct Option: C

AI Explanation

To answer this question, we need to understand the history of email. Let's go through each option to understand why it is correct or incorrect:

Option A) 1985 - This option is incorrect because email was actually sent before 1985. Option B) 1990 - This option is incorrect because email was sent before 1990. Option C) 1971 - This option is correct because the first email was sent in 1971. Ray Tomlinson, an American computer programmer, is credited with sending the first email while working on the ARPANET (Advanced Research Projects Agency Network) system. Option D) 1975 - This option is incorrect because email was sent before 1975.

The correct answer is C. The first email was sent in 1971.

What two kinds of servers handle incoming e-mail messages?

  1. POP3 and IMAP servers

  2. Web and FTP servers

  3. POP3 and FTP servers

  4. FTP servers and IMAP


Correct Option: A

AI Explanation

To answer this question, you need to understand the different protocols used for handling incoming email messages.

Option A) POP3 and IMAP servers - This option is correct because both POP3 (Post Office Protocol version 3) and IMAP (Internet Message Access Protocol) servers are used to handle incoming email messages. POP3 servers store emails on the server until they are downloaded to the client device, while IMAP servers store emails on the server and allow the client device to access and manage the emails remotely.

Option B) Web and FTP servers - This option is incorrect because web servers and FTP (File Transfer Protocol) servers are not directly involved in handling incoming email messages. Web servers are used to host websites, while FTP servers are used for file transfers.

Option C) POP3 and FTP servers - This option is incorrect because while POP3 servers are used to handle incoming email messages, FTP servers are not directly involved in email handling. FTP servers are used for file transfers.

Option D) FTP servers and IMAP - This option is incorrect because while IMAP servers are used to handle incoming email messages, FTP servers are not directly involved in email handling. FTP servers are used for file transfers.

Therefore, the correct answer is A) POP3 and IMAP servers.

To which port does the SMTP server listen in order to accept incoming messages?

  1. Port 15

  2. Port 115

  3. Port 110

  4. Port 25


Correct Option: D
- Hide questions