Data Analysis EXAM 1

Which is an advantage of R? A. designed for general programming B. designed for data analytics C. prepares people for programming tasks besides data analysis D. integrates with website and mobile apps or a production database

B

Which is more incorrect about unstructured data? A. may have an internal structure B. fits a relational data model C. generated by humans D. created by machines

B

Which of the following is RStudio? A. a programming code B. a programming tool C. a non-programming tool for data analysis D. a programming language

B

Which of the following is an example of a non-programming tool for data analysis? A. Rodeo B. JMP C. Python D. RStudio

B

Big data are useless to a company unless ________. A. the company has a place to analyze and easily access the information B. the data supports assumptions the company has made before analyzing them C. the data are raw and unclean D. the company finds something meaningful in the data quicklyA

A

Cleaning data include dealing with data that are __________. A. incomplete, outliers, or inconsistent B. incomplete, outliers, or invaluable C. outliers, invaluable, or inconsistent D. incomplete, invaluable, or inconsistent

A

Suppose there are two tables: A and B. What would the following code output? SELECT * from A LEFT JOIN B on A.orderid + B.orderid; A. the complete set of records from table A, along with the matching records (depending on the availability) from table B where tables A and B have the same orderid B. only the records from table A where tables A and B have the same orderid C. the complete set of records from table B, along with the matching records (depending on the availability) from table A where tables A and B have the same orderid D. only the records from table B where tables A and B have the same orderid

A

Suppose there are two tables: A and B. What would the following code output? SELECT * from A RIGHT JOIN B on A.orderid = B.orderid; A. the complete set of records from table B, along with the matching records (depending on the availability) from table A where tables A and B have the same orderid B. only the records from table B where tables A and B have the same orderid C. the complete set of records from table A, along with the matching records (depending on the availability) from table B where tables A and B have the same orderid D. only the records from table A where tables A and B have the same orderid

A

What are the three steps of getting data ready? A. clean, structure, and integrate B. data, analytics, and visualization C. address outliers, complete missing data, and make the data consistent D. extract, transform, and load

A

What benefit(s) do non-relational databases have to a business analytics professional? A. all of these B. they assist in machine-to-machine data retrieval C. they are more affordable since many are open source D. they allow professionals to extract data from emails, documents, xml files, etc.

A

What does open-source mean? A. developed by and for the community and available for free B. developed by a proprietary firm C. developed by a single platform like the CRAN D. downloadable in the open internet universe

A

What is a primary key in a relational database? A. a column that uniquely identifies a row in the table B. either a column or a row that uniquely identifies a cell in the table C. both a column and a row that uniquely identify a cell in the table D. a row that uniquely identifies a column in the table

A

What is the role of a relational database? A. to store large amounts of data and create easy access to important information B. to store semi-structured data so that a business analytics professional can retrieve the data C. to manage and store big data

A

Which of the following is not a type of join? A. partial inner join B. full outer join C. left join D. inner join

A

What are the three legs of business analytics? A. data, analytics, and visualization B. address outliers, complete missing data, and make the data consistent C. extract, transform, and load D. clean, structure, and integrate

A.

What is a programming language? A. a software package that allows the execution of programming code B. a series of words for executing functions in RStudio C. a formal set of instructions that can be used to produce various kinds of output D. a syntax for speaking to a computer using R

C

What is an integer? A. a variable that contains numbers with or without decimal points B. a variable that contains numbers with decimal points C. a variable that contains numbers without decimal points D. a variable that contains no numbers

C

What is one function that a relational database can do that a non-relational database cannot? A. update information B. delete information C. join queries D. retrieve information

C

Which is least likely to be an objective of analysis? A. segmentation B. demand estimation C. qualitative reasoning B. market effectiveness

C

Which is not an Excel function important to business analytics? A. match B. vlookup C. mean D. quartile

C

Which of the following includes matched records from the right table and all records from the left table? A. right join B. inner join C. left join D. full join

C

Which of the following is used to restrict rows is SQL? A. SELECT B. GROUP BY C. WHERE D. FROM

C

Which is an advantage of Python? A. supported by a well-established programming tool, RStudio B. integrates well with programming activities outside data analytics C. has over 10,000 existing packages D. designed for data exploration

B

Which type of non-relational database is best for the data structure of social media networks? A. document database B. graph database C. object database D. columnar database

B

Suppose there are two tables: A and B. What would the following code output? SELECT * from A INNER JOIN B on A.orderid = B.orderid; A. the complete set of records from table A, along with the matching records (depending on the availability) from table B where tables A and B have the same orderid B. only the records from table A where tables A and B have the same orderid C. the complete set of records from table B, along with the matching records (depending on the availability) from table A where tables A and B have the same orderid D. only the records from table B where tables A and B have the same orderid

B

The Hadoop ecosystem encompasses Hadoop's various tools and projects, which were designed to promote __________. A. optimal reduction B. optimal usability C. optimal processing power D. optimal efficiency

B

What does a query do? A. calculates the solution to a complex combination of statistical functions B. allows you to ask a question and answer the said question through information pulled from the database C. stores information in a virtual "deep pit" for the purpose of future extraction D. all of these

B

Business analytics is ________. A. the use of business inputs to maximize business outcomes B. the study of the nature of business topics by examining its details C. the use of statistics to gain business insights D. the use of data to gain insights from data to maximize business outcomes

D

Hadoop is an open-source software framework that stores and processes large amounts of data using ________. A. asynchronous map-reduced algorithms B. synchronous map-reduced algorithms C. commodity cluster software D. commodity cluster hardware

D

What is a programming tool? A. a syntax for speaking to a computer using R B. a series of words for executing functions in RStudio C. a formal set of instructions that can be used to produce various kinds of output D. a software package that allows the execution of programming code

D

What is the function COUNT() used for? A. to return the number of SQL statements in query B. to return the number columns that match a specified criteria C. to return the number of tables in a database D. to return the number of rows that match a specified criteria

D

Which is least likely to be an example of unstructured data? A. tweets B. chat C. email D. spreadsheet

D

Which is most valuable and most difficult? A. diagnostic analytics B. descriptive analytics C. predictive analytics D. prescriptive analytics

D

Which join uses records that have matching values in both tables? A. left join B. right join C. full join D. inner join

D

Which of the following does a relational database not contain? A. tables B. indices C. queries D. ID graphs

D

Which of the following is a top business priority that business analytics supports? A. increase digital cycles B. enrich the arch of augmented reality C. decrease creative destruction D. highlight technology opportunities for growth

D

Which of the following is not a programming language important for business analytics? A. Python B. R C. SQL D. RStudio

D

In which of the following competing implementations of Structured Query Language can be data be stored before it is structured? A. all of these B. Microsoft SQL server C. MySQL D. Oracle E. none of these

E

Which type of non-relational database is best for the simplest data modeling? A. document database B. object database C. columnar database D. graph database E. key-value stores

E

Which of the following is a/are non-commercial open-source database management system(s)? A. none of these B. MS SQL Server and Oracle C. MS SQL Server D. Oracle only E. MS SQL Server and MongoDB F. MongoDB only

F