Exam 9: Organize, import, export, and Cleanse Data Sets

One popular way to integrate information from web pages is to use a Data Connection Wizard.

Data on web pages is not stored in an organized manner; therefore,________ was created to give structure to web page data.

Jerry used a function to convert the following date 1/31/2012.The function he used returned the number 31.Jerry likely used the ________ function.

All of the following statements are TRUE about the Text Import Wizard data EXCEPT:

To change the word apple with orange in a string of text,use the ________ function.

HTML describes the content of the data between tags.

________ is a markup language that was created to give structure to web page data so that it could be searched more efficiently.

Flash Fill recognizes patterns in data as you type and automatically fills in values for text and numeric data.

All of the following are advantages of a web query EXCEPT:

________ are markup indicators in an XML document used to identify the data.

A social security number is commonly used as a ________ key.

Two of the most common text file types that use delimiters are .csv and .txt.

In a tab-delimited file,________ separate the data.

An XML document uses ________ that include start tags,end tags and the data itself.

A(n)________ indicates the beginning and end of a text data segment.

By definition,a(n)________ database is a collection of tables linked together by shared fields.

Data ________ is a process that validates data so that it is accurate.

Text files have no metadata associated with them.

Text files can contain fonts,images,and hyperlinks.