LTIMindtree Senior Specialist Interview Questions, Process, and Tips

Properties used in Dev Studio include rules, data instances, classes, and application components.

• Rules: Define the behavior of the application, such as flows, activities, and UI rules.

• Data Instances: Store data used by the application, such as data tables and data pages.

• Classes: Define the structure of data and rules in the application.

• Application Components: Include portals, harnesses, sections, and case types.

Auto lookup is a feature that automatically retrieves information based on a specified criteria.

• Auto lookup is commonly used in databases to quickly retrieve related information without manual input.

• It can be used in Excel to automatically fill in data based on a matching value in another table.

• Auto lookup can save time and reduce errors by eliminating the need for manual data entry.

SQL aggregate functions perform calculations on a set of values and return a single value.

• Aggregate functions include SUM, AVG, COUNT, MIN, and MAX

• They are used with the SELECT statement to calculate and return a single value from a group of rows

• Examples: SELECT SUM(sales), AVG(price), COUNT(*), MIN(age), MAX(score) FROM table_name

Some Spark optimization techniques include partitioning, caching, and using appropriate data formats.

• Partitioning data to distribute workload evenly

• Caching frequently accessed data to avoid recomputation

• Using appropriate data formats like Parquet for efficient storage and processing

Repartitioning involves changing the number of partitions in a dataset, while coalesce involves reducing the number of partitions without shuffling data.

• Repartitioning increases or decreases the number of partitions in a dataset, which may involve shuffling data across the cluster.

• Coalesce reduces the number of partitions in a dataset without shuffling data, which can improve performance by minimizing data movement.

• Exa...read more

Dataframe is a distributed collection of data organized into named columns, while RDD is a distributed collection of data organized into partitions.

• Dataframe is higher level abstraction than RDD in Spark.

• Dataframe is immutable and supports SQL queries, while RDD is mutable and does not support SQL queries.

• Dataframe provides optimization through Catalyst optimizer, while RDD does not have built-in optimization.

• Example: ...read more

Stored procedures are precompiled SQL queries stored in a database for reuse.

• Stored procedures are used to encapsulate logic for data manipulation in a database.

• They can accept input parameters and return results.

• Stored procedures can improve performance by reducing network traffic and optimizing query execution.

• Examples include procedures for inserting, updating, or deleting records in a database.