Azamara Club Cruises Interview Questions and Answers

• Q1. Lets say you have table 1 with values 1,2,3,5,null,null,0 and table 2 has null,2,4,7,3,5 What would be the output after inner join? View Answers (1)
• Q2. Lets say you have customers table with customerID and customer name, Orders table with OrderId and CustomerID. write a query to find the customer name who place...read more Add Answer
• Q3. Spark Architecture, Optimisation techniques Add Answer
• Q4. Some personal questions. Add Answer

• Q1. Explain the entire architecture of a recent project you are working on in your organisation. View Answers (1)
• Q2. How do you design an effective ADF pipeline and what all metrics and considerations you should keep in mind while designing? View Answers (1)
• Q3. Lets say you have a very huge data volume and in terms of performance how would you slice and dice the data in such a way that you can boost the performance? Add Answer
• Q4. Lets say you have to reconstruct a table and we have to preserve the historical data ? ( i couldnt answer that but please refer to SCD) Add Answer
• Q5. We have adf and databricks both, i can achieve transformation , fetching the data and loading the dimension layer using adf also but why do we use databricks if...read more Add Answer

• Q1. Basic HR questions Add Answer

• Q1. Introduce yourself. View Answers (1)
• Q2. Tell me about your current project and the domain you have worked on. View Answers (1)
• Q3. What is the logic of the code for finding duplicate numbers in an array? View Answers (1)
• Q4. What is the solution for resolving conflicts in a git merge? View Answers (1)
• Q5. Why is object creation not possible for abstract classes? View Answers (1)
• Q6. What is the purpose of exception handling in Java? View Answers (1)
• Q7. What are the key differences between LinkedList and HashSet? View Answers (1)
• Q8. Is it possible to achieve method overloading within a private class in Java? View Answers (1)
• Q9. What are the different types of dependency injection? View Answers (1)
• Q10. What is the flow of dependency injection in Spring Boot? View Answers (1)
• Q11. How do you call a private method in another class? View Answers (1)
• Q12. Which tree is used in TreeMap and what is the implementation of it? View Answers (1)
• Q13. What is the inversion of control and how does it work? View Answers (1)
• Q14. What is the difference between @RestController and @Request mapping? View Answers (1)
• Q15. Tell me the flow of HTTP requests for the backend in Java. View Answers (1)
• Q16. When can we use multiple catch blocks? View Answers (1)
• Q17. How can we achieve inheritance in Java? View Answers (1)
• Q18. What is the purpose of dependence injection? View Answers (1)
• Q19. What is the difference between stream and collection in Java? View Answers (1)
• Q20. What is the play framework and how is it different from spring boot? (I have majorly worked on play framework that's why this question was asked to me) Add Answer
• Q21. How do you create a spring boot application? View Answers (1)
• Q22. What are starter dependencies in spring boot? View Answers (1)
• Q23. What is a B-tree index? View Answers (1)
• Q24. What is a trigger in SQL and how is it used? View Answers (1)
• Q25. What are ACID properties? View Answers (1)
• Q26. What are the types of joins and what is the difference between them? View Answers (1)
• Q27. What is normalization? View Answers (1)
• Q28. Suppose there are two tables: A Customer table and an Order table. The Order table has a column OrderID CustomerID, OrderStatus, and TotalAmount. The Customer t...read more View Answers (1)

• Q1. Tell me about your family background, education, work experience, and project, on which you have worked. Add Answer
• Q2. Write a Java code and Angular code to retrieve the data from the given URL. "-----/" View Answers (1)

• Q1. Give me a Brief Introduction about you ? View Answers (2)
• Q2. Elaborate more on your current role and responsibilities ? View Answers (1)
• Q3. Order of Execution of ACLs ? View Answers (1)
• Q4. What are ACLs ? View Answers (1)
• Q5. What is the Syntax for including the Mail Script in a notification body ? View Answers (1)
• Q6. Email Script Scenario based question ? Add Answer
• Q7. How to substitute record values/Link in the mail body ? View Answers (1)
• Q8. What are different ways we can implement REST APIs integration ? View Answers (1)
• Q9. ACL Scenario based questions Add Answer

• Q1. Brief introduction about you ? View Answers (1)
• Q2. Notable Achievements you have had till date ? View Answers (1)
• Q3. What are the difficulties you have faced in your current organization project ? View Answers (1)
• Q4. Why do you want to leave your current company ? View Answers (1)

• Q1. Brief introduction on yourself View Answers (1)
• Q2. How do you explain your client about the application who is not technically strong ? View Answers (1)
• Q3. What are the 3 factors that you would discuss with the client before implementing something in ServiceNow ? View Answers (1)
• Q4. Explain about the integrations you have worked on in your current/previous Project ? View Answers (1)

• Q1. Brief Introduction on yourself ? View Answers (1)
• Q2. Why do you wanna leave your current Organization ? View Answers (1)
• Q3. What are your location preference ? View Answers (1)
• Q4. What is your LWD (last working day) ? View Answers (1)
• Q5. Finally Salary Negotiation with HR Add Answer

• Q1. Tell me about yourself View Answers (1)
• Q2. Project Architecture Add Answer
• Q3. Rate yourself out of 5 in Pyspark , Python and SQL View Answers (1)
• Q4. How to handle duplicates in python ? View Answers (1)
• Q5. Methods of migrating Hive metdatastore to unity catalog in Databricks ? View Answers (1)
• Q6. Read a CSV file from ADLS path ? View Answers (1)
• Q7. There was a table provided on coding screen and asked to write different programs and SQL queries from the table and tell the approach you are taking ? Like age...read more Add Answer
• Q8. How many stages will create from the above code that I have written View Answers (1)
• Q9. Narrow vs Wide Transformation ? View Answers (1)
• Q10. What are action and transformation ? View Answers (1)
• Q11. What happens when we enforce the schema and when we manually define the schema in the code ? View Answers (1)
• Q12. What all the optimisation are possible to reduce the overhead of reducing the reading part of large datasets in spark ? View Answers (2)
• Q13. Write a sql query to find the name of person who logged in last within each country from Person Table ? View Answers (1)
• Q14. Difference between List and Tuple ? View Answers (1)
• Q15. Difference between Rank , Dense Rank and Row Number and when we are using each of them ? View Answers (1)
• Q16. What is List Comprehension ? View Answers (1)
• Q17. Tell me about the performance optimization done in your project ? Add Answer
• Q18. Difference between the interactive cluster and job cluster ? View Answers (1)
• Q19. How to add a column in dataframe ? How to rename the column in dataframe ? View Answers (1)
• Q20. Difference between Coalesce and Repartition and In which case we are using it ? View Answers (2)

• Q1. What is your company GDP? View Answers (2)
• Q2. What is your company process? View Answers (1)
• Q3. How do you develop your company? View Answers (2)

• Q1. How do you take care of your Employees ? Add Answer
• Q2. What is your company ideas to grow up? Add Answer

• Q1. What is your next idea to develop the company? View Answers (1)
• Q2. What was Going to give the idea for your employee? Add Answer

How long you are working in this Company who they will take care of employee

• Q1. Telling about yourself ? View Answers (2)
• Q2. What's your strongest strength and weekness? View Answers (2)
• Q3. What is Accounts payable? View Answers (3)
• Q4. What is the difference between Accounts payable and Accounts receivable ? View Answers (4)
• Q5. What is the similarities in accounts payable and accounts receivable ? View Answers (3)

• Q1. Which ERP you use in your previous company? View Answers (1)
• Q2. How you process payment in tally? View Answers (3)
• Q3. If you are found any another price for the product in your grn so what should you do first? View Answers (3)
• Q4. How many types of purchase order are there? View Answers (3)
• Q5. Which purchase order we use the most or regular basic ? View Answers (3)
• Q6. What is p2p process ? View Answers (3)
• Q7. What is the p2p cycle? View Answers (3)
• Q8. What is vendor? View Answers (3)

• Q1. What exact code to be written when there are two field in selection screen if one field is filled the display second field and in which event it need to be writ...read more View Answers (2)
• Q2. Name the events in reporting and explain their uses? View Answers (3)
• Q3. While creating BADI implementation, what will get created Class method or interface explain? steps to implement BADI . name the BADI you have implemented. View Answers (2)
• Q4. What is CDS view, step to create, how CDS views can be used to display ALV ? View Answers (1)
• Q5. Suppose TMG is generated and you have added one field and that field is not reflecting what will you do? and name the TMG events. View Answers (1)
• Q6. Difference between Class and interface and Why oops ABAP is preferred? View Answers (1)
• Q7. How will you integrate S/4 Hana and SAP Ariba? What are the way you can? View Answers (1)
• Q8. What is IDoc? what are the steps use to create field segment in IDOC? suppose you encountered how will you reprocess? View Answers (1)
• Q9. How may types of Transport request are there in SAP? which will be created during report creation? How SO10 objects are transported? View Answers (1)
• Q10. How will you load image in Adobe form? How will you convert and Adobe form into Spanish or any other language? View Answers (1)
• Q11. How to make any parameter or field mandatory? Ans: Obligatory View Answers (1)
• Q12. Have you worked on indexes, i.e. , secondary indexes, how will you fetch value using secondary index in select query? View Answers (1)

An appetite test is a type of assessment used to measure an individual's innate abilities, talents ,or skills in a specific area . It's designed to evaluate a person's potential to perform a perticular task,job,or function
Aptitude tests typically assess:
Cognitive abilities ( e.g. problem - solving, resoning memory )
Technical skills ( e.g. programming ,data analysis)
Creative abilities ( e.g. writting design)
Interpersonal skills ( e .g. teamwork, communication )
Numerical abilities ( e .g . Math, statistic)

• Q1. Related to a specific skills of field of expertise , especially one that requires, specialized training or knowledge View Answers (1)
• Q2. Knowing or concealed with applied and industrial sciences, such as engineering, technology and computer science. Add Answer
• Q3. Using of characterized by the use of technical methold , tools,or equipment Add Answer
• Q4. Skills or knowledge related to a specific field or industry such as IT , engineering,or healthcare. Add Answer
• Q5. Relating to the practical application Of scientific,or technological principals Add Answer
• Q6. Expertise in a particular area, like programming, data analysis , or digital marketing . Add Answer
• Q7. Use of specialized equipment, tools, or software View Answers (1)
• Q8. Technical skills: proficiency in a specific area, like coding , or graphic design. Add Answer
• Q9. Technical knowledge - understanding of technical concept , theories, or principles . Add Answer

Writting code in a specific programing language.( e..g. python, java , javascript)

• Q1. Why CNN is preferred over feed forward neural networks ? View Answers (1)
• Q2. Problem based linear regression questions, basically about identifying the actual relationship between IV and DV variables. Add Answer
• Q3. If dealing with non-linearity with same data as in above question, which algo to prefer ? Typically it was on polynomial regression and how we choose the degree...read more Add Answer
• Q4. Explain overfitting and underfitting ? Techniques to avoid this View Answers (1)
• Q5. Explain cross validation and its process of working View Answers (1)
• Q6. Python based few things Add Answer

It was basically conceptual round with the vp. There were General questions about the studies, projects, data science journey etc.

And then an use case. I don't remember exactly but it was something like..

Different companies sales their different models of cars and providing incentives which are not coming through dealers obviously..infact from manufacturer itself.
Few more things on this and then questions like-
How would you convert this into an analytics problem?
What kind of data would be required to perform such analysis?
If you are dealing with regression problem but time is involved there, how you will solve that now ?
Some things on trend, seasonality in time series analysis, about arima.


Basically statistical kind of round but based on business scenarios.
Hope that helps😉

• Q1. Simple things on Salary discussions, expectations etc. Add Answer