ITM 209 Quiz Answers

What does this situation describe: "Four data sets with nearly identical descriptive statistics (slope, average, median, etc.) yet have very different distributions and appear very different when graphed"

Anscombe's Quartet

which wildcard would you use that allows you to select all the rows in a selected table?

*

Kevin wants to as "Halloween" into the title of his holiday column. Select all the proper ways for him to add the title to the holiday column in his select statement

-Events.holiday as "Halloween"

How many rows will you return in the following statement of code: select count(consultants.ID) from teleworks.consultants;

1

What is the order of commands in a SQL query?

1. Select 2. table.column 3. from 4. schema.table 5. where 6. condition (x>10) 1. select 2. from 3. inner join 4. where 5. group by 6. having 7. order by 8. ;

What types of join would you want to use to find all the information that comes from one table and the matched records from the other table?

1. left join 2. right join 3. full outer join

In what relationship does the primary key in one table become a foreign key in an existing table?

1:n

Zara is ready to buy a house, so she decides to hire a real estate agent from East Lansing Realty. Each real estate agent works with several customers and the agent receives a commission on the sale of each house. However, East Lansing Realty has a policy that each customer can be assigned to no more than one real estate agent. This is an example of what type of relationship between customer and agent?

1:n

What describes what Trend Lines are?

A feature in Tableau to show a line that represents the relationships between a set of data points that have been plotted (i.e. regression)

Jim is creating a visualization in Tableau. What would the chart look like if he: -Drags state (which is designated as a location field) to detail -Drags order number to color -Sets the calculation type (measure) set to order number to count distinct (CNTD)

A geographic map using a gradient color scheme to shade states based upon the number of orders for each state

You created a scatterplot in Tableau that contains plotted data points showing the number of class periods attended for a course vs. the grade assigned for students. You are trying to see if there is a positive relationship between the two. Which feature / function will best aid you in this?

Adding trend lines to the scatter plot

Which of the following features in Tableau is NOT found in the "marks" shelf? Color Label Columns Detail Tooltip

Columns

When loading data into Tableau, which of the following types of data usually appears under Measures?

Continuous

Jeff was asked to setup a visualization summarizing data on the amount of time it takes for a house to be built. He has a dataset that contains information on houses that have been constructed by his organization, which includes the date they broke ground to start construction (field constructionStartDate) and the date they finalized work (constructionEndDate). Doing some research, he found that Tableau uses TODAY() to represent the current date. Which of the following calculated fields in Tableau would identify the number of days it took to construct each house?

DATEDIFF('day',[constructionStartDate],[constructionEndDate])

Collecting information from many sources and storing them together into a single location is referred to as:

Data aggregation

Joe has a document that contains all of the metadata about the data elements in a database. This would be an example of...

Data dictionary

Data was previously stored in a flat format. What was one disadvantage to flat databases?

Data redundancy

What type of business analytic is attached to: Did we make a profit last year?

Descriptive

What type of analytics are used when creating a bar chart showing the top selling real estate agents in the state and the amount of sales they had in the past month?

Descriptive analytics

What is discrete data?

Discrete data can only take particular values. (Examples include number of apples or hair color)

What keyword when used in SQL select statement will remove duplicate records from the results?

Distinct

When building a dashboard, which of the following would you consider when laying out your visualizations?

F Pattern

T/F: A colon (:) punctuation mark is used to signify the end of a query

False

T/F: A diverging color scheme would be one that shades of a single color diverge

False

T/F: Discrete data can take on any value within a range

False

T/F: To create a map in Tableau, you must drag latitude and longitude to "columns" and "rows"

False

Which area of code allows you to make a condition that uses aggregate function?

HAVING

You received a visualization from a colleague that contains a white grid on a black background. At the intersections of the white grid, grey blobs appear as an optical illusion. However they disappear when you focus on the intersection. This is an example of what?

Hermann Effect

What decreases when using a relational database?

Information redundancy

What visualization is best for showing data changes over time?

Line chart

Eric created a visualization with a lot of parallel bars, each of the same color. A pattern in the bars emerges making the visualization hard to see due to visual noise created by the effect of the bars. What principle describes this scenario?

Moire Effect

What is the picture superiority effect?

Pictures (visualizations) are retained at much higher rates than words

What type of business analytic is attached to: What will our sales be next quarter?

Predictive

"Creating an analysis of office supply expenses by month for the prior year to identify what costs may be for each month in the upcoming year" is an example of:

Predictive analytics

What type of business analytic is attached to: Should we make or buy an expensive part of our machines?

Prescriptive

You are creating a line graph showing the number of students that have graduated from MSU over time. You want the line to show a running total of the number of students. Which Tableau feature would make this task easy?

Quick table calculation

Tree maps and heat maps use which of the following to show proportional size of values?

Size and color

What describes a scenario in which a concatenated key would be utilized?

Tables where only a combination of two attributes combined can make a unique identifier for roes (tuples) in a table

What is the WHERE clause in a SQL statement for?

To select only those rows in the result relation of the from clause that satisfy a specified predicate

Which of the following would you use to show information when you hover your mouse over a datapoint in a Tableau visualization?

Tooltip

What chart type would be the best to show the hierarchical nature of data (i.e. how sub-components build up to their parent components)

Tree map

T/F: One example of continuous data is height

True

T/F: Text in a novel is an example of unstructured data

True

T/F: The select clause of the statement is used to list the attributes desired in the result of a query

True

T/F: When you write a string in a piece of SQL code to label your column heading, you will always need to use apostrophe (' ') or quotation (" ") around it

True

What word describes the speed of data?

Velocity

If an individual would like to place a non-aggregate condition (such as country = 'US') in code that only results rows that fit certain criteria, which area would the code be placed?

WHERE

What situation would be best performed using bar chart in Tableau?

When comparing data across categories

When would you utilize the LIKE operator in a SQL query?

When you are trying to match/filter for a pattern using wildcards

Which wildcard allows you to look for a single character in a range?

[ ]

What SQL command allows you to rename your column heading?

as

If the following join statement is used to join two tables in a query, which of the following tables would all of the tuples in the relation appear in results? full outer join schema.customers on invoice.customerID = customers.customerID

both customers and invoices

Which aggregation function shows the number of records that meet a set of criteria?

count

If the following join statement is used to join two tables in a query, which of the following tables would all of the tuples in the relation appear in results? right outer join schema.customers on invoices.customerID = customers.customerID

customers

The three factors of the variety of data are:

form, function, source

If the following join statement is used to join two tables in a query, which of the following tables would all of the tuples in the relation appear in results? left outer join schema.customers on invoices.customerID = customers.customerID

invoices

In a family, there are 4 individuals and each individual is able to drive any of the family's 3 cars. What type of relationship is present between people and cars?

n:m

Jeff is creating a database to track TV shows and actors. Actors can be in multiple shows and shows can have multiple actors. Which type of relationship and what number of tables are needed to implement this in a relational database?

n:m & 3 tables

Emily is working with a large data set in SQL. As she completes a query, she notices several redundant rows returned. If you are a coworker of Emily's, what SQL function could you suggest to Emily to reduce duplicates from her query results to only return unique rows of data?

select distinct

The three basic clauses of a SQL statement to select data are:

select, from, where

Most important visualizations go where in a dashboard?

top left corner

When is HAVING used instead of WHERE?

when groups are present through the use of an aggregate function (such as avg, count, etc.) and conditions need to be applied to the groups