1) Imagine you are data modeling Netflix and create the entities and relationships involved using a modeling tool. 2) follow a link to a sql tool which shows 4 tables. Run some provided sql to populate the tables, Create the sql to aggregate the data and provide a result set showing the top row.
What would I do differently in a difficult situation that I had just described where I was unhappy with the outcome?
PDFs cannot be attached, to show what must be the worst (vague, convoluted, terse and tricky) Spark SQL/Python json-in parquet-out tech assessments I've ever seen... and I've seen a lot of them.
How to implement retry in ADF?
How to detect new files in s3 using glue?
How to implement sdc2 in adf using dataflows?
A lot of basic SQL questions like "what is a temp table"
if you have the following Category | Sub-Category | Sales for Sub-Category | How do you calculate the total sales for each category Sub Question - What are the different types of LOD
1st Round : There were 15 SQL questions along with 2 python question to be solve within 1 hour and you have to explain the concepts.
Formula Debugging Will this calculation work? IF [Category Name] = 'Cardio Equipment' THEN SUM([Sales]) ELSE null END
Viewing 51 - 60 interview questions