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
