TKM Group Senior Consultant Interview Questions and Answers

Q1. Sql related questions were askwd
Add your answer
Q2. Adf related questions were asked
Add your answer

Q1. Ci cd questions were asked
Add your answer
Q2. Team work related questions were asked
Add your answer

Q1. Fitment round with location
Add your answer

You have list of Integers, say {1,43,54,35,35,54} With this I want to know the count of each digits in the List. Example 1->1,3->3,4->3,5->4

Q1. How to get the last row of any SAS dataset
Ans. 
Use the OBS option in a SET statement to read the last observation of a SAS dataset.
• Use the OBS option in a SET statement followed by the keyword 'END' to read the last observation of a SAS dataset.

• For example, to read the last observation of a dataset named 'mydata', use the following code: data lastobs; set mydata(obs=last end=last); run;
Answered by AI
Add your answer

Q1. Critical thinking and analytical skills
Add your answer
Q2. Prompt answering skills
Add your answer

Q1. What is default value of map
Ans. 
The default value of a map in most programming languages is null or an empty map.
• Default value of map in Java is null

• Default value of map in Python is an empty map {}

• Default value of map in C++ is an empty map std::map<>()
Answered by AI
Add your answer
Q2. How does move work internally
Add your answer

Q1. Questions on strings: count character and their frequency
Add your answer
Q2. What is virtual keyword and how virtual functions work internally
Ans. 
The virtual keyword in C++ is used to declare a member function that can be overridden in a derived class. Virtual functions are resolved at runtime.
• Virtual keyword is used to achieve runtime polymorphism in C++

• Virtual functions are resolved at runtime based on the actual object type

• Virtual functions are implemented using virtual function tables (vtables)

• Derived classes can override virtual functions to provide specifi
Answered by AI
Add your answer

Q1. JWT TOKEN Explanation on security
Ans. 
JWT token is a secure way to transmit information between parties as a JSON object.
• JWT stands for JSON Web Token

• It is a compact, URL-safe means of representing claims to be transferred between two parties

• It consists of three parts: header, payload, and signature

• The header contains the type of token and the signing algorithm used

• The payload contains the claims or statements about the user and additional data

• The signatur...read more
Answered by AI
Add your answer
Q2. Recently found vulnerability
Ans. 
A recently found vulnerability in a system
• The vulnerability was discovered during a security audit

• It allows unauthorized access to sensitive data

• The vulnerability can be exploited remotely

• A patch or fix should be implemented immediately
Answered by AI
Add your answer

Online exam, half hour

Q1. About your self
Add your answer
Q2. About your last company
Add your answer

Q1. DAX Question related to Filter and Time Intelligence function
Add your answer
Q2. Power BI Service features such as Gateways, RLS, Schedule Refresh
Add your answer
Q3. Introduction and Current Role Project
Add your answer
Q4. Power BI desktop features such as Tooltip, Drill Through filter, Bookmarks etc
Add your answer

Q1. Incremental Refresh
Add your answer
Q2. DAX questions related to Filter, Relationship, Table Manipulation, and Time Intelligence functions
Add your answer
Q3. Power BI Services features
Ans. 
Power BI Services features include data visualization, interactive reports, dashboards, and data connectivity.
• Data visualization tools like charts, graphs, and maps

• Interactive reports for exploring data and gaining insights

• Dashboards for monitoring key metrics and KPIs

• Data connectivity to various sources like Excel, SQL databases, and cloud services
Answered by AI
Add your answer
Q4. SQL Interview Questions
Add your answer
Q5. Introduction and Current Role Project
Add your answer

Q1. Data Modeling Questions
Add your answer
Q2. Data Warehousing Concepts such as SCD, Dimension and Fact Tables
Add your answer
Q3. Scenario Question related to BI tool such as Why you would consider this tool and How is it different from other BI Tools
Add your answer
Q4. Why are you leaving your last Organisation
Ans. 
Seeking new challenges and growth opportunities in a different environment.
• Desire for career advancement

• Looking for new challenges

• Seeking a change in work environment

• Opportunity to learn and grow in a different setting
Answered by AI
Add your answer
Q5. Current role in the Project and ofcourse Introduction was in the first.
Add your answer