Persistent Systems System Analyst Interview Questions and Answers

Q1. Write a code to create dataframe in adb using struct type
Ans. 
Creating a dataframe in adb using struct type
• Use the 'CREATE TABLE' statement to define the schema of the dataframe

• Define the struct type using 'STRUCT' keyword

• Insert data into the dataframe using 'INSERT INTO' statement
Answered by AI
Add your answer
Q2. Write a code to find max salary department wise and second highest salary department wise
Ans. 
Code to find max and second highest salary department wise
• Iterate through the list of employees and store max and second highest salary for each department

• Use a hashmap to store department wise salaries

• Sort the salaries in descending order to find max and second highest
Answered by AI
Add your answer
Q3. How do you call a variable from one note book to another note book in adb
Ans. 
You can call a variable from one notebook to another in adb by using the %run magic command.
• Use the %run magic command followed by the path to the notebook containing the variable you want to access.

• Make sure the notebook containing the variable is in the same directory or provide the full path.

• Once you run the %run command, the variables from the other notebook will be available in the current notebook.
Answered by AI
Add your answer
Q4. How do you do incremental load in adf
Ans. 
Incremental load in ADF is achieved by using watermark columns to track the last loaded data and only loading new or updated records.
• Use watermark columns to track the last loaded data

• Compare the watermark column value with the source data to identify new or updated records

• Use a filter condition in the source query to only select records with a timestamp greater than the watermark value

• Update the watermark column value
Answered by AI
Add your answer
Q5. What's your project and what does you do in it
Add your answer

Q1. Tell me about your self without going much into technical details of project
Add your answer
Q2. What is the reason for job change
Add your answer
Q3. How fast can you join
Add your answer

Q1. Architecture of Qlik
Ans. 
Qlik architecture is a multi-tiered structure that includes data sources, Qlik Sense servers, and user interfaces.
• Qlik architecture consists of data sources where data is extracted from, such as databases, spreadsheets, and APIs.

• Qlik Sense servers process and store the data, allowing users to access and analyze it through the Qlik Sense platform.

• User interfaces in Qlik allow users to create visualizations, dashboards, ...read more
Answered by AI
Add your answer
Q2. Questions about Visualizations
Add your answer

Q1. Actually their requirement is like looking for Automation engineer who have good knowledge on Python, Selenium. Most of the questions I got from interviewer as like pure Python only which touches basics a...read more
Add your answer

Q1. It was for Client round.They asked like project which we covered for previous company and again questions from Python itself.
Add your answer

Q1. What are your salary expectations?
Add your answer
Q2. Why are you looking for a change?
Add your answer

Working experience Technical issue discussed

Q1. Finacle Techno Funcunal
Add your answer

Q1. What are the types of Load Tests
Ans. 
Types of Load Tests include Stress Testing, Spike Testing, Endurance Testing, and Volume Testing.
• Stress Testing: Evaluates system behavior under extreme conditions to determine breaking points.

• Spike Testing: Tests system response to sudden spikes in load to ensure stability.

• Endurance Testing: Checks system performance over an extended period to identify any issues related to prolonged use.

• Volume Testing: Assesses syste...read more
Answered by AI
Add your answer
Q2. What is failover testing
Ans. 
Failover testing is a type of testing that verifies a system's ability to seamlessly switch to a backup system in case of failure.
• Failover testing ensures that a system can switch to a backup system without any downtime or data loss.

• It involves intentionally causing a failure in the primary system to see if the backup system can take over successfully.

• Common examples include testing a website's ability to switch to a b...read more
Answered by AI
Add your answer

Q1. Solve using Little's Law and calculate Pacing for 200 users doing 20,000 TPH
Ans. 
Little's Law can be used to calculate the pacing for a given number of users and transactions per hour.
• Little's Law states that the average number of users in a system (L) is equal to the average arrival rate (λ) multiplied by the average time a user spends in the system (W). Mathematically, L = λW.

• To calculate pacing, we need to rearrange the formula to solve for W: W = L / λ.

• In this case, we have 200 users and 20,000...read more
Answered by AI
Add your answer

Q1. How DNS works? what happens when you click any link on browser?
Ans. 
DNS translates domain names to IP addresses. When you click a link, browser sends a DNS query to resolve the domain name.
• DNS stands for Domain Name System

• When you click a link, browser sends a DNS query to a DNS server to resolve the domain name to an IP address

• The DNS server then responds with the corresponding IP address

• The browser then uses the IP address to connect to the server hosting the website
Answered by AI
Add your answer

Q1. Data engineering concepts
Add your answer