Search test library by skills or roles
⌘ K

Adaface Sample ETL Questions

Here are some sample ETL questions from our premium questions library (10273 non-googleable questions).

Skills

🧐 Question

Medium

Data Updates
Staging
Data Warehouse
Solve
Jaylo is hired as Data warehouse engineer at Affflex Inc. Jaylo is tasked with designing an ETL process for loading data from SQL server database into a large fact table. Here are the specifications of the system:
1. Orders data from SQL to be stored in fact table in the warehouse each day with prior day’s order data
            2. Loading new data must take as less time as possible
            3. Remove data that is more then 2 years old
            4. Ensure the data loads correctly
            5. Minimize record locking and impact on transaction log
Which of the following should be part of Jaylo’s ETL design?
            
            A: Partition the destination fact table by date
            B: Partition the destination fact table by customer
            C: Insert new data directly into fact table
            D: Delete old data directly from fact table
            E: Use partition switching and staging table to load new data
            F: Use partition switching and staging table to remove old data

Medium

Trade Index
Index
Solve
Silverman Sachs is a trading firm and deals with daily trade data for various stocks. They have the following fact table in their data warehouse:
Table: Trades
            Indexes: None
            Columns: TradeID, TradeDate, Open, Close, High, Low, Volume
Here are three common queries that are run on the data:
 image
Dhavid Polomon is hired as an ETL Developer and is tasked with implementing an indexing strategy for the Trades fact table. Here are the specifications of the indexing strategy:
            
            - All three common queries must use a columnstore index
            - Minimize number of indexes
            - Minimize size of indexes
Which of the following strategies should Dhavid pick:
A: Create three columnstore indexes: 
            1. Containing TradeDate and Close
            2. Containing TradeDate, High and Low
            3. Container TradeDate and Volume
B: Create two columnstore indexes:
            1. Containing TradeID, TradeDate, Volume and Close
            2. Containing TradeID, TradeDate, High and Low
C: Create one columnstore index that contains TradeDate, Close, High, Low and Volume
D: Create one columnstore index that contains TradeID, Close, High, Low, Volume and Trade Date
🧐 Question🔧 Skill

Medium

Data Updates
Staging
Data Warehouse
2 mins
ETL
Solve

Medium

Trade Index
Index
3 mins
ETL
Solve
🧐 Question🔧 Skill💪 Difficulty⌛ Time
Data Updates
Staging
Data Warehouse
ETL
Medium2 mins
Solve
Trade Index
Index
ETL
Medium3 mins
Solve

Adaface questions are trusted by enterprises globally

Amazon Morgan Stanley Vodafone United Nations HCL PayPal Bosch WeWork Optimum Solutions Deloitte Microsoft NCS Doubtnut Sokrati J&T Express Capegemini

We evaluated several of their competitors and found Adaface to be the most compelling. Great default library of questions that are designed to test for fit rather than memorization of algorithms.


Swayam Narain, CTO, Affable

hashtag image heart icon Swayam
Join 1200+ companies in 75+ countries.
Try the most candidate friendly skills assessment tool today.
Ready to streamline your recruitment efforts with Adaface?
Ready to streamline your recruitment efforts with Adaface?
Chat with us
40 min tests.
No trick questions.
Accurate shortlisting.
Ada
Ada
● Online
Previous
Score: NA
Next
✖️