ITM209 Knowledge Quizzes #4-10 + Practice Cryptography Questions

What is the order of commands in a SQL query? from table.column Select schema.table condition (x>10) where

1) Select 2) table.column 3) from 4) schema.table 5) where 6) condition (x>10)

Match the example with the correct business analytic: 1: ____ Did we make a profit last year? 2: ____ What will our sales be next quarter? 3: ____ Should we make or buy an expensive part for our machines? Options Descriptive Analytic Diagnostic Analytic Predictive Analytic Prescriptive Analytic

1: Descriptive Analytic 2: Predictive Analytic 3: Prescriptive Analytic

How many rows will you return in the following statement of code: select count(consultants.ID) from teleworks.consultants; a) 1 b) Greater than 1 row

a) 1

In what relationship does the primary key in one table become a foreign key in an existing table? a) 1:n b) 1:1 c) n:m

a) 1:n

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 data set 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 that it took to construct each house? a) DATEDIFF('day'[constructionStartDate],[constructionEndDate]) b) COMPARE ('count', [constructionStartDate],[constructionEndDate]) c) DAYCALC([constructionStartDate]-[constructionEndDate]) d) TODAY() - [constructionStartDate] e) DATEDIFF('day, [constructionStartDate ],TODAY()

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

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? a) Descriptive analytics b) Predictive analytics c) Prescriptive analytics d) Diagnostic analytics

a) Descriptive analytics

Jackson has a set of data that lists profits for a particular product line based upon each of the states in which the products are sold. The range of values (by state) vary from $-128, 319.34 to $267,987 for the month of April. Which of the following color schemes would be the best option for him to use for the profits for each state? a) Diverging b) Sequential c) Categorical d) Highlight

a) Diverging

When building a dashboard, which of the following would you consider when laying out your visualizations? a) F Pattern b) Visual Casting Theory c) Least to Most d) Visual Cognitive Load

a) F Pattern

Which area of code allows you you make a condition that uses aggregate functions? a) HAVING b) GROUP BY c) WHERE d) ORDER BY

a) HAVING

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. Which of the following describes this scenario? a) Moire Effect b) Anscombe's Quartet c) Gestalt Principle d) Herman Effect

a) Moire Effect

Which of the following would you use to show information when you hover your mouse over a datapoint in a Tableau visualization? a) Tooltip b) Label c) Color d) Size

a) Tooltip

One example of continuous data is height. a) True b) False

a) True

One example of discrete data is the number of computers in a computer lab. a) True b) False

a) True

Text in a novel is an example of unstructured data. a) True b) False

a) True

The select clause of the statement is used to list the attributes desired in the result of a query. a) True b) False

a) True

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? a) True b) False

a) True

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 a 3.0 You would utilize the following line in your query: where avg(studentClass.grade) >= 3.0 a) True b) False

a) True b) False

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 of the following areas would this code be placed? a) WHERE b) ORDER BY c) HAVING d) FROM

a) WHERE

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 a) customers b) schema c) customerID d) invoices

a) customers

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 a) invoices b) customers c) schema d) customerID

a) invoices

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? a) Changing the diagram to a box-and-whisker b) Adding trend lines to the scatterplot c) Using the sorting feature in the toolbar d) Dragging the field for grade to size e) Opening the raw data supporting the chart

b) Adding trend lines to the scatterplot

Which of the following uses of color in a visualization has contrasting colors for individual comparison? a) Highlight b) Categorical c) Diverging d) Sequential

b) Categorical

Collecting information from many sources and storing them together into a single location is referred to as: a) Metadata collection b) Data aggregation c) Join operations d) Data collaboration

b) Data aggregation

A colon punctuation mark (:) used to signify the end of a query? a) True b) False

b) False

A diverging color scheme would be one that shades of a single color diverge. a) True b) False

b) False

Discrete data can take on any value within a range. a) True b) False

b) False

To create a map in Tableau, you must drag latitude and longitude to "columns" and "rows." a) True b) False

b) False

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 individual's name - income is the individual's 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)? a) Only cities with an average age over 50 will be listed b) Only cities where the average incomes (with age filter applied) are equal to or above 35000 are listed c) The city with the highest average income based upon the query will be listed first d) The query lists individuals 50 and over

