technology Online Quiz - 1841

To import Excel 2007 (.xlsx) files in SSIS, you must use the Microsoft Office 12.0 Access Database Engine OLE DB Provider with the Extended Properties set to 'Excel 12.0' because the older Jet provider only supports up to Excel 2003.

The SSIS Slowly Changing Dimension wizard natively supports Type 1 (overwrite) and Type 2 (add historical rows). Type 3 dimensions require custom implementation using OLE DB Command or script components because they're not directly supported.

Merge Join transformation requires both input data streams to be sorted on the join key columns. Other transformations like Aggregate and Conditional Split work correctly with unsorted data.

Checkpoint restart in SSIS uses a checkpoint file to save execution state. The package can restart from the point of failure without re-executing completed tasks - both control flow and data flow tasks define these restart boundaries.

The Send Mail Task in SSIS only supports plain text emails. To send HTML-formatted emails, you must use a Script Task with .NET code to access System.Net.Mail and set IsBodyHtml=true.

In SQL Server Integration Services (SSIS), variable data types include DateTime, which can directly accept standard date and time string formats like 2007-08-21 02:00 AM.

SSIS package configurations can be stored in SQL Server tables, XML files, environment variables, and parent package variables. The Windows Registry (specifically HKEY_LOCAL_MACHINE hive) is not a supported configuration method for SSIS packages. While you can use registry entries indirectly through custom code, it's not a native configuration source like the other options listed.

When importing text files with non-standard or missing fields in SSIS, the Script Component transformation provides the most flexibility. You can write custom code to handle variable column counts, conditional logic for missing fields like orderdate, and data validation. Standard flat file connections require consistent structure, and fuzzy grouping is designed for data matching, not handling missing columns.

In QTP/UFT (QuickTest Professional), the Web tab in Test Settings contains browser-specific configurations including the browser navigation timeout setting. Properties handles general test settings, Resources manages associated files and libraries, while Web Settings is not a standard tab name.

In standard versions of HP QTP, the Test Settings dialog (File -> Settings) contains exactly 7 tabs: Properties, Run, Active Screen, Resources, Parameters, Web, and Recovery.

The Test Settings window in QTP/UFT contains tabs for Properties, Run, Resources, Parameters, Environment, Web, and Recovery - all are standard configuration categories. Options B and C are missing tabs, while D incorrectly renames Parameters to Input Parameters.

In HP QuickTest Professional (QTP) / Unified Functional Testing (UFT), the 'Generate Script' option is located under the 'Properties' tab of the Test Settings dialog.

Keyword View in QTP/UFT has four columns: Item (test object), Operation (action/method), Value (parameters or arguments), and Documentation (description). This structure provides a readable, tabular representation of test steps compared to Expert View code.

RFID expands to Radio Frequency Identification - it's a technology that uses radio waves to identify and track tags attached to objects. The other options incorrectly substitute terms (Identifier, Identity Device, Infrared Device) that don't match the standard expansion.

Anti-collision is the technique that allows RFID readers to simultaneously read multiple tags. It prevents signal interference when multiple tags respond at once, enabling batch reading. The other terms (agility, multipath, polarizations) relate to RF communications but aren't the correct term for this capability.

High Frequency (HF) RFID operates at 13.56 MHz, which is the international standard for HF RFID systems (ISO/IEC 14443, ISO/IEC 15693). Low Frequency (LF) uses 125 kHz, Ultra High Frequency (UHF) uses 915 MHz, and microwave uses 2.54 GHz.

The read-range of an RFID system depends on transmitted power, antenna size (tag and reader), and environmental factors like RF noise. Tag memory is purely a storage capacity feature - it doesn't affect how far the tag can be read from. The other factors directly influence signal strength and detection range.

Ray Tomlinson sent the first networked email in 1971 on ARPANET, the precursor to the modern Internet. He also pioneered the use of the '@' symbol to separate the user from the host computer.

POP3 and IMAP are the standard protocols for retrieving incoming email from a mail server. POP3 typically downloads and stores messages locally, while IMAP keeps them on the server and syncs across devices. SMTP handles the sending of outgoing messages, not incoming retrieval.

SMTP servers listen on port 25 by default to accept incoming email messages for transmission. Port 110 is used by POP3 for retrieving email, while port 115 is for FTP (File Transfer Protocol) and unrelated to email.