Skip to contentSkip to footer

Technical Architect Interview Questions

Salaries
Interviews

21,256 technical architect interview questions shared by candidates

Fictional Fin Client wants to automate and scale customer research using LLMs by simulating “digital persona agents” or synthetic customers. These agents will conduct interviews and respond like real customers to gather insights—saving the hassle of chasing humans for surveys. Your prospective bank client wants to know how you’d go about confirming feasibility, designing, implementing, and measuring success. Key Questions to be Addressed: Confirm the problem's suitability for an LLM-based solution How to structure a comprehensive implementation project How to measure the success of the overall LLM system Feedback loops for continuous improvement
avatar

Principal AI Architect

Interviewed at Zühlke

3.8★
Jun 17, 2025

Fictional Fin Client wants to automate and scale customer research using LLMs by simulating “digital persona agents” or synthetic customers. These agents will conduct interviews and respond like real customers to gather insights—saving the hassle of chasing humans for surveys. Your prospective bank client wants to know how you’d go about confirming feasibility, designing, implementing, and measuring success. Key Questions to be Addressed: Confirm the problem's suitability for an LLM-based solution How to structure a comprehensive implementation project How to measure the success of the overall LLM system Feedback loops for continuous improvement

SQL Assessment Questions: The data model below shows relationships between tables. You will need to understand these tables to develop SQL queries that answer the questions. All columns except Primary Key (PK) columns should be assumed to be nullable. Sample data for each of the tables (Sales, Product, SalesReturnReason) is shown below. A complete set of data is included in the attached Excel Spreadsheet. This spreadsheet data may be imported into your database of choice. Question 1 Write a SQL Query that will return the total amount of sales by product category, for the month of December 2013. • Your query should return 2 columns: ProductCategory, SalesAmount. • Your query should produce a 2-row result set, including the following row and 1 additional row that is not shown: Question 2 Write a SQL Query that returns the total amount of returns for reasons that were our fault (OurFault = “Y”) regardless of whether the items were physically returned (Returned = “Y”) • Your query should return one column: Sales. • Your query should produce a 1-row result set looking like the following: Question 3 Write a SQL Query that will show total sales for the top 4 product subcategories, including ties (see note below) based on 2013 sales. • A NULL ProductSubCategory should be listed as “Unknown”. • In the event of a tie within the top 4, both records should be included. • Your query should return 3 columns: ProductSubCategory, Sales and SalesRank. • Your query should produce a 4-row result set including the following 2 records and 2 additional rows that are not shown: Question 4 Write a SQL Query that will show all transactions where a customer purchased a Hydration Pack (ProductSubCategory = " Hydration Packs") and their previous purchase -- based on TransactionTimestamp -- was a Water Bottle or Cage (ProductSubCategory = "Bottles and Cages"). • Your query should return 6 columns: TransactionID, CustomerName, ProductSubCategory, PriorProductSubCategory, TransactionTimestamp, and SalesAmount. • Your query should produce a 3 row result set that includes these 2-rows and 1 additional row that is not shown: Question 5 Write a SQL Query that will return total sales by product category and year. • Write the SQL query without using a CASE statement • A NULL ProductCategory should be listed as “Unknown”. • Your query should return 4 columns: ProductCategory, 2012, 2013, and 2014. Each of the year columns will show the total sales amount for that year. • Your query should produce a 4-row result set including the 2 rows below, and 2 additional rows that are not shown:
avatar

Big Data Architect

Interviewed at Centric Consulting

3.8★
Jun 22, 2018

SQL Assessment Questions: The data model below shows relationships between tables. You will need to understand these tables to develop SQL queries that answer the questions. All columns except Primary Key (PK) columns should be assumed to be nullable. Sample data for each of the tables (Sales, Product, SalesReturnReason) is shown below. A complete set of data is included in the attached Excel Spreadsheet. This spreadsheet data may be imported into your database of choice. Question 1 Write a SQL Query that will return the total amount of sales by product category, for the month of December 2013. • Your query should return 2 columns: ProductCategory, SalesAmount. • Your query should produce a 2-row result set, including the following row and 1 additional row that is not shown: Question 2 Write a SQL Query that returns the total amount of returns for reasons that were our fault (OurFault = “Y”) regardless of whether the items were physically returned (Returned = “Y”) • Your query should return one column: Sales. • Your query should produce a 1-row result set looking like the following: Question 3 Write a SQL Query that will show total sales for the top 4 product subcategories, including ties (see note below) based on 2013 sales. • A NULL ProductSubCategory should be listed as “Unknown”. • In the event of a tie within the top 4, both records should be included. • Your query should return 3 columns: ProductSubCategory, Sales and SalesRank. • Your query should produce a 4-row result set including the following 2 records and 2 additional rows that are not shown: Question 4 Write a SQL Query that will show all transactions where a customer purchased a Hydration Pack (ProductSubCategory = " Hydration Packs") and their previous purchase -- based on TransactionTimestamp -- was a Water Bottle or Cage (ProductSubCategory = "Bottles and Cages"). • Your query should return 6 columns: TransactionID, CustomerName, ProductSubCategory, PriorProductSubCategory, TransactionTimestamp, and SalesAmount. • Your query should produce a 3 row result set that includes these 2-rows and 1 additional row that is not shown: Question 5 Write a SQL Query that will return total sales by product category and year. • Write the SQL query without using a CASE statement • A NULL ProductCategory should be listed as “Unknown”. • Your query should return 4 columns: ProductCategory, 2012, 2013, and 2014. Each of the year columns will show the total sales amount for that year. • Your query should produce a 4-row result set including the 2 rows below, and 2 additional rows that are not shown:

Viewing 1861 - 1870 interview questions

Glassdoor has 21,256 interview questions and reports from Technical architect interviews. Prepare for your interview. Get hired. Love your job.