Real questions from top companies · easy
Managed Table vs External Table
Managed vs Unmanaged Tables
Merge two dictionaries and remove keys with null values.
Nested and Repeated Fields in BigQuery
No Column Names in CSV - how to handle
Normalization & Slowly Changing Dimensions (SCD) Type 2
Normalization: 1NF, 2NF, 3NF with examples
Real-Time Scenarios with Stored Procedures
Remove duplicates, fill missing values, and apply schema validation using ScalaSpark
Replace each node's value with the next greater value in the list. Addressed edge cases where no greater element exists.
Retrieve Schema of BigQuery Table
SCD Implementation in ETL
SCDs: Types of Slowly Changing Dimensions and their use cases
SQL Query: Group Employees by Technology and Order by ID
Schema Changes in Source (New Column Addition) - Impact
Self-introduction including current role, projects, and key responsibilities. Focus on SQL expertise, Python skills, and experience in data warehousing and modeling.
Serverless vs. Dedicated SQL pools
Share a situation where you took ownership of a failing project.
Share an example where you had to communicate technical concepts to a non-technical audience.
Slowly Changing Dimension (SCD) Type 4 - describe hybrid approach
Type or paste your answer to any of these questions and our AI Coach scores it, highlights gaps, and rewrites it at FAANG quality. Free to try.