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