AstraZeneca QA Interview Questions and Answers

SWOT ANALYSIS OF A NEW PRODUCT IN THE MARKET

RESEARCH ASSIGNMENT ON THE TB SPACE

Q1. Do you know adobe analytics
Ans. 
Yes, I am familiar with Adobe Analytics and have experience using it for data analysis.
• I have used Adobe Analytics to track website traffic and user behavior

• I have created custom reports and dashboards using Adobe Analytics

• I am proficient in extracting insights from Adobe Analytics data to drive business decisions
Answered by AI
Add your answer
Q2. Explain example of window function
Ans. 
Window functions are used to perform calculations across a set of table rows related to the current row.
• Window functions are applied to a set of rows related to the current row in a query result.

• They can be used to calculate running totals, averages, ranks, and more.

• Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
Answered by AI
Add your answer

Q1. Explain example of window function
Ans. 
Window functions are used to perform calculations across a set of table rows related to the current row.
• Window functions are used in SQL to perform calculations within a specific window or subset of rows.

• They allow you to perform aggregate functions like SUM, AVG, COUNT, etc. over a specific range of rows.

• Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
Answered by AI
Add your answer
Q2. A question using aggregate function and case when in sql
Add your answer

Q1. Coding questions on python
Add your answer
Q2. Version control system GitHub questions
Add your answer
Q3. Web scraping questions
Add your answer

Q1. Behavioral questions on senarioy
Add your answer

It was a 90 mins round, and we have to do 85 questions. Coding was also a part of it.

Q1. What time intelligence functions can be used for ytd and qtd analysis
Ans. 
Time intelligence functions like YTD (Year-to-Date) and QTD (Quarter-to-Date) can be used for YTD and QTD analysis in data analytics.
• YTD analysis can be done using functions like YTD() or TOTALYTD() to calculate values from the beginning of the year up to the selected date.

• QTD analysis can be done using functions like QTD() or TOTALQTD() to calculate values from the beginning of the quarter up to the selected date.

• Thes...read more
Answered by AI
Add your answer
Q2. Difference between import and direct query
Ans. 
Import brings data into Power BI for further analysis, while direct query connects to data source in real-time.
• Import: Data is loaded into Power BI for analysis, improving performance but requiring periodic refreshes.

• Direct Query: Connects to data source in real-time, allowing for up-to-date information but potentially slower performance.

• Import is suitable for smaller datasets, while direct query is better for large da
Answered by AI
Add your answer