Tredence Interview Questions, Process, and Tips

Half hour with spark python azure databricks

Q1. Architecture databricks
Add your answer
Q2. Sql related questions
Add your answer

Q1. When would you use Parameters and constant in m query.
Ans. 
Parameters are used for dynamic values that can be changed, while constants are used for fixed values in M query.
• Use parameters for values that may change frequently, such as dates or file paths

• Use constants for values that are fixed, such as column names or static calculations
Answered by AI
Add your answer
Q2. Some questions related to the projects I have worked on.
Add your answer
Q3. Some wueations related to the Banking sector overview and KPI'S
Add your answer

Q1. Few dax and sql queries
Add your answer

Q1. Salary discussion
Add your answer

Easy question was asked along with some aptitude questions.

Q1. Explain your project and the challenge you faced while doing the project?
Ans. 
Developed a predictive model for customer churn in a telecom company.
• Collected and cleaned customer data including demographics, usage patterns, and customer service interactions.

• Used machine learning algorithms such as logistic regression and random forest to predict customer churn.

• Challenges faced included imbalanced dataset, feature selection, and model evaluation.

• Implemented techniques like SMOTE for handling imbal...read more
Answered by AI
Add your answer
Q2. Basic join questions of SQL were asked
Add your answer

Q1. SQL Window functions
Add your answer
Q2. Tableau LOD functions
Add your answer

Q1. Prepare basics and and under why and what of any concept
Add your answer
Q2. Be sure on what you answer, if not sure be sure on the answer you provide
Add your answer