What is represented by the comma-separated list of items following the SELECT command in this example? SELECT movieID, title aliases records table names columns (attributes) Answers Explanation & Hints: The SELECT command…
Which structure in a table represents an individual record contained in the database? foreign key row relationship column Answers Explanation & Hints: In a relational database table, each row represents…
In the SQL statement " SELECT genre FROM movies" what is specified by "genre"? the column the table the folder the database Answers Explanation & Hints: The SELECT statement identifies the column in a table from…
What is used to show how the tables in a database are related to one another? CSV DDL ERD DML Answers Explanation & Hints: An Entity Relationship Diagram (ERD) shows…
Which SQL statement is used to filter data in a database? WHERE FROM ORDER BY DISTINCT Answers Explanation & Hints: The WHERE statement is a conditional statement used to filter…
Which commonly used SQL statement is necessary to retrieve data from one or more tables in a database? TRUNCATE SELECT INSERT CREATE Answers Explanation & Hints: The SELECT statement is…
What is a flat file database? a database that stores records in a single file with no hierarchical structure a database that requires SQL to store, manipulate, and retrieve data…
A data analyst wants to display outliers in the data set. Which type of visual representation would best suit this task? line chart bar chart scatter plot pie chart Answers…
A data analyst wants to display the various segments of a country’s energy sources (e.g., oil, coal, gas, solar, wind) contributing to 100% of its energy sources in a visual…
Why is regression analytics used in the inferential and machine learning analyses of big data? It is used to find groups of observations that are similar to each other. It is…
Which type of inferential and machine learning analysis is used to find groups of observations that are similar to each other? regression association cluster observation Answers Explanation & Hints: A…
Why are different sampling techniques used to gather inferential statistical data? to reduce error and increase confidence in the generalizations about the findings to get accurate mean values to verify…
A data analyst wants to find data point values that are significantly different from others in a data set. What are these values called? outliers scatter plots cluster associations Answers…
Which three key pieces of information are required to perform a VLOOKUP function in Microsoft Excel? (Choose three.) the column number in the range that contains the return value the…
What can a data analyst do if they wanted to remove duplicate values in a Microsoft Excel spreadsheet? use VLOOKUP use conditional formatting parse the data from "text to column"…
How is the Microsoft Excel VLOOKUP tool used in data analysis? to summarize descriptive data sets to interpret inferential data sets to find specific information in a large spreadsheet to…
What are inferential data sets? They are data sets gathered from a representative sample to make generalizations or predictions about a population. They are data sets that describe the current…
In Microsoft Excel, what is a characteristic of an "absolute reference"? the reference changes depending on the relative position of the cell it is indicated by preceding a cell reference in…
What sign do all Microsoft Excel formulas start with? equal sign (=) plus sign (+) number sign (#) asterisk symbol (*) Answers Explanation & Hints: All Excel formulas start with…
What is the Microsoft Excel "LEN" function used for? it returns the number of characters in a text string in a cell it automatically adds the values in a given…