London Stock Exchange Group Interview Questions and Answers

Q1. How do you load data from JSON?
Ans. 
Data can be loaded from JSON using Snowflake's COPY INTO command.
• Use the COPY INTO command in Snowflake to load data from JSON files.

• Specify the file format as JSON in the COPY INTO command.

• Map the JSON attributes to the columns in the target table.

• Example: COPY INTO target_table FROM 's3://bucket_name/file.json' FILE_FORMAT = (TYPE = 'JSON');
Answered by AI
Add your answer
Q2. What are the performance tuning options in snowflake?
Ans. 
Performance tuning options in Snowflake include clustering, materialized views, query profiling, and resource monitoring.
• Use clustering keys to organize data for faster query performance

• Create materialized views to pre-aggregate data and improve query speed

• Utilize query profiling to identify and optimize slow queries

• Monitor resource usage to ensure efficient query execution
Answered by AI
Add your answer
Q3. How do you configure snowpipe?
Ans. 
Snowpipe is configured using a Snowflake account, specifying the source data location and the target table.
• Configure a stage in Snowflake to specify the source data location.

• Create a pipe in Snowflake to define the target table and the stage.

• Set up notifications for the pipe to trigger loading data automatically.

• Monitor the pipe for any errors or issues in data loading.

• Example: CREATE STAGE my_stage URL = 's3://my_buck...read more
Answered by AI
Add your answer
Q4. Data modelling techniques used
Ans. 
Various data modelling techniques like dimensional modelling, ER modelling, and data vault are used.
• Dimensional modelling is used for data warehousing and involves organizing data into facts and dimensions.

• ER modelling is used to visualize the data relationships in an entity-relationship diagram.

• Data vault modelling is used for agile data warehousing and involves creating a flexible and scalable data model.
Answered by AI
Add your answer
Q5. Streans in snowflake
Ans. 
Streams in Snowflake are used to continuously replicate data from a table to another destination in real-time.
• Streams capture changes made to a table, such as inserts, updates, and deletes.

• They can be used to track changes and replicate data to other tables or external systems.

• Streams are created on a specific table and can be monitored for changes using SQL commands.
Answered by AI
Add your answer

I was assigned a task to create a questionnaire consisting of five questions. I need to code, build, and provide instructions on how to use it.

Q1. Questions on current project, core skills mainly on Jenkins, CI/CD, testing, SRE principles, monitoring, python coding.
Add your answer
Q2. Why you want to join LSEG?
Ans. 
I want to join LSEG because of its reputation for innovation and growth in the financial industry.
• LSEG is a leading global financial markets infrastructure provider

• Opportunity to work with cutting-edge technology and contribute to innovative projects

• Desire to be part of a dynamic and collaborative team environment

• Excited about the potential for career growth and development at LSEG
Answered by AI
Add your answer
Q3. What value can you bring in current team?
Ans. 
I can bring strong leadership skills, technical expertise, and a collaborative approach to the team.
• Strong leadership skills to guide and motivate team members

• Technical expertise to provide guidance and support on development tasks

• Collaborative approach to foster teamwork and communication within the team
Answered by AI
Add your answer

Q1. Discussions with the Director regarding scenario-based questions, such as how to handle a project in the event of an incident, and how to tackle and overcome such challenges?
Add your answer

Round 1 was aptitude round, it consisted of java and c++ snippets and we had to guess the output. Apart from that there were problems on speed, velocity, distance and time. Problems on word-letter patterns were also asked. The aptitude round had 30 questions and time given was 30 minutes.

Aptitude round was the only elimination round. The next following 4 rounds were non-elimination rounds. Coding test included 3 questions - 1 and half hour was given to solve the same. It is fine if you don't perform well here, since it is a non-elimination round. But try to solve 1 and half or 2 questions atleast. The questions were mainly based on 1d arrays, 2D arrays, strings and string arrays.

Q1. Introduce yourself.
Ans. 
I am a recent graduate with a degree in engineering, eager to learn and grow in the field.
• Recent graduate with a degree in engineering

• Passionate about learning and growing in the field

• Eager to apply theoretical knowledge to practical projects
Answered by AI
Add your answer
Q2. Difference between Structure and object oriented languages
Ans. 
Structure languages focus on procedures and functions, while object-oriented languages focus on objects and classes.
• Structure languages use functions and procedures to manipulate data

