Loylty Rewardz Mngt Senior Manager Interview Questions and Answers

Q1. Difference between Lookup and join, where we should use which one in Ab Initio.
Add your answer
Q2. Ab Initio Scenerio Based questions.
Add your answer
Q3. Delete files with 0KB size from a directory. (Unix)
Ans. 
Use find command to locate files with 0KB size and delete them using the rm command.
• Use find command with -size 0 option to locate files with 0KB size in a directory

• Pipe the output of find command to rm command to delete the files

• Example: find /path/to/directory -type f -size 0 -exec rm {} \;
Answered by AI
Add your answer
Q4. Delete 10 days older files. (unix)
Ans. 
Use find command with -mtime option to delete files older than 10 days.
• Use find command with -mtime option to search for files older than 10 days.

• Combine find command with -delete option to delete the files found.
Answered by AI
Add your answer
Q5. Get the second highest salary. (SQL)
Add your answer

Q1. Ab initio scenerio based questions. Question on the project.
Add your answer
Q2. Questions based on different components like Roll up, scan, reformat, join, etc. (Ab Initio)
Add your answer
Q3. Questions based on sed, awk, and grep commands. (UNIX)
Add your answer
Q4. Questions on Window function. (SQL)
Add your answer

Q1. In-depth discussion on project. Components used there and the process of the graph.
Add your answer
Q2. Questions on Continuous Flow, conduct>IT.
Add your answer
Q3. Full working of different partition components, multifiles, checkpoints and phases.
Ans. 
Partition components, multifiles, checkpoints, and phases in data processing.
• Partition components refer to dividing data into smaller chunks for processing efficiency.

• Multifiles are multiple files used to store data during processing.

• Checkpoints are markers set during processing to save progress and enable restart from a specific point.

• Phases represent different stages of data processing workflow.

• Example: In a MapReduc...read more
Answered by AI
Add your answer
Q4. Why not to use lookup for join, where we can not use join. Disadvantage of using sort component.
Ans. 
Using lookup for join can be inefficient and lead to performance issues. Sort component can be slow and resource-intensive.
• Lookup for join can be inefficient for large datasets as it requires scanning the entire dataset for each lookup value.

• Join is more optimized for joining datasets based on a common key, while lookup is better suited for smaller reference tables.

• Sort component can be slow and resource-intensive, esp...read more
Answered by AI
Add your answer

Q1. Why you want to join Exusia. Reason for the job change.
Add your answer
Q2. Salary expectations and document submission.
Add your answer

Q1. About the project. and asked what i did in project. how to create schema in pyspark. what is ADE. what are the difficulties i faced in project. what is spark submit command how we write sparksubmit command...read more
Add your answer
Q2. No of occurrences of letter in a string.
Ans. 
Count occurrences of a letter in a string.
• Iterate through each character in the string and count occurrences of the specified letter.

• Use a hashmap to store the count of each letter.

• Handle both uppercase and lowercase letters to ensure accurate counting.
Answered by AI
Add your answer

Q1. 30 minutes of discussion.
Add your answer

Q1. 75 minutes of discussion
Add your answer

Q1. Process of accounting in Tally
Ans. 
Accounting in Tally involves recording financial transactions, generating reports, and managing accounts.
• Recording financial transactions such as sales, purchases, payments, and receipts

• Generating financial statements like balance sheet, profit and loss statement

• Managing accounts receivable and accounts payable

• Creating and maintaining ledgers for different accounts

• Reconciling bank statements with Tally entries

• Generatin...read more
Answered by AI
Add your answer
Q2. What is Accounts payable
Ans. 
Accounts payable is the amount of money a company owes to its suppliers or vendors for goods or services purchased on credit.
• Accounts payable is a liability on the balance sheet

• It represents the amount owed by the company to its creditors

• It is typically recorded when goods or services are received but payment has not yet been made

• Examples include invoices from suppliers for inventory purchases or services rendered
Answered by AI
Add your answer

Q1. Data structure question asked
Add your answer

Group discussion is very important thing.

Q1. HR round is very easy.
Add your answer
Q2. Just hard and smart work for.
Add your answer
Q3. What is requirement.
Ans. 
A requirement is a specific need or expectation that must be met in order to achieve a desired outcome.
• A requirement is a statement of what a product or service must do or how it must perform.

• Requirements can be functional (what the product must do) or non-functional (how well it must do it).

• Requirements should be clear, concise, and measurable.

• Examples of requirements include: the ability to save and retrieve data, a ...read more
Answered by AI
Add your answer
Q4. What is your strength.
Ans. 
My strength is problem-solving and analytical thinking.
• I have a strong ability to analyze complex problems and break them down into manageable components.

• I excel at finding innovative solutions and thinking outside the box.

• I am skilled in debugging and troubleshooting software issues.

• I have a solid understanding of algorithms and data structures.

• I am experienced in optimizing code for performance and efficiency.
Answered by AI
Add your answer
Q5. What is your weekness.
Ans. 
My weakness is that I tend to be too detail-oriented, which can sometimes slow down my progress.
• I have a tendency to get caught up in the small details and can spend too much time on them.

• I often find myself double-checking my work to ensure accuracy.

• I sometimes struggle with prioritizing tasks because I want to make sure everything is perfect.

• I am actively working on improving my time management skills to balance atte
Answered by AI
Add your answer

Q1. What storage arrays have you worked on?
Ans. 
I have worked on various storage arrays including EMC VNX, NetApp FAS, and Dell EMC Unity.
• EMC VNX

• NetApp FAS

• Dell EMC Unity
Answered by AI
Add your answer
Q2. How to perform a test activity on remote site
Ans. 
Performing a test activity on a remote site
• Ensure proper communication channels are established

• Define clear objectives and scope of the test

• Select appropriate tools and equipment for the test

• Conduct a pre-test site survey to identify potential issues

• Execute the test plan and document results

• Analyze the results and report findings to stakeholders
Answered by AI
Add your answer
Q3. Data protection methods
Add your answer

Q1. Architecture of storages
Ans. 
Storages can be classified into three types: direct-attached, network-attached, and storage area networks.
• Direct-attached storage (DAS) is directly connected to a server or computer, such as a hard drive or USB drive.

• Network-attached storage (NAS) is a file-level storage connected to a network, allowing multiple users to access the same data simultaneously.

• Storage area networks (SAN) are block-level storage connected t...read more
Answered by AI
Add your answer
Q2. Replication types and basic task procedures.
Ans. 
Replication types include snapshot, transactional, and merge. Basic task procedures involve setting up publications and subscriptions.
• Snapshot replication copies a snapshot of the entire database to the subscriber

• Transactional replication copies only the changes made to the database since the last replication

• Merge replication allows for bidirectional synchronization of data

• Setting up publications involves selecting the...read more
Answered by AI
Add your answer
Q3. Tiering, brocade zoning, errors terminolgies
Add your answer

Q1. There was simple DSA question ,
Add your answer