MiQ Digital Senior Data Analyst Interview Questions and Answers

Q1. EXPLAINATION of DSP and SSP
Ans. 
DSP stands for Demand-Side Platform and SSP stands for Supply-Side Platform in the context of programmatic advertising.
• DSP is a platform used by advertisers to purchase ad inventory in real-time auctions.

• SSP is a platform used by publishers to sell their ad inventory to advertisers.

• DSPs and SSPs work together in programmatic advertising to automate the buying and selling of ad space.

• DSPs use data and algorithms to targ...read more
Answered by AI
Add your answer

Q1. Profile Related
Add your answer
Q2. Product management
Add your answer

Reasoning and logic base qus

Q1. About metrics like Cpc, cvr
Add your answer

Q1. Discuss about previous work
Add your answer

Q1. All questions were related to SQL and Context of the role
Add your answer
Q2. Joins, Unions and case scenario
Add your answer

Q1. What is rank in sql .. kind of scenario based
Add your answer
Q2. Examples of with/ sub query in sql
Ans. 
Using subqueries in SQL allows for more complex queries by nesting queries within other queries.
• Subquery in SELECT statement: SELECT column_name FROM table_name WHERE column_name = (SELECT column_name FROM table_name)

• Subquery in WHERE clause: SELECT column_name FROM table_name WHERE column_name IN (SELECT column_name FROM table_name)

• Subquery in FROM clause: SELECT column_name FROM (SELECT column_name FROM table_name) A
Answered by AI
Add your answer

Q1. Tell about work experience
Add your answer
Q2. Details about skill set
Add your answer