WB01 Data Applications Version 1
Practice exam for Western Governors University WGU Exams under Western Governors University Exams (College Exams). 5 sample questions.
Sample Questions
You're viewing a limited preview. Log in and subscribe to access all questions.
Log InExam Questions
Question 1
An analyst is arranging all data in a dataset by ranking it based on a specific metric to make it easier to understand, analyze, and visualize. Which task is the analyst performing?
Correct Answer: B
Rationale: Sorting involves arranging data based on a specific metric, such as ranking, to enhance understanding and visualization. Updating modifies data values, restricting access limits who can view it, and filtering selects specific data subsets.
Rationale: Sorting involves arranging data based on a specific metric, such as ranking, to enhance understanding and visualization. Updating modifies data values, restricting access limits who can view it, and filtering selects specific data subsets.
Question 2
An analyst wants to sort all columns in a table in Microsoft Excel using Structured Query Language (SQL). Which SQL command can the analyst use to sort all columns?
Correct Answer: B
Rationale: The SELECT * command retrieves all columns from a table, and when combined with ORDER BY, it sorts the data. CAST converts data types, WHERE filters rows, and JOIN combines tables, none of which directly sort columns.
Rationale: The SELECT * command retrieves all columns from a table, and when combined with ORDER BY, it sorts the data. CAST converts data types, WHERE filters rows, and JOIN combines tables, none of which directly sort columns.
Question 3
Which tool does an analyst use to organize similar kinds of data into categories and subject areas?
Correct Answer: A
Rationale: Tables organize data into categories and subject areas using rows and columns for structured analysis. Reports summarize data, charts visualize trends, and maps display geographic data, but tables are primary for organization.
Rationale: Tables organize data into categories and subject areas using rows and columns for structured analysis. Reports summarize data, charts visualize trends, and maps display geographic data, but tables are primary for organization.
Question 4
How does an analyst type a SORT function in Microsoft Excel to organize data by a certain category?
Correct Answer: C
Rationale: In Excel, the SORT function is typed as =SORT to organize data by a specified category. The other options (-SORT, +SORT, SORT *) are not valid Excel function syntax.
Rationale: In Excel, the SORT function is typed as =SORT to organize data by a specified category. The other options (-SORT, +SORT, SORT *) are not valid Excel function syntax.
Question 5
How would an analyst specify a descending order of data in a Structured Query Language (SQL) query?
Correct Answer: A
Rationale: In SQL, ORDER BY followed by DESC specifies descending order for sorting data. FROM selects the table, SORT and FILTER are not SQL commands, and ASC denotes ascending order.
Rationale: In SQL, ORDER BY followed by DESC specifies descending order for sorting data. FROM selects the table, SORT and FILTER are not SQL commands, and ASC denotes ascending order.