b) Only cities where the average incomes (with age filter applied) are equal to or above 35000 are listed d) The query lists individuals 50 and over

You are creating a line graph showing the number of students that have graduated from MSU over time. You want the line to show running total of the number of students. Which Tableau feature would make this task easy? a) Analytics Menu b) Quick Table Calculation c) Combo Charts d) Dual Axis Charting

b) Quick Table Calculation

Tree maps and heat maps use which of the following to show proportional size of values? a) Color and orientation b) Size and color c) Size and font d) Orientation and size

b) Size and color

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)? a) Scatterplot b) Tree Map c) Bar Chart d) Bubble Chart

b) Tree Map

Out of the situations below, which would be best performed using bar chart in Tableau? a) When showing proportions b) When comparing data across categories c) When investigating the relationship between different variables d) When viewing trends in data over time

b) When comparing data across categories

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 university.students on class.class|D = schedule.classID a) both university and class b) class c) university d) none of the choices

b) class

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? a) 1:n b) n:m c) 1:1

b) n:m

The three basic clauses of a SQL statement to select data are: a) select, distinct, where b) select, from, where c) select, from, as d) select, distinct. from

b) select, from, where

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? a) 0:1 b) 1:1 c) 1:n d) n:1 e) n:m

c) 1:n

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? a) Opening the raw data supporting the chart b) Changing the diagram to a box-and-whisker c) Adding trend lines to the scatterplot d) Using the sorting feature in the toolbar e) Dragging the field for grade to size

c) Adding trend lines to the scatterplot

Which of the following features in Tableau is NOT found in the "marks" shelf? a) Color b) Label c) Columns d) Detail e) Tooltip

c) Columns

When loading data into Tableau, which of the following types of data usually appears under Measures? a) Abstract b) Exploratory c) Continuous d) Discrete

c) Continuous

Joe has a document that contains all of the metadata about the data elements in a database. This would be an example of which of the following: a) Data Model b) Data Element c) Data Dictionary d) Data Aggregation

c) Data Dictionary

Which of the following keywords when used in a SQL select statement will remove duplicate records from the results? a)Unique b) Remdup c) Distinct d) Discrete

c) Distinct

Which of the following describes Anscombe's Quartet? a) The principle of using four different characteristics (size, color, shape and orientation) to distinguish the elements in a visualization. b)A method for dashboard layout in which the most important visualization or data is placed in the upper left corner. c) Four data sets with nearly identical descriptive statistics (slope, average, median, etc.) yet have very different distributions and appear very different when graphed. d) The process of visualizing data utilizing four different chart types (ex. bar, line, etc.) to show the differing dimensions of the same data.

c) Four data sets with nearly identical descriptive statistics (slope, average, median, etc.) yet have very different distributions and appear very different when graphed.

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

c) GROUP BY cashiers.lastName;

Which of the following is decreased when using a relational database? a) Flexibility b) Security c) Information redundancy d) Scalability

c) Information redundancy

Which of the following charts are good for showing data changes over time? a) Tree charts b) Pie chart c) Line chart s) Symbol maps

c) Line chart

When implementing a 1:n relationship, which of the following is true? a) The primary key of each table is put into each of the corresponding tables. b) The primary key of each table will be put into a third table as a concatenated key. c) The primary key of one table would be put in the other table as a foreign key. d) The primary key for the many (n) table will be null.

c) The primary key of one table would be put in the other table as a foreign key.

In a dashboard, you would usually place the visualization that requires the most emphasis in which quandrant? a) Lower Right b) Lower Left c) Upper left d) Center e) Upper Right

c) Upper left

Which wildcard allows you to look for a single character in a range? a) * b) % c) [] d) _

c) []

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.customer|D = customers.customerID a) both schema and invoices b) invoices c) both customers and invoices d) customers

c) both customers and invoices

The three factors of the variety of data are: a) form, source, velocity b) veracity, source, function c) form, function, source d) structured, large, source

c) form, function, source

