BASSEIN CATHOLIC CO-OP BANK Interview Questions, Process, and Tips

Filters in Tableau allow users to focus on specific data points within a visualization.

• Filters can be applied to dimensions or measures to narrow down the data being displayed.

• Users can use various types of filters such as quick filters, context filters, and data source filters.

• Filters can be used to show or hide data based on specific criteria, such as date ranges or categories.

• Example: Applying a filter to show only

Blending and joins in Tableau allow users to combine data from multiple sources for analysis and visualization.

• Blending is used when data sources have a common field but different levels of granularity.

• Joins are used when data sources have a common field and the same level of granularity.

• Blending creates a virtual join, while joins physically combine the data.

• Examples: Blending sales data from Excel with customer data ...read more

LOD expressions in Tableau allow you to compute values at different levels of detail in a visualization.

• LOD expressions include FIXED, INCLUDE, and EXCLUDE functions

• FIXED LOD expressions compute values at a specific level of detail regardless of the visualization level

• INCLUDE LOD expressions compute values at the specified level of detail and include other dimensions in the visualization

• EXCLUDE LOD expressions compute ...read more

Different types of joins in SQL include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN. TRUNCATE is faster than DELETE as it removes all rows at once.

• Types of joins: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN

• TRUNCATE: removes all rows from a table without logging individual row deletions

• DELETE: removes specific rows from a table and logs each row deletion

• TRUNCATE is faster than DELETE as it does not log individual

I have handled high and critical alerts related to malware infections, data breaches, and phishing attacks.

• Identifying the source and scope of the alert

• Isolating affected systems to prevent further damage

• Implementing security patches and updates

• Conducting forensic analysis to determine the extent of the breach

• Collaborating with IT teams to strengthen security measures

SIEM tool architecture includes data collection, normalization, correlation, and reporting components.

• Data collection: Gathers security data from various sources like logs, network traffic, and endpoints.

• Normalization: Standardizes the collected data into a common format for analysis.

• Correlation: Identifies patterns and relationships in the data to detect security incidents.

• Reporting: Generates reports and alerts based...read more