ITM 209 Final

Jeff was asked to set up a visualization summarizing data on the amount of time it takes for a house to be built. He has a data set that contains information on houses that have been constructed by his organization, which includes the date they program to start construction (field constructionStartDate) and the date the finalized work (constructionFinishDate). doing some research, he found that tableau uses TODAY() to represent the current date. Which of the following calculated fields in tableau what identify the number of days that it took to construct each house? - DATEDIFF('day',[constructionStartDate],[constructionFinishDate] ) - DAYCALC([constructionStartDate] - [constructionFinishDate] ) - COMPARE('count',[constructionStartDate],[constructionFinishDate] ) - DATEDIFF('day',[constructionStartDate],TODAY()) - TODAY() - [constructionStartDate]

- DATEDIFF('day',[constructionStartDate],[constructionFinishDate] )

which of the following is true about the following SQL statement selecting data collected by the census (table census in a schema named 'us'), where: - name is the individuals name - income is the individuals annual income - city is the city the individual resides in - age is the age of the individual select census.name, avg(census.income), census.city, census.age from us.census where census.age > 50 group by census.city having avg(census.income) >= 35000 order by avg(census.income) DESC which of the following are true (select ALL that apply)? - The city with the highest average income based upon the query will be listed first - only cities with an average age of over 50 will be listed - only cities where the average incomes (with age filter applied) are equal to or above 35,000 are listed - the query lists individuals 50 and over

- The city with the highest average income based upon the query will be listed first - only cities where the average incomes (with age filter applied) are equal to or above 35,000 are listed

which of the following describes what trend lines are? - The line in a line chart that connects all the data points - A feature Tableau to show a line that represents the relationship between a set of data points that have been plotted (i.e. regression) - The lines at separate segments in a tree chart - The line in a bubble chart that separates the top 50% of bubbles from the bottom 50% of bubbles

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

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 requiring results to only return unique rows of data? - Group by unique - group by distinct - select distinct - where are unique - select unique

select distinct

In a SQL query, if - • you were averaging grade points from a table of students grades for each of the classes they took (field studentClass.grade) and • want to list those equal to or above at 3.0 you would utilize the following line in your query: where avg(studentClass.grade) >= 3.0 True or False?

False

In a SQL query, if - • You were averaging grade points from a table of students grades for each classes they took (field studentClass.grade) and • Want to list those equal to or below a 3.0 You would utilize the following line in your query: where avg(studentClass.grade) <= 3.0 True or False?

False

when building a dashboard, which of the following would you consider when laying out your visualizations? - Visual casting theory - visual cognitive load - F Pattern pattern - least to most

F pattern

which of the following causes distracting visual artifacts resulting from the series of bars placed closely together? - Gestalt Principle - Hermann Effect - Moiré Effect

Moiré Effect

How would you sort MySQL query results by a field called "lastName" from a table called "cashiers" from a database named "store"? - GROUP BY store.cashiers; - ORDER BY store.cashiers; - GROUP BY cashiers.lastName; - ORDER BY cashiers.lastName;

ORDER BY cashiers.lastName

what should be your focus when designing your visualization? - Following standards on visualization such as the NSOV - the audience - illuminating accessibility - your personal preferences

The audience

Lauren is creating a day to sit in the results she keeps getting has a lot of duplicate rows returned. She would like to remove the duplicates from the results and only display unique rows of data. What function in SQL what she used in her query? - Where are unique - where distinct - having unique - select distinct - select unique

select distinct

you created a scatterplot in tableau that contains plot of data points showing the number of class periods attended for a course vs. the grade assigned for students. You're trying to see if there's a positive relationship between the two. Which features/function will best aid you in this? - using the sorting feature in the tool bar - dragging the field for a grade to size - opening the raw data supporting the chart - adding trendlines to the scatterplot - changing the diagram to a box-and-whisker

adding trend lines to the scatterplot

The options for 'order by' when writing a SQL statement are: - up, down - asc, desc - alpha, revalpha - between, above

asc, desc

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 invoices.customerID = customers.customerID - invoices - both customers and invoices - both schema & invoices - customers

both customers and invoices

the 'as' clause: -can be used to rename attributes in the results of the query - joins two tables in a query - treats a foreign key as a primary key - specifies whose authority to execute a query as.

can be used to rename attributes in the results of the query

which of the following uses of color in a visualization has contrasting colors for individual comparison? - diverging - sequential - highlight - categorical

categorical

when unloading data into tableau, which of the following types of data usually appears under measures? - continuous - abstract - discrete - exploratory

continuous

Which aggregation function shows the number of records that meet a set of criteria? - avg - countof - count - distinct

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 = customer.customerID - customerID - customers - invoices - schema

