Desarrollador De Sql Bi Interview Questions

1,371 desarrollador de sql bi interview questions shared by candidates

Q: What is Query folding, how can we identify whether a query is being folded or not? Q: Create a Calendar Table using DAX, create year, year month column Q: How do you sort the month axis on a visual Q: What are bookmarks? Q: Write a DAX to calculate percentage of total
avatar

Power BI Developer

Interviewed at Genpact

3.7
Oct 3, 2024

Q: What is Query folding, how can we identify whether a query is being folded or not? Q: Create a Calendar Table using DAX, create year, year month column Q: How do you sort the month axis on a visual Q: What are bookmarks? Q: Write a DAX to calculate percentage of total

What is the difference between star and snowflake schemas? Which one would you choose if you have to build a schema? What id the difference between group by and partition by in SQL? Can you describe any query optimization techniques you have used?
avatar

BI Developer

Interviewed at Cognizant

3.6
Dec 21, 2020

What is the difference between star and snowflake schemas? Which one would you choose if you have to build a schema? What id the difference between group by and partition by in SQL? Can you describe any query optimization techniques you have used?

Viewing 1331 - 1340 interview questions

Glassdoor has 1,371 interview questions and reports from Desarrollador de sql bi interviews. Prepare for your interview. Get hired. Love your job.