D468 Discovering Data - Set 3 - Part 1

Test your knowledge of technical writing concepts with these practice questions. Each question includes detailed explanations to help you understand the correct answers.

Question 1: What is the first phase of the data life cycle where data is gathered from various sources?

Plan

Capture

Process

Question 2: Which SQL clause is used to group rows that have the same values in specified columns?

GROUP BY

WHERE

ORDER BY

HAVING

Question 3: What is the purpose of the Process phase in data analysis?

To clean and organize data

To collect raw data

To share data with stakeholders

To define data requirements

Question 4: Which type of problem involves determining why a dataset contains anomalies or rare occurrences?

Categorizing things

Spotting something unusual

Finding patterns

Making predictions

Question 5: In data analysis, what does the acronym SQL stand for?

Structured Query Logic

Simple Query Language

Structured Query Language

Standardized Query Language

Question 6: Which of the following is a key aspect of SMART goals?

Goals should be subjective

Goals should be measurable

Goals should be abstract

Goals should be flexible

Question 7: What is the role of the WHERE clause in SQL?

To specify the tables involved in a query

To define the columns to retrieve

To filter records based on specified conditions

To sort data in ascending order

Question 8: Which data type is used in SQL to store whole numbers without decimals?

VARCHAR

INT

FLOAT

DATE

Question 9: Which type of analysis focuses on identifying relationships between two variables?

Predictive analysis

Correlation analysis

Time series analysis

Descriptive analysis

Question 10: Which SQL statement is used to modify data in an existing row of a table?

INSERT

UPDATE

SELECT

DELETE

Question 11: In the data analysis process, which phase comes after the Analyze phase?

Act

Capture

Process

Question 12: What is the purpose of the Process phase in the data life cycle?

To collect data

To clean and prepare data for analysis

To store data for future use

To archive historical data

Question 13: What is the function of the SELECT statement in SQL?

To delete data

To retrieve data from a database

To update existing records

To insert new data into a table

Question 14: Which SQL clause is used to filter groups based on a condition after grouping the data?

WHERE

ORDER BY

GROUP BY

HAVING

Question 15: Which data visualization is best suited for comparing the proportions of different categories in a dataset?

Pie chart

Line graph

Bar graph

Scatter plot

Question 16: What does the “R” in SMART goals stand for?

Realistic

Relevant

Recorded

Rational

Question 17: What is the main focus of time series analysis?

Identifying relationships between variables

Analyzing categorical data

Forecasting future trends based on historical data

Finding anomalies in data

Question 18: Which SQL function would you use to combine rows from two tables based on related columns?

UNION

JOIN

GROUP BY

SELECT

Question 19: Which of the following is an example of qualitative data?

Product ratings on a scale of 1 to 5

Customer opinions about a product

The number of units sold

Revenue figures

Question 20: In SQL, which function is used to remove duplicate rows from a result set?

DISTINCT

DELETE

GROUP BY

COUNT

Need Guaranteed Results?

Our exam support service guarantees you'll pass your OA on the first attempt. Pay only after you pass!

Get Exam Support