Lead Data Architect Interview Questions

12,910 lead data architect interview questions shared by candidates

01. How to analyse the Execution Tree of a Query Plan. 02. What are the ideal performance conditions to be taken care with logical reads & physical reads. 03. What are filtered indexes. What are advantages & disadvantages associated with it. 04. What is the prominence of cross apply while using Scalar values and Table valued functions. 05. What are the disadvantages associated with Common Table Expressions. 06. What do you know about the column stored indexes.
avatar

BI Architect

Interviewed at HCLTech

3.5
May 5, 2015

01. How to analyse the Execution Tree of a Query Plan. 02. What are the ideal performance conditions to be taken care with logical reads & physical reads. 03. What are filtered indexes. What are advantages & disadvantages associated with it. 04. What is the prominence of cross apply while using Scalar values and Table valued functions. 05. What are the disadvantages associated with Common Table Expressions. 06. What do you know about the column stored indexes.

Couple of phone rounds, an onsite interview and final stage HR round. The interview panel was highly technical and I had to face quite a few subject matter experts, questions related network security, hands on experience, CCIE level.
avatar

Security Architect

Interviewed at Smart IMS

4.6
Mar 25, 2019

Couple of phone rounds, an onsite interview and final stage HR round. The interview panel was highly technical and I had to face quite a few subject matter experts, questions related network security, hands on experience, CCIE level.

Previous experience, technical engineering questions. Data processing using Hadoop, spark - differences. Real time processing related tools and evaluation. Architecture patterns on cloud, parallel processing platforms, columnar databases. Scenario related questions.
avatar

Solutions Architect

Interviewed at HCLTech

3.5
Aug 17, 2017

Previous experience, technical engineering questions. Data processing using Hadoop, spark - differences. Real time processing related tools and evaluation. Architecture patterns on cloud, parallel processing platforms, columnar databases. Scenario related questions.

Viewing 8281 - 8290 interview questions

See Interview Questions for Similar Jobs

Glassdoor has 12,910 interview questions and reports from Lead data architect interviews. Prepare for your interview. Get hired. Love your job.