Refer to the exhibit. Match the JOIN operation with the proper description. LEFT JOIN ==> Returns all records from Table 1 and only the matched records from Table 2. FULL JOIN…
What is the purpose of the DML language commands in SQL? to create, modify or delete objects in the database schema to manage updates to the database storage to select,…
Refer to the exhibit. A portion of the Movie table from the Movies database is shown. A data analyst is writing a query that will return the title and release…
Refer to the exhibit. Which option will correctly display the user names and email addresses of users in this table? SELECT User FROM user_id, user_name, user_email SELECT user_id, user_name, user_email FROM…
What is referenced by the FROM statement in an SQL query? the row where the data is located the table containing the data the column where the data is located…
Drag the SQL Data Manipulation Language (DML) statements to the correct description. ORDER BY ==> Used to structure the resulting query in ascending (ASC) order by default WHERE ==> Is a conditional…
Refer to the exhibit. A learner is analyzing a data spreadsheet in Microsoft Excel and notices a formula function "=VLOOKUP(B1,$A$2:$A$10,1,FALSE)". When clicking on cell C2, the value displayed in the…
A learner is analyzing a large volume of data in a Microsoft Excel spreadsheet and wishes to find duplicate data values. The data has been organized in a table where…
What is a statistical analysis result that a descriptive statistical analysis will not provide? calculation of how widely dispersed the data is visualization of particular data trends occurring predictions made…
A data analyst wants to compare the average life expectancy and GDP for forty countries. Which type of visual representation would best suit this task? bar chart line graph scatter…
Which option in Microsoft Excel represents a formula with an absolute reference? =(B$1-B$3) =($A1-$B1) =(B$=(C$1$-F$1$) =($A$1-$B$1)) Explanation & Hint: Dollar symbols in a cell reference indicate to Microsoft Excel to…
What is a pivot table in Microsoft Excel? a function to investigate formula errors and correct them a table containing data that is organized vertically a table containing data that…
Match the Microsoft Excel function with its description. LEN ==> It is used to return the number of characters in a cell COUNTA ==> It is used to return the number of blank…
A data analyst needs to organize sales data for analysis. Which Excel function can order the data by date sold, with the most recent sales listed first? Sort & Filter…
What are two plain-text file types that are compatible with numerous applications and use a standard method of representing data records? (Choose two.) PDF DOC XML XLS JSON Explanation &…
Which statement is true about the ELT and ETL process? In the ETL process, the extract step occurs after the load step. In the ETL process, the load step occurs…
Match the ETL process with its description. transform ==> Is the process of conditioning data into a usable form, such as removing duplicate data, providing missing data, and correcting any errors…
Which two tasks are performed as part of the transform step of the ETL data process? (Choose two.) transferring the data into a database collecting and recording the data removing…
Refer to the exhibit. What is the resulting output from the formula in cell D8? 6 46 12 7.6 Explanation & Hint: The COUNT function counts the number of cells…
Match the variable with the description. nominal ==> qualitative values based on identity of the object ordinal ==> qualitative values in order of ranking discrete ==> quantitative and finite set of values continuous…