Trigent Software Power BI Developer Interview Questions and Answers

Q1. How the ssas cube is refreshed?
Ans. 
SSAS cubes can be refreshed using SQL Server Agent jobs, XMLA scripts, or manually through SQL Server Management Studio.
• SSAS cubes can be refreshed using SQL Server Agent jobs scheduled at specific intervals.

• XMLA scripts can be used to automate the process of refreshing SSAS cubes.

• Manual refreshing of SSAS cubes can be done through SQL Server Management Studio by processing the cube.

• Refreshing can also be triggered pro...read more
Answered by AI
Add your answer
Q2. Digg bw join and inner join?
Ans. 
The main difference between a join and an inner join is that a join returns all rows when there is at least one match in both tables, while an inner join returns only the rows with matching values in both tables.
• Join returns all rows from both tables when there is a match, while inner join returns only the rows with matching values in both tables

• Inner join is the default type of join in SQL

• Inner join is more commonly u
Answered by AI
Add your answer

Case study was being given for the hr department report and the problem statement