Pyramid Solutions Interview Questions and Answers

Q1. What is a class? What is an object
Add your answer
Q2. How do we create objects?
Add your answer
Q3. What is Singleton Design Pattern?
Add your answer
Q4. What is the difference between SQL and NoSQL?
Add your answer
Q5. What are Columnar Databases?
Add your answer
Q6. What is a Pub-Sub model?
Add your answer

All the assignment to improve our self

Case study all knowledge edias

Share the thought process inorpove our self

Html and other project

Q1. All thrcnical kholwleghe
Add your answer
Q2. All types of design
Ans. 
Design encompasses various disciplines such as UI, UX, and graphic design.
• UI design focuses on the user interface and interactions of a digital product.

• UX design focuses on the overall user experience and usability of a product.

• Graphic design involves creating visual content for both digital and print media.

• Each type of design plays a crucial role in creating a cohesive and user-friendly product.

• Examples: UI design for...read more
Answered by AI
Add your answer
Q3. All graphics design idiaas
Add your answer
Q4. All types of the assessment
Add your answer
Q5. And cultural activities
Add your answer

Q1. End to end architecture of current project
Add your answer
Q2. Basic spark code to read & write files
Add your answer
Q3. How to upsert data in table in spark
Add your answer
Q4. How do you handle sudden increase in data volume
Add your answer
Q5. Discussion on delta tables & ACID transactions
Add your answer
Q6. Explain autoloader and use case in Databricks
Add your answer
Q7. SQL question using window functions Lead, row number
Add your answer
Q8. Python question using hashmap & String
Add your answer

Q1. Current project understanding end to end
Add your answer
Q2. Data pipeline design for a ride sharing company, ask bunch of follow up questions on the conclude a particular design.
Add your answer
Q3. Explain how you follow SDLC(Agile, waterfall) ?
Add your answer
Q4. Why are you looking for a change now
Add your answer

Q1. Basic introductions
Add your answer
Q2. What kind of work are you looking for? what do you know about the company
Add your answer
Q3. Willing to relocate?
Add your answer
Q4. Personal hobbies and aspirations
Add your answer

What are the key principal you follow for telerehabilitation

Introduce your self ?

What all techniques and methode do you folow

Q1. What are your hobbies ?
Ans. 
My hobbies include hiking, playing tennis, and cooking new recipes.
• Hiking in local trails and national parks

• Playing tennis at the community courts

• Experimenting with new recipes in the kitchen
Answered by AI
Add your answer
Q2. Tell your work experience
Add your answer

Q1. How do you handle the cases where patietn is not responding properly
Add your answer
Q2. Please explain how do you treate a patient with chronic case ?
Add your answer

Q1. How do you builde rappo with new patient
Add your answer
Q2. What is your overall expericne c
Add your answer

Q1. What do you know about our company
Add your answer

Q1. What is your take on patietn ?
Add your answer

It took total 6 days for interview and revert

General basic assessment.

Q1. They will give you few PDFs to read and then MCQ from that.
Add your answer

Q1. Explain any 1 of your Project.
Add your answer
Q2. SQL: Explain difference between Delete, Truncate and Drop. Difference between Group by and Having. Asked to write a update query.
Add your answer
Q3. Python: Difference between Set and Dictionary. Can we update key in dictionary? Write solution for given python question (nums = [1,2,3,4,5,7,10] target = 9 output = [1,5])
Ans. 
Set is a collection of unique elements, while dictionary is a collection of key-value pairs. Keys in dictionary can be updated.
• Set does not allow duplicate elements, while dictionary allows duplicate values but not duplicate keys.

• Dictionary uses key-value pairs for storing data, while set only stores individual elements.

• Example: Set - {1, 2, 3}, Dictionary - {'a': 1, 'b': 2}

• Yes, keys in dictionary can be updated by ass
Answered by AI
Add your answer

Q1. Explain projects where you have implemented ETL. Difference between aws lambda and aws glue
Add your answer
Q2. Non-Technical questions
Add your answer

Q1. How many EBS can be attached to single EC2
Ans. 
The maximum number of EBS volumes that can be attached to a single EC2 instance is 40.
• Maximum of 40 EBS volumes can be attached to a single EC2 instance

• Each EBS volume can be up to 16 TiB in size

• EBS volumes can be attached and detached while the instance is running
Answered by AI
Add your answer
Q2. Prerequisites for S3 Cross Region Replication
Ans. 
Prerequisites for S3 Cross Region Replication include enabling versioning, configuring IAM roles, and ensuring proper bucket policies.
• Enable versioning on both source and destination buckets

• Configure IAM roles with proper permissions for replication

• Ensure proper bucket policies are in place for cross region replication
Answered by AI
Add your answer
Q3. Docker Restart will change which attributes of comtainer
Ans. 
Docker Restart changes the container's attributes like IP address, hostname, and uptime.
• IP address of the container will change after restart

• Hostname of the container may change

• Uptime of the container will be reset

• Any changes made to the container's filesystem will be lost
Answered by AI
Add your answer
Q4. S3 vs EFS scenario based use cases.
Ans. 
S3 is ideal for storing static files like images and videos, while EFS is better for shared file storage among multiple EC2 instances.
• S3 is object storage, suitable for storing large amounts of unstructured data like images, videos, backups, and logs.

• EFS is a file storage service that can be mounted on multiple EC2 instances, making it ideal for shared file systems and databases.

• Use S3 for static website hosting, data ...read more
Answered by AI
Add your answer
Q5. Linux Commands and Chmod Calculation
Add your answer

It was conducted in hacker earth
Around 1:55hr

Q1. Write a code for encrypting and decryption of character
Ans. 
Code for encrypting and decrypting characters using a simple algorithm
• Use a simple algorithm like shifting the characters by a fixed number of positions in the ASCII table

• For encryption, add the fixed number to the ASCII value of each character

• For decryption, subtract the fixed number from the ASCII value of each character
Answered by AI
Add your answer
Q2. Given a python code find the bugs
Ans. 
Identify bugs in a given Python code
• Check for syntax errors such as missing colons or parentheses

• Look for logical errors in the code that may cause unexpected behavior

• Test edge cases and boundary conditions to ensure code handles all scenarios

• Use debugging tools like print statements or a debugger to trace the flow of the code
Answered by AI
Add your answer