Data Querying And Analysis

An analyst is using a CTE (Common Table Expression) to pre-aggregate sales data before performing a join. What is the primary benefit of using a CTE instead of a subquery in this scenario?

When joining two tables in SQL where you need to return all records from the left table even if there is no match in the right table, which JOIN type is appropriate?

Which SQL function is used to convert a NULL value in a query result into a default value, such as 0?

You are performing data transformation in Python using Pandas. You have a 'DataFrame' with missing values in the 'Revenue' column. Which method should be used to replace these missing values with the column mean?

A data analyst is writing a SQL query to retrieve unique department names from the 'Employees' table. Which keyword should be utilized to ensure the results do not contain duplicate entries?

In Power BI, which visualization component is best suited to show the relationship between two numerical variables and identify potential trends or clusters?

When cleaning a dataset, you notice that column names contain inconsistent casing (e.g., 'Name', 'NAME', 'name'). Which transformation step should be prioritized to facilitate join operations?

A database administrator needs to ensure that a query calculating running totals is performant. Which window function clause is essential to order the calculation sequence?

You are debugging a SQL query that uses an aggregate function. You receive an error stating that a column in your SELECT list is not part of an aggregate or a GROUP BY clause. What is the cause?

A report needs to identify the 'top 10' customers by total spend. In SQL, which clause would you use to return only the first 10 results after sorting by spend descending?

In data visualization, what is the 'Data-Ink Ratio' intended to improve?

When working with time-series data, what does a 'lag' feature represent in an analysis?

Which of the following is an example of an unstructured data source that a data analyst might need to ingest?

An analyst notices that a database query is performing full table scans even though a WHERE clause is present on a indexed column. What is a likely reason for this?

When performing sentiment analysis on customer feedback, which preprocessing step is most critical to ensure words like 'Running' and 'run' are treated as the same base concept?

Which dashboarding practice helps prevent users from being overwhelmed by too much data at once?

What is the benefit of using a 'Dashboard' over a static report?

What does the 'P' in the acronym 'KPI' stand for?

When analyzing JSON data stored in a relational database using SQL, how do you typically access nested key-value pairs?

When creating an ETL pipeline, which stage involves validating that the data meets business rules (e.g., age must be positive)?

When normalizing a database, what is the primary goal of moving data into a third normal form (3NF)?

When troubleshooting a performance bottleneck in a visualization, which action is most effective if the data source is a large SQL view?

When using Python's 'Matplotlib' library, which function is used to add a new figure to the canvas?

Which SQL command is used to add new records to an existing table?

In the context of data quality, what does 'Completeness' refer to?

Which of the following is a 'categorical' variable?

Which of the following is a limitation of the 'Star Schema' design compared to a fully normalized schema?

Which TWO of the following are commonly used methods for handling outliers during data analysis?

Which TWO of the following are common types of data visualizations used to represent trends over time?

Which THREE of the following are components of a standard SQL SELECT statement?

Which THREE of the following SQL aggregate functions are commonly supported in most relational databases?

Which THREE of the following are common data types in relational databases?

Which TWO of the following actions are considered best practices for maintaining data integrity in a data pipeline?

Which TWO of the following are legitimate ways to optimize SQL query performance?

Which TWO of the following are benefits of using a data warehouse?

Which THREE of the following are examples of descriptive statistics?

Which THREE of the following are types of data joins in SQL?

Which THREE of the following represent common data transformation tasks in a preparation workflow?

Which TWO of the following are common issues encountered when integrating data from disparate sources?