Tredence Power BI Developer Interview Questions and Answers

Coding testing with 15 questions MCQ based

Q1. 1 or 2 DSA questions, rest tech stack related questions were asked
Add your answer

Q1. This was a technofunctional round, kind of a managerial round.
Add your answer

Q1. This was a HR round
Add your answer

Q1. Reg BW and ABAP and XSA
Add your answer

Q1. Reg sap BW and ABAP and XSA
Add your answer

Q1. Company structure
Add your answer

Round duration - 120 minutes
Round difficulty - Easy

After round 1 there was a break of 15 mins and the coding round started.
We had a choice to attempt the exam in R language & SQL or python & sql
I chose python and sql
It had 8 questions 4 python and 4 sql

Q1. 
Longest Common Subsequence Problem Statement
Given two strings, S and T with respective lengths M and N, your task is to determine the length of their longest common subsequence.
A subsequence is a seque...read more
Ans. 
The task is to find the length of the longest common subsequence between two given strings.
• Use dynamic programming to solve this problem efficiently.

• Create a 2D array to store the lengths of longest common subsequences of substrings.

• Iterate through the strings to fill the array and find the length of the longest common subsequence.

• Example: For strings 'abcde' and 'ace', the longest common subsequence is 'ace' with leng
Answered by AI
Add your answer

Round duration - 15 minutes
Round difficulty - Medium

The interview was mostly analytical based and how you approach the round a few technical questions in dbms and oops were also asked.

Round duration - 20 Minutes
Round difficulty - Medium

Similar to first round
For Shortlists after elimination from first round.

Q1. 
Car Pooling Capacity Problem
You are a cab driver with a car that initially has 'C' empty seats. The car moves in a straight line towards the forward direction only. Your job is to determine if it is poss...read more
Ans. 
Determine if it is possible to accommodate all passenger trips within a car's capacity without exceeding it at any point.
• Iterate through each trip and keep track of the total number of passengers in the car at each point.

• Check if the total number of passengers exceeds the car capacity at any point.

• Return 'True' if all trips can be accommodated within the car capacity, otherwise return 'False'.
Answered by AI
Add your answer

Round duration - 20 minutes
Round difficulty - Easy

After two technical round interviews, the last round was a hr interview. The whole process can take up one whole day or more and your interview can be at any time
My process started at 5 pm and ended at 10:30 pm
All the interviewers were very friendly no pressure.

Q1. 
Nth Fibonacci Number Problem Statement
Calculate the Nth term in the Fibonacci sequence, where the sequence is defined as follows: F(n) = F(n-1) + F(n-2), with initial conditions F(1) = F(2) = 1.
Input:
...read more
Ans. 
Calculate the Nth Fibonacci number efficiently using dynamic programming.
• Use dynamic programming to store previously calculated Fibonacci numbers to avoid redundant calculations.

• Start with base cases F(1) and F(2) as 1, then iterate to calculate subsequent Fibonacci numbers.

• Time complexity can be optimized to O(N) using dynamic programming.

• Example: For N = 5, the 5th Fibonacci number is 5.
Answered by AI
Add your answer

Online coding test with Sql and python questions

Q1. Details about project and experience
Add your answer
Q2. Pyspark and databricks questions
Add your answer
Q3. What is Spark context
Ans. 
Spark context is the main entry point for Spark functionality and represents the connection to a Spark cluster.
• Main entry point for Spark functionality

• Represents connection to a Spark cluster

• Used to create RDDs, broadcast variables, and accumulators
Answered by AI
Add your answer
Q4. What is inheritance
Ans. 
Inheritance is a concept in object-oriented programming where a class can inherit attributes and methods from another class.
• Allows for code reusability by creating a new class based on an existing class

• Derived class inherits properties and behaviors of the base class

• Supports the concept of polymorphism and encapsulation

• Example: Class 'Car' can inherit from class 'Vehicle' and inherit its attributes like 'color' and met
Answered by AI
Add your answer
Q5. What is sparkconfig
Ans. 
SparkConfig is a configuration object used in Apache Spark to set various parameters for Spark applications.
• SparkConfig is used to set properties like application name, master URL, and other Spark settings.

• It is typically created using SparkConf class in Spark applications.

• Example: val sparkConf = new SparkConf().setAppName("MyApp").setMaster("local")
Answered by AI
Add your answer

Q1. Basic mern stack question along with some coding question.
Add your answer

Q1. Same as round one. This one is in bit details.
Add your answer

Q1. Basic hr round. Lot of different aspect they gave.
Add your answer

Q1. 2 sum problem on number
Add your answer

Q1. Json data manipulation
Add your answer

Q1. Normal hr question
Add your answer