Skip to contentSkip to footer

Lead Solution Architect Interview Questions

Salaries
Interviews

4,364 lead solution architect interview questions shared by candidates

Difference between SQL and NO SQL Difference Between Data Lake and Date Warehousing Difference Between Database and Data Warehousing Difference between OLTP and OLAP Whats caching in database Different types of RAID and what are the differences Whats IP address and different Class within osi model What is encryption and what is pgp encryption symmetric vs asymmetric encryption Whats complier and interpreter What’s parallelism What is encryption and what is pgp encryption? symmetric vs asymmetric encryption Tell me a time where you took more time so that you can provide better result Time where you developed any algorithms Your understanding of solutions architect and how you think you are fit for it Virtual Interview: Can you explain the difference between RDBMS and Data-Warehouse What data structure is used for indexing in SQL Write a query to get a Max salary of employees within each Department. Using Employees and Department table. When do we use no-sql vs SQL Explain a time where you received a feedback from customer and how did you take it. Give me an example of a time you were able to deliver an important project under a tight deadline? Did you have to make any sacrifices to meet this deadline? You made a bad professional decision. What was its impact, and what did you learn? Can you describe a difficult interaction you’ve had with a customer? How did you deal with it? Thinking back, what would you do differently? Tell me a time when you didn’t expect an issue and how did you overcome it. Why would some businesses use Cloud services as opposed to on-premises computing Can you tell me about a time when you made an important business decision without consulting your manager? What was the situation and how did it turn out? Why amazon solutions architect What’s the coolest thing that you’ve learned on your own that you’ve then been able to apply in your job and to further perform your job? Build a sample Netflix database with important dimensions and facts. Can you get the most-watched movie by a unique customer from the above. Tell me about a time when you not only met a goal but considerably exceeded expectations? How were you able to do this? you failed to manage your project well and complete something on time. You considerably exceeded expectations. What enabled you to do this?
avatar

Amazon Solutions Architect - Data Lab

Interviewed at Amazon

3.5★
May 3, 2022

Difference between SQL and NO SQL Difference Between Data Lake and Date Warehousing Difference Between Database and Data Warehousing Difference between OLTP and OLAP Whats caching in database Different types of RAID and what are the differences Whats IP address and different Class within osi model What is encryption and what is pgp encryption symmetric vs asymmetric encryption Whats complier and interpreter What’s parallelism What is encryption and what is pgp encryption? symmetric vs asymmetric encryption Tell me a time where you took more time so that you can provide better result Time where you developed any algorithms Your understanding of solutions architect and how you think you are fit for it Virtual Interview: Can you explain the difference between RDBMS and Data-Warehouse What data structure is used for indexing in SQL Write a query to get a Max salary of employees within each Department. Using Employees and Department table. When do we use no-sql vs SQL Explain a time where you received a feedback from customer and how did you take it. Give me an example of a time you were able to deliver an important project under a tight deadline? Did you have to make any sacrifices to meet this deadline? You made a bad professional decision. What was its impact, and what did you learn? Can you describe a difficult interaction you’ve had with a customer? How did you deal with it? Thinking back, what would you do differently? Tell me a time when you didn’t expect an issue and how did you overcome it. Why would some businesses use Cloud services as opposed to on-premises computing Can you tell me about a time when you made an important business decision without consulting your manager? What was the situation and how did it turn out? Why amazon solutions architect What’s the coolest thing that you’ve learned on your own that you’ve then been able to apply in your job and to further perform your job? Build a sample Netflix database with important dimensions and facts. Can you get the most-watched movie by a unique customer from the above. Tell me about a time when you not only met a goal but considerably exceeded expectations? How were you able to do this? you failed to manage your project well and complete something on time. You considerably exceeded expectations. What enabled you to do this?

Recruiter screen: • RDBMS vs NOSQL, benefits, usage • what is a 3-tier app • describe RTO and RPO Arch interview • explain a VM vs containers • Explain CICD • Something about topography • what are my main strengths • cc availability vs durability Panel questions: • name a time improved something at work, how did it. * tell a time got rough feedback * A time a team member did not perform duties * Design considerations for high distributed systems *3-tier applications * single point of failure * Database UI * Monolith vs microservices * RTO and RPO * tiered storage * leverage contanerization in apps *load balancing in apps * running a website, user complains it is slow, I am a consultant, what do I advise? * ecommerce site wants to select a new database, compare RDBMS to NOSQL, * New product, social networking platform, opinion and sentiment data ... what solution *what is CICD *when met a foal and exceeded expectations, how did I do it, what were challenges *tell time I made a bad decision * snowflake instead of Redshift *tell about a time did not meet a promised timeline * time made an important decision, did I move forward or gather more information *tell about a time I sacrificed short term gain to add value int the long run * something significant I did outside my area of expertise * tell time dug deep to get to the root cause * top 3 data challenges, what are they? * ETL vs ELT etc *Many questions about ETL vendors
avatar

Senior Solutions Architect

Interviewed at Amazon

3.5★
May 25, 2022

Recruiter screen: • RDBMS vs NOSQL, benefits, usage • what is a 3-tier app • describe RTO and RPO Arch interview • explain a VM vs containers • Explain CICD • Something about topography • what are my main strengths • cc availability vs durability Panel questions: • name a time improved something at work, how did it. * tell a time got rough feedback * A time a team member did not perform duties * Design considerations for high distributed systems *3-tier applications * single point of failure * Database UI * Monolith vs microservices * RTO and RPO * tiered storage * leverage contanerization in apps *load balancing in apps * running a website, user complains it is slow, I am a consultant, what do I advise? * ecommerce site wants to select a new database, compare RDBMS to NOSQL, * New product, social networking platform, opinion and sentiment data ... what solution *what is CICD *when met a foal and exceeded expectations, how did I do it, what were challenges *tell time I made a bad decision * snowflake instead of Redshift *tell about a time did not meet a promised timeline * time made an important decision, did I move forward or gather more information *tell about a time I sacrificed short term gain to add value int the long run * something significant I did outside my area of expertise * tell time dug deep to get to the root cause * top 3 data challenges, what are they? * ETL vs ELT etc *Many questions about ETL vendors

Viewing 4091 - 4100 interview questions

See Interview Questions for Similar Jobs

Hybris Developer

Glassdoor has 4,364 interview questions and reports from Lead solution architect interviews. Prepare for your interview. Get hired. Love your job.