• Object-oriented languages use objects and classes to encapsulate data and behavior

• Structure languages are more procedural in nature, while object-oriented languages are more modular and reusable

• Examples of structure languages include C and...read more
Answered by AI
Add your answer
Q3. Explain of OOPS concepts and their real life examples.
Ans. 
OOPS concepts are fundamental to object-oriented programming and include inheritance, encapsulation, polymorphism, and abstraction.
• Inheritance: A child class inherits properties and behaviors from a parent class. Example: Animal class can be a parent class with child classes like Dog and Cat inheriting its attributes.

• Encapsulation: Bundling data and methods that operate on the data into a single unit. Example: A car ob...read more
Answered by AI
Add your answer
Q4. What is static keyword and it's usage.
Ans. 
The static keyword in programming is used to declare variables, functions, or classes that retain their values or state throughout the program's execution.
• Static variables retain their values between function calls

• Static functions can only be accessed within the same file

• Static classes cannot be instantiated and have limited visibility

• Static keyword can also be used in C++ to declare class members shared among all inst...read more
Answered by AI
Add your answer
Q5. System architecture diagram for web application project.
Ans. 
The system architecture diagram for a web application project visually represents the components and their interactions.
• Include components like client-side interface, server-side application, database, and external services

• Show how these components communicate with each other

• Consider scalability, security, and performance in the design

• Use standard symbols and notations for clarity
Answered by AI
Add your answer
Q6. Access Modifiers in java
Ans. 
Access modifiers in Java control the visibility of classes, methods, and variables.
• There are four types of access modifiers in Java: public, private, protected, and default.

• Public: accessible from any other class.

• Private: only accessible within the same class.

• Protected: accessible within the same package and subclasses.

• Default: accessible only within the same package.

• Example: public class MyClass { private int myVar; p...read more
Answered by AI
Add your answer
Q7. What OOPS concepts are implemented in my project
Ans. 
Encapsulation, Inheritance, Polymorphism, Abstraction
• Encapsulation: Data hiding and bundling of data with methods. Example: Using private variables and public methods.

• Inheritance: Reusing code and creating a hierarchy of classes. Example: Subclass inheriting properties and methods from a superclass.

• Polymorphism: Ability to present the same interface for different data types. Example: Method overloading and overriding.

• A...read more
Answered by AI
Add your answer
Q8. DBMS core concepts
Add your answer
Q9. Overloading and Overriding
Add your answer
Q10. Approach to the coding questions asked in coding round.
Ans. 
A systematic approach to coding questions ensures clarity, efficiency, and accuracy in problem-solving during interviews.
• Understand the problem: Read the question carefully and clarify any doubts.

• Break it down: Divide the problem into smaller, manageable parts.

• Plan your solution: Outline the algorithm or steps before coding.

• Write clean code: Use meaningful variable names and maintain proper formatting.

• Test your solutio...read more
Answered by AI
Add your answer
Q11. Questions on what is cloud and what are some cloud platforms you know?
Add your answer

A project is assigned to a group of students and we need to come up with an idea on how to implement that project as a team.

Q1. Introduce yourself
Ans. 
I am a recent graduate with a degree in engineering, eager to learn and grow in the field.
• Recent graduate with a degree in engineering

• Passionate about learning and growing in the field

• Eager to apply theoretical knowledge to practical projects
Answered by AI
Add your answer
Q2. Family background
Add your answer

Q1. What is shares and kind of shares
Ans. 
Shares represent ownership in a company and can be classified into different types such as common shares and preferred shares.
• Shares represent ownership in a company

• Common shares give voting rights to shareholders

• Preferred shares have priority in receiving dividends

• Other types include treasury shares and bonus shares
Answered by AI
Add your answer
Q2. Name different stock exchange internationally
Ans. 
Some of the major international stock exchanges include NYSE, NASDAQ, LSE, TSX, and HKEX.
• NYSE - New York Stock Exchange

• NASDAQ - National Association of Securities Dealers Automated Quotations

• LSE - London Stock Exchange

• TSX - Toronto Stock Exchange

• HKEX - Hong Kong Stock Exchange
Answered by AI
Add your answer