Jacyln is writing a query that sums the profit by 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 and the field for profit is table.profit. a) group by sum(table.profit) b) having table.businessLine DESC c) group by table.businessLine d) having sum(table.profit) by table.businessLine

c) group by table.businessLine

Corey would like to use pull all the names from the students table that start with the letter "C" in the beginning and has "y" in the end. Which code would Corey use to complete this task? a) select students.names from college.students where students.names LIKE "%cy%"; b) select students.names from college.students where students.names LIKE "cy*"; c) select students.names from college.students where students.names LIKE "c%y"; d) select students.names from college.students where students.names LIKE "%cy%";

c) select students.names from college.students where students.names LIKE "c%y";

When is having used instead of where? a) when pattern matching is the only way to identify a tuple b) when a relationship in the database is not specified using keys c) 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 d) None of the above

c) 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

In determining the average sales per unit sold, why is the aggregate function (a) sum(sales) / sum(quantity) the correct function to use instead of using (b) and then averaging the aggregate function once added to the chart sales / quantity a) (a) is not correct, (b) should be used b) neither formula is correct, avg(sales) / avg(quantity) should be used c) (b) calculates an average at a much lower tolerance level than (a). (a) uses bins to correctly aggregate the average quantity sold before applying the sum function. d) (a) takes the total sales and total quantity and determines the average across all units sold, where (b) determines the average only for each line item. (b) considers each line item of equal weight regardless of whether or not it has more or less quantity than other line items.

d) (a) takes the total sales and total quantity and determines the average across all units sold, where (b) determines the average only for each line item. (b) considers each line item of equal weight regardless of whether or not it has more or less quantity than other line items.

Which of the following describes what Trend Lines are? a) The lines that separate segments in a tree chart. b) The line in a line chart that connects all the data points c) The line in a bubble chart that separates the top 50% of bubbles from the bottom 50% of bubbles d) A feature Tableau to show a line that represents the relationships between a set of data points that have been plotted (i.e. regression)

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

Which of the following would be an example of predictive analytics? a) Adding a trend line to identify if student grades on average have increased from freshman year to graduation year. b) Creating a chart of new clients by sales associate for the prior year to identify who has brought in the most new business. c) Creating a scatterplot of the pass completion rates by years of experience for all quarterbacks in the National Football League (NFL). d) 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.

d) 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.

Data was previously stored in a flat format. What was one disadvantage to flat databases? a) Data aggregation b) Key identification c) Broken relationships d) Data redundancy

d) Data redundancy

Which of the following describes a scenario in which a concatenated key would be utilized? a) Tables where one item in the table can relate to multiple items in a corresponding table (i.e. one to many relationship) b) Tables where there are no foreign keys to identify unique records. c) Tables where one item in the table can relate to only one item in a corresponding table (i.e. on to one relationship) d) Tables where only a combination of two attributes combined can make a unique identifier for rows (tuples) in a table

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

What is the where clause in a SQL statement used for? a) It tells the database which schema to use. b) It directs the output to a view. c) It tells where in the index the data is stored. d) To select only those rows in the result relation of the from clause that satisfy a specified predicate.

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

What SQL command allows you to rename your column heading? a) where b) select c) * d) as

d) as

Which aggregation function shows the number of records that meet a set of criteria? a) avg b) distinct c) countof d) count

d) count

Which wildcard would you use that allows you to select all the rows in a selected table? a) # b) : c) % d) & e) *

e) *

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 put in the lower right hand corner of the dashboard? a) A map showing the countries and states/provinces in the world using color to highlight the areas with the least and most sales b) The total quantity of each product sold c) Total sales by product category for the products they produce d) Number of recalls due to quality issues by product e) Top 12 customers of the company

e) Top 12 customers of the company

Jeff is creating a database to track TV shows and actors. Actors can be in multiple shows and shows can have multiple actors. Which of the following is the type of relationship and number of tables needed to implement this in a relational database? a) n:m & 2 tables b) 1:n & 2 tables c) 1:1 & 2 tables d) 1:n & 3 tables e) n:m & 3 tables

e) 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? a) group by distinct b) group by unique c) where unique d) select unique e) select distinct

e) select distinct