customers

while going through the newspaper, you find a chart showing the historical rates of infections for various viruses worldwide. This type of visualization is an example of which of the following types of analytics? - predictive - descriptive - prescriptive - pro-forma

descriptive

which of the following keywords when used in a SQL statement will remove duplicate records from the results? - remdup - discrete - unique - distinct

distinct

A divergent color scheme would be one that shades of a single color diverge. True or false?

false

Visualizing data is a relatively new concept that was introduced with the introduction of the modern personal computer. True or false?

false

discrete data can click on any value within a range. True or false?

false

Jocelyn is writing a query that sums the prophet a business line for her organization. For the sum to performed against each business line, she would use which of the following to specify the level of aggregation that sum should be executed against? Note: The field for business line is table.businessLine in the field for profit is table.profit. - having table.businessLine DESC - having sum(table.profit) by table.businessLine - group by sum(table.profit) - group by table.businessLine

group by table.businessLine

Robert is writing a query to pull data from two tables. One table (games) contains a list of video games. The field games.gameID is the primary key of games and the field highScores.gameID is the foreign key in the highScores table. The other table highScores contains player high scores. He has written the following in his query so far: SELECT games.title, games.releaseDate, games.platform, highScores.score, highScores.player FROM schema.games •••••••• WHERE highScores.score > 100000 He wants his query to pull all the games that have a corresponding high score in the table highScores. What would be the joint statement below that Robert would utilize? - left join schema.highScores on highscores.gameID = games.gameID - right join schema.highScores on highscores.gameID = games.gameID - inner join schema.highScores on highScores.gameID = games.gameID - inner join schema.highScores having highscores.gameID = games.gameID - inner join schema.highScores where highScores.gameID = games.gameID

inner join schema.highScores on highScores.gameID = games.gameID

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 - customers - customersID - schema

invoices

which of the following charts are good for showing data changes over time? - Tree charts - line charts - pie charts - symbol maps

line chart

The operator "like" in a SQL statement is used for: - pattern matching - finding where foreign keys equal primary keys - joining two attributes in the results - comparing the contents

pattern matching

What is the picture of superiority affect? - Pictures (visualizations) are superior if they leverage color in the correct way - the most important visualization in a dashboard should be the largest - superior visualizations follow the F pattern in a dashboard - pictures (visualizations) are retained at much higher rates than words

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

which of the following best represents a SQL statement showing the average salary of the employees for each job title/role, where the data is in the following tables: Table: Jobs jobID jobTitle department 8••••••Sr. Cost Accountant••••••Accounting 14•••••Jr. Product Designer•••••Engineer 12•••••Promotional Director•••Marketing Table: Employees employeID name jobID yearOfService salary 657324••••EricLeRoi••14•••••3••••••••$65000 345546••••SammyVos••12•••••12••••••••$119000 213879••••JeffSingleman••14•••••4••••••••$72000

select jobs.jobTitle, avg(employees.salary) from schema.employees inner join schema.jobs on jobs.jobID = employees.jobID group by jobTitle;

tree maps and heat maps use which of the following to show proportional size of values? - size and color - orientation and size - size and font - Color and orientation

size and color

Penelope works for a prominent biomedical facility. Her boss, candy, has asked her to create a dashboard showing the following (ordered by most important to least important): 1) total sales by product category for the products they produce 2) The total quantity of each product sold 3) Number of recalls due to quality issues by product 4) A map showing the countries and states/provinces in the world using color to highlight the areas with the least and most sales 5) top 12 customers of the company if applying the F pattern for design, which of the following would Penelope be put in the lower right hand corner of the dashboard? -top 12 customers of the company - a map showing the countries and state/provinces in the world using color to highlight the areas with the lease and most sales - the total quantity of each product sold - total sales by product category for the products they produce - number of recalls due to the quality issues by product

top 12 customers the company

what chart type would be the best to show the hierarchal nature of data (i.e. how sub-components build up to their parent components)? - scatterplot - bubble chart - bar chart - tree map

tree map

The select clause of the statement is used to list the attributes desired in the result of a query. True or false?

true

in a dashboard, you would usually place the visualization that requires the most emphasis in which quadrant? - lower left - center - upper left - upper right - lower right

upper left

When is 'having' used instead of 'where'? - when a relationship in the database is not specified using keys - when groups are present through the use of an aggregation function (such as avg, count, etc.) and conditions need to be applied to the groups - when pattern matching is the only way to identify a tuple - none of the above

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

when should you use multiple colors? - When you need to differentiate types of data - when you want to dazzle the audience - when relative size varies between each of the items - in cases where you will have medium that allows for color

when you need to differentiate types of data