Data Management Foundation Part 5

How is healthcare changing since the introduction of big data, if at all?

It has improved, since more information would provide additional support for any conclusion.

Which BEST describes the state of analysis of big data?

It is a rough idea, but getting better every day.

Which of the following is NOT true of a data warehouse?

It is one large database that is stored in a large building.

Which of the following BEST describes business analytics?

It's the practice of systematic exploration of an organization's data with emphasis on statistical analysis.

Which of the following programming languages makes a website more interactive and dynamic?

JavaScript

Which of the following is NOT an example of an application of big data in education?

Making sure that students are kind to one another

Which of these is an ideal use of a relational database?

Managing inventory, prices, and production

Which of the following is NOT usually done with a web application?

Mathematics

MapQuest is an example of what category of web application?

Navigation

What tools does big data use?

None of these answers are correct.

The data in a flat file database have no _____ between them.

Relationships

Which of these satisfies 'volume'?

Social media data for a whole country

Data warehouses _____

Store historical information from operational databases

The key to data quality is:

Stringent users, organizational discipline and data validation routines

When designing a data mart, which of the following tools will help end users get their data faster?

Summarized tables

Asking if one will shop at a store again after their experience is a type of question often found on what?

Surveys

Choose the correct set of words to fill in the blanks: _____ are used to describe _____ for displaying text, graphics, and user inputs in an HTML document.

Tags; instructions

What best sums up veracity?

That information is reliable

Which of the following is true about an XML file?

The XML file is included within an HTML file

What is the reason why web applications have a significant effect on BIS?

The large number of people worldwide with Internet access.

The following information was sent to Gladys Fashion House(GFH). Which of the following knowledge workers would be dissatisfied with the information? Sales period: Jan-April 2016 Demography: Unavailable Item: Denim Jacket Gender: All Sales: $430,334

The sales representative

Which one is not a form of collecting data?

These are all forms of collecting data.

Why might a marketer perform descriptive analytics?

To analyze raw data and find trends

What is the purpose of data analysis?

To draw a conclusion

If you owned a business, how might you use data mining?

To find patterns in large amounts of data

What is the purpose of data mining?

To help find new patterns and relationships

While both spreadsheet and database software can be used to organize and manipulate data, when would you benefit most from using database software?

You need a rigorous structure to organize your data effectively

In the following XML file what are the elements? <?xml version='1.0'?> <shoes> <color>black</color> <brand>nike</brand> <price>$49.99</price> </shoes>

color, brand, price

A data mart should have the same _____ as the data warehouse.

database schema

Approximately how many potential web application users are there on the planet as of 2020?

4.6 Billion

What is a computer server?

A centralized computer system which provides services over a network

What is data warehouse?

A centralized information repository that gathers data from many sources.

Which of these could use a hierarchical database most efficiently?

A group of students organized by homeroom

Which of the following does a relational database most resemble?

A spider web

Which of these would especially suit a flat file database?

A spreadsheet

Which of these do you expect big data to NOT have a large impact on?

A used bookseller

Which of the following is NOT an example of current spreadsheet software?

Access

Which of the following is an example of database software?

Access

Big Data can be used by business to do what?

All answers are correct

Flat-file databases can become _____.

All are correct

Which of the following is part of business intelligence (BI)?

All of the answers are correct

Which of the following are characteristics of web applications?

All of the answers are correct.

For which of the following actions is useful information generated?

All of these answers are correct.

What tools does a data warehouse use?

All of these answers are correct.

What is/are the challenge(s) of big data?

All of these are a challenge

Which of the following is a current or future impact of big data on healthcare?

All of these are correct.

Which of these do you expect to have made use of big data?

All of these choices use big data.

How many tables are in a relational database?

As many as are needed

How many tables are in a given hierarchical database?

As many as you need

Which of the following is a difference between big data and data warehouses?

Big data has a larger scope.

Which of these is NOT true for business and big data?

Big data replaces executives

Which of the following is/are true? I. XML is a markup language used to display data over the internet. II. HTML is a markup language used for storing and structuring of web data in the database.

Both I and II are false.

_____ is a variety of software applications used to analyze an organization's raw data.

Business intelligence

