Virtusa Consulting Services Interview Questions, Process, and Tips

Q1. What is the architecture of Apache Spark?
Ans. 
Apache Spark architecture includes a cluster manager, worker nodes, and driver program.
• Apache Spark architecture consists of a cluster manager, which allocates resources and schedules tasks.

• Worker nodes execute tasks and store data in memory or disk.

• Driver program coordinates tasks and communicates with the cluster manager.

• Spark applications run as independent sets of processes on a cluster, coordinated by the SparkCon...read more
Answered by AI
Add your answer
Q2. What is the difference between the reduceBy and groupBy transformations in Apache Spark?
Ans. 
reduceBy is used to aggregate data based on key, while groupBy is used to group data based on key.
• reduceBy is a transformation that combines the values of each key using an associative function and a neutral 'zero value'.

• groupBy is a transformation that groups the data based on a key and returns a grouped data set.

• reduceBy is more efficient for aggregating data as it reduces the data before shuffling, while groupBy shu...read more
Answered by AI
Add your answer
Q3. What is the difference between RDD (Resilient Distributed Datasets) and DataFrame in Apache Spark?
Ans. 
RDD is a low-level abstraction representing a distributed collection of objects, while DataFrame is a higher-level abstraction representing a distributed collection of data organized into named columns.
• RDD is more suitable for unstructured data and low-level transformations, while DataFrame is more suitable for structured data and high-level abstractions.

• DataFrames provide optimizations like query optimization and code...read more
Answered by AI
Add your answer
Q4. What are the different modes of execution in Apache Spark?
Ans. 
The different modes of execution in Apache Spark include local mode, standalone mode, YARN mode, and Mesos mode.
• Local mode: Spark runs on a single machine with one executor.

• Standalone mode: Spark runs on a cluster managed by a standalone cluster manager.

• YARN mode: Spark runs on a Hadoop cluster using YARN as the resource manager.

• Mesos mode: Spark runs on a Mesos cluster with Mesos as the resource manager.
Answered by AI
Add your answer

Q1. Command to check disk utilisation and health in Hadoop
Ans. 
Use 'hdfs diskbalancer' command to check disk utilisation and health in Hadoop
• Run 'hdfs diskbalancer -report' to get a report on disk utilisation

• Use 'hdfs diskbalancer -plan <path>' to generate a plan for balancing disk usage

• Check the Hadoop logs for any disk health issues
Answered by AI
Add your answer
Q2. Spark Architecture & the significance of each member of spark Architecture
Ans. 
Spark Architecture consists of Driver, Cluster Manager, and Executors. Driver manages the execution of Spark jobs.
• Driver: Manages the execution of Spark jobs, converts user code into tasks, and coordinates with Cluster Manager.

• Cluster Manager: Manages resources across the cluster and allocates resources to Spark applications.

• Executors: Execute tasks assigned by the Driver and store data in memory or disk for further pr...read more
Answered by AI
Add your answer
Q3. Partitioning and bucketing
Add your answer
Q4. Spark optimization techniques
Ans. 
Optimization techniques in Spark improve performance and efficiency of data processing.
• Partitioning data to distribute workload evenly

• Caching frequently accessed data in memory

• Using broadcast variables for small lookup tables

• Avoiding shuffling operations whenever possible

• Tuning memory settings and garbage collection parameters
Answered by AI
Add your answer
Q5. Second highest salary
Ans. 
I am unable to provide this information as it is confidential.
• Confidential information about salaries in previous organizations should not be disclosed.

• It is important to respect the privacy and confidentiality of past employers.

• Discussing specific salary details may not be appropriate in a professional setting.
Answered by AI
Add your answer
Q6. Pivot table creation in SQL from not pivot one
Ans. 
To create a pivot table in SQL from a non-pivot table, you can use the CASE statement with aggregate functions.
• Use the CASE statement to categorize data into columns

• Apply aggregate functions like SUM, COUNT, AVG, etc. to calculate values for each category

• Group the data by the columns you want to pivot on
Answered by AI
Add your answer
Q7. How to create triggers
Ans. 
Creating triggers in a database involves defining the trigger, specifying the event that will activate it, and writing the code to be executed.
• Define the trigger using the CREATE TRIGGER statement

• Specify the event that will activate the trigger (e.g. INSERT, UPDATE, DELETE)

• Write the code or actions to be executed when the trigger is activated

• Test the trigger to ensure it functions as intended
Answered by AI
Add your answer

Q1. All about angular framework and Typescript
Add your answer
Q2. Javascript precoded question
Add your answer

Q1. In this round as well as Angular related question
Add your answer
Q2. Lifecycle hook of angular
Ans. 
Lifecycle hooks in Angular are methods that allow you to tap into the lifecycle of a component or directive.
• Lifecycle hooks include ngOnInit, ngOnChanges, ngDoCheck, ngOnDestroy, etc.

• ngOnInit is used for initialization logic, ngOnChanges is used for reacting to input changes, ngOnDestroy is used for cleanup tasks, etc.

• Example: ngOnInit() { console.log('Component initialized'); }
Answered by AI
Add your answer
Q3. Lazy loading concept
Add your answer

Round 1 and 2 was good

Q1. Previous experience
Add your answer
Q2. Scenario based question on design requirments
Add your answer

Q1. Technical questions on client requirements
Add your answer
Q2. In depth process flow, OSS and BSS in detail
Add your answer

Q1. Availability to join, compensation
Add your answer

Q1. Technical questions on scrum and agile
Add your answer
Q2. Technical questions on SAFE agile
Add your answer

Q1. Situation based question on project management
Add your answer
Q2. Situation based question on scrum master
Add your answer

Q1. Past experiences abd project management
Ans. 
I have extensive experience in project management, including leading cross-functional teams and implementing Agile methodologies.
• Led multiple cross-functional teams to successfully deliver projects on time and within budget

• Implemented Agile methodologies such as Scrum and Kanban to improve team efficiency and productivity

• Utilized tools like Jira and Trello to track project progress and facilitate communication among te
Answered by AI
Add your answer
Q2. Scrum and SAFE question
Add your answer

Basics of Sql Queries and Explain the Queries

Q1. SCD types of in ETL
Ans. 
Slowly Changing Dimensions (SCD) types in ETL refer to how historical data is handled when new data is loaded into a data warehouse.
• Type 1: Overwrite - simply overwrite the existing data with the new data

• Type 2: Add new row - keep all versions of the data in the table

• Type 3: Update - create a new column to store the old value while updating the current value

• Type 4: Hybrid - combination of Type 1 and Type 2 or Type 1 an
Answered by AI
Add your answer
Q2. SQL Queries with some scenario based
Add your answer
Q3. What is mean by index
Ans. 
An index is a data structure that improves the speed of data retrieval operations on a database table.
• Indexes are used to quickly locate data without having to search every row in a database table.

• They are created on columns in a database table to speed up data retrieval operations.

• Examples include primary keys, unique keys, and non-unique keys.
Answered by AI
Add your answer