Bi Architect Interview Questions

51 bi 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.

Viewing 21 - 30 interview questions

See Interview Questions for Similar Jobs

Glassdoor has 51 interview questions and reports from Bi architect interviews. Prepare for your interview. Get hired. Love your job.