Data Querying And Analysis

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

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

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

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

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

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 THREE of the following are common data types in relational databases?

Which THREE of the following are examples of descriptive statistics?

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?

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?

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

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

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

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

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

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

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

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

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?

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?

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

Which of the following is a 'categorical' variable?

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

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?

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

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 normalizing a database, what is the primary goal of moving data into a third normal form (3NF)?

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

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?

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

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

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

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

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 TWO of the following are common types of data visualizations used to represent trends over time?

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

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

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?

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