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…
Which type of variable is used for qualitative values such as gender or eye color? continuous nominal discrete ordinal Explanation & Hint: Variables are either categorical or numerical. Categorical variables…
Refer to the exhibit. A data analyst wants to create a formula in Microsoft Excel that will automatically calculate the net revenue from the sales of dining sets. Which formula…
Match the type of data analysis with the question it can answer. Predictive ==> What might happen in the future? Prescriptive ==> What should be done next? Diagnostic ==> Why did something happen?…
Match the task and purpose to the appropriate Big Data analytics method. analyzing customer subscription cancellations and correlating them with customer comments and ratings to determine the most common reasons…
Which statement is true concerning data analytics? Predictive analytics uses simulation models and forecasting to suggest what could happen. Descriptive analytics attempts to predict what will happen next. Descriptive analytics…