TCS IT Analyst Interview Questions, Process, and Tips

Q1. What is RLS in PBI
Ans. 
RLS in PBI stands for Row-Level Security in Power BI, a feature that allows users to restrict access to data based on roles or permissions.
• RLS helps control access to data at the row level based on user roles or permissions

• It allows users to see only the data that is relevant to them

• RLS can be implemented using DAX expressions to define filters for each role

• For example, a sales manager may only see data related to thei...read more
Answered by AI
Add your answer
Q2. PBI service roles and their explanation
Add your answer
Q3. What are Joins in sql
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column between them

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Answered by AI
Add your answer
Q4. What is an ssrs
Ans. 
SSRS stands for SQL Server Reporting Services, a server-based report generation software from Microsoft.
• SSRS is a part of Microsoft SQL Server services.

• It allows users to create, manage, and deploy reports to be accessed over the web.

• Reports can be in various formats like PDF, Excel, CSV, etc.

• SSRS can be integrated with other Microsoft products like SharePoint for better collaboration.
Answered by AI
Add your answer
Q5. What is an ssas
Ans. 
SSAS stands for SQL Server Analysis Services, a Microsoft tool used for creating and managing online analytical processing (OLAP) cubes.
• SSAS is a component of Microsoft SQL Server used for data analysis and business intelligence.

• It allows users to create multidimensional data models for analyzing large amounts of data.

• SSAS supports data mining capabilities for discovering patterns and trends in data.

• Examples of SSAS fe...read more
Answered by AI
Add your answer

60 minutes, 90 question. Basic 12th grade maths questions to test your numerical and reasoning skills.

Q1. Basic questions about Cand C++. For e.g., Pointers and functions.
Add your answer
Q2. 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 and promotes the concept of hierarchy

• Derived class inherits properties and behaviors from a base class

• Can have multiple levels of inheritance (e.g. grandparent, parent, child classes)
Answered by AI
Add your answer
Q3. What is Pointer?
Ans. 
A pointer is a variable that stores the memory address of another variable.
• Pointers are used to indirectly access and manipulate data in memory.

• They are commonly used in programming languages like C and C++.

• Example: int *ptr; // declares a pointer variable ptr that can store the memory address of an integer
Answered by AI
Add your answer
Q4. What is Function?
Ans. 
A function is a block of code that performs a specific task when called.
• Functions can take input parameters and return output values.

• Functions help in organizing code and making it reusable.

• Examples include functions to calculate the square root of a number or to sort an array.
Answered by AI
Add your answer

Q1. What is your motivation?
Add your answer
Q2. Why do you want to join TCS?
Add your answer
Q3. What are your strength and weakness?
Add your answer

Q1. Difference between Contribute and Edit
Ans. 
Contribute involves adding new content, while Edit involves making changes to existing content.
• Contribute means to provide new information or material.

• Edit means to make changes or corrections to existing information.

• Contribute adds to the content, while Edit modifies the content.

• Examples: Contribute a new article to a website vs. Edit an existing article for accuracy.
Answered by AI
Add your answer
Q2. External sharing how to enable
Ans. 
External sharing can be enabled through settings in the IT system.
• Navigate to the settings or admin panel of the IT system

• Look for options related to sharing or permissions

• Enable external sharing by selecting the appropriate settings

• Consider setting restrictions or permissions for external users

• Test the external sharing functionality to ensure it works as expected
Answered by AI
Add your answer

JAVa questions and threading , DS

Q1. JAVA CODING and threading
Add your answer