Add office photos
Engaged Employer

Zensar Technologies

3.7
based on 2.4k Reviews
Filter interviews by

Teleperformance Interview Questions and Answers

Updated 6 Jul 2024
Popular Designations

Q1. Difference between having and where clause

Ans.

Having clause is used with aggregate functions while where clause is used to filter rows

  • Having clause is used with GROUP BY to filter groups based on conditions

  • Where clause is used to filter rows based on conditions

  • Having clause is applied after grouping while where clause is applied before grouping

  • Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 50000

  • Example: SELECT * FROM employees WHERE department = 'IT'

Add your answer

Q2. What are common data connectivity modes?

Ans.

Common data connectivity modes include DirectQuery, Import, Live Connection, and Composite models.

  • DirectQuery allows querying data directly from the data source in real-time.

  • Import mode imports data into Power BI for faster performance but may not reflect real-time data.

  • Live Connection connects Power BI to a data source without importing data.

  • Composite models combine DirectQuery and Import modes for flexibility.

Add your answer

Q3. What is RLS and explain in detail

Ans.

RLS stands for Row-Level Security, a feature in Power BI that restricts data access based on user roles.

  • RLS allows you to control which rows of data a user can access in a Power BI report or dashboard

  • You can define security roles and rules to filter data based on user attributes or roles

  • RLS helps in ensuring data privacy and compliance with regulations

  • For example, you can use RLS to restrict a sales manager to only see data related to their region

Add your answer

Q4. Difference between Power Query and Power view

Ans.

Power Query is used for data transformation and Power View is used for data visualization in Power BI.

  • Power Query is used to extract, transform, and load data from different sources.

  • Power View is used to create interactive visualizations and reports based on the transformed data.

  • Power Query is more focused on data preparation and cleaning, while Power View is focused on data visualization.

  • Power Query can be used to merge, append, and transform data before visualizing it in Po...read more

Add your answer
Discover Teleperformance interview dos and don'ts from real experiences

Q5. Find the 4th highest salary from the SQL table

Ans.

Use SQL query with ORDER BY and LIMIT to find the 4th highest salary

  • Use ORDER BY clause to sort salaries in descending order

  • Use LIMIT 3,1 to skip the first 3 highest salaries and get the 4th highest salary

Add your answer

Q6. What are relationship cardinality

Ans.

Relationship cardinality defines the number of instances of one entity that can be associated with the number of instances of another entity.

  • One-to-One: Each record in the first entity is associated with only one record in the second entity.

  • One-to-Many: Each record in the first entity can be associated with multiple records in the second entity.

  • Many-to-Many: Multiple records in the first entity can be associated with multiple records in the second entity.

Add your answer

Q7. Write Dax for total sales of a product

Ans.

Use SUMX function in DAX to calculate total sales of a product

  • Use SUMX function to iterate over each row in the sales table

  • Filter the table to include only the specific product

  • Sum up the sales amount for each row to get the total sales

Add your answer

Q8. Components of Power BI

Ans.

Power BI components include Power Query, Power Pivot, Power View, and Power Map.

  • Power Query: Used for data extraction, transformation, and loading (ETL)

  • Power Pivot: Used for data modeling and analysis

  • Power View: Used for data visualization and interactive reports

  • Power Map: Used for geospatial data visualization

Add your answer
Contribute & help others!
Write a review
Share interview
Contribute salary
Add office photos

Interview Process at Teleperformance

based on 1 interviews
Interview experience
4.0
Good
View more
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Power BI Developer Interview Questions from Similar Companies

3.8
 • 21 Interview Questions
View all
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
70 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter