What is the maximum number of views or sheets that can be added to a Tableau dashboard? 4 unlimited 5 8 Answers Explanation & Hints: There is no limit to…
How does the Show Me button in Tableau Public identify the recommended chart type for the uploaded data? yellow highlight red border bold text magnified image Answers Explanation & Hints: Clicking the Show…
Your company has tasked you with learning about the features and benefits of using Tableau as a business intelligence tool. From your research, what are two use cases best suited…
What are two types of data that benefit from NoSQL data storage? (Choose two.) data with flexible formats that can change over time high volumes of unstructured data data easily…
What is the result of the query shown in the example? UPDATE Review SET Comment = 'This is the new comment' WHERE MovieId = 3456 AND AuthorName = 'PuzoFan76'; The comment made by PuzoFan76 for…
Review the columns and descriptions in each table, Movie, and Award. Data from the two tables need to be combined to extract the title and cost of movies that won awards. Can a NATURAL…
Which JOIN clause would join the two tables Orders and Customers, using the CustomerID field in both tables as the relationship between the two tables? SELECT * FROM Orders LEFT JOIN Customers ON ____________ =…
Refer to the exhibit. Which type of SQL JOIN operation would return all the rows from Table 1 and Table 2? LEFT JOIN RIGHT JOIN FULL JOIN INNER JOIN Answers…
In combination with primary and foreign keys, which SQL statement is the most common method for joining fields from multiple tables? BETWEEN LIKE JOIN WHERE Answers Explanation & Hints: The…
Refer to the exhibit. You need to get information about customer purchases that is stored in the two tables. You would like to see data from the OrderID, CustomerName, OrderAmount,…
Which two SQL statements are used to create and change a database schema? (Choose two.) ALTER CREATE DELETE INSERT SELECT Answers Explanation & Hints: ALTER and CREATE are Data Definition…
Which three elements of a relational database are defined in the schema? (Choose 3.) attributes SQL keywords aliases tables relationships Answers Explanation & Hints: A schema is a formal description…
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…