Gia is designing a website for her floral business and wants to incorporate the same color scheme, background, and styles throughout the site. Which language BEST suits Gia's particular web design needs?

CSS

Which of these is an example of data that does NOT demonstrate velocity?

Census data from 1980

Which of the following is NOT a step in the business intelligence (BI) software process?

Change your pricing strategy to increase profits

What is an advantage of big data?

Conclusions that could be missed in smaller data sets are found

You are tasked with creating a data mart of sales data. The mart will be used by upper level leadership. They will use pivot tables in Excel. Which of the following describes the most efficient way to create a data mart from the Sales dimension of the data warehouse?

Copy key tables, create summary tables, restrict access, translate field names

What is the primary advantage of using a distributed database?

Data access and processing are much faster.

_____ is a method in which data is collected and organized so that one can look at what the data is trying to tell us.

Data analysis

Examining raw data in order to draw a conclusion is known as which of the following?

Data analytics

Which of the following statements is false with respect to distributed databases?

Data at any site are only available to users at those sites.

Big data is defined as:

Data that is so large traditional methods for analyzing are not possible.

Which is the correct order for developing and delivering a data mart?

Design, build, populate, access, manage

Which of the following BEST describes the use of referencing in spreadsheet software?

Determining the value of a cell by using the values of other cells

What type of information is generally referred to as big data?

Digital data

Which one is a tool of data analytics?

Excel

Which of these is most like a hierarchical database?

Family tree

Which is a benefit to a data mart?

Faster response time

_____ is an example of a flat-file database tool.

FileMaker

I have a flat-file table with seven records for a customer. Her name changes. How do I update the data?

Fix each record

What style of database is in a smartphone's contact book?

Flat file

The concept of Big Data helps in

Gathering large data and analyzing it.

Which programming language was developed in 1993 and became the standard for the Internet?

HTML

PHP stands for _____.

Hypertext Preprocessor

Even though tables aren't related in a flat-file database, they should have a(n) _____.

Index

Quality data comprises _____.

Integrity, consistency, and completeness

Which of the following about HTML5 is TRUE?

It allows for video elements

Lynne is analyzing data for a large airline. She wants to create buzz on social media and then analyze the results. What system could she use and why?

NodeXL because it allows data mining of keywords in social media

The data format for a children's item code is A###-#### where A represents any letter, # represents any number from 1-9, and - is used as a character separator. Which of the following inputs would be accepted by the data validation tools of the system?

O998-5967

Watching something or someone is a form of what method of data collection?

Observations

Which of these social media networks demonstrates the greatest variety of data?

One without a particular focus

Which of these analytics tools is basically a housecleaner, grouping similar entries together so that capitalization, spelling, and spaces can be checked and the data made ready for analysis?

OpenRefine

When a web browser requests a particular web page that is stored on a database server (say, MySQL), the database sends the web content to _____.

PHP script

What is the basic relationship in a hierarchical database?

Parent-child

Which building most resembles a typical hierarchical database?

Pyramid

Which of the following is used in database software to answer basic questions about your data?

Queries

Which of the following is true about an XSD file?

The XSD file describes the names of the elements for the XML file

What is the relation between an XML file and an XSD file?

The XSD file is the template for the XML file

What is big data?

The area of science and technology that deals with information sets that are too large to be handled by traditional means.

What is big data?

The area of science and technology that deals with large data sets.

Given the following XML schema file, which of the following is true? <xs:sequence> <xs:element name="chickenOrfish" type="xs:string"/> <xs:element name="bakedOrbroiled" type="xs:string'/> <xs:element name="weight" type="xs:decimal"/> </xs:sequence>

The bakedOrbroiled is the second element in the xml file

Which of these is NOT one of the four Vs?

Voice

Three factors in big data are:

Volume, Variety, and Velocity

Which of the following is a possible positive result of the implementation of big data in the field of healthcare?

Wearable technology will better enable better long term health monitoring

What is something that big data CANNOT do when it comes to a new TV program?

Write realistic dialog

Which of the following falls under the Prolog section of XML?

XML declaration

Some groups track human behavior using big data from what?

mobile phones

PHP is a/an _____ that is understood by the web databases.

server-side script

Which of the following qualifies as 'big data'?

social media