Interview Questions & Answers Series for BI Developer

Q&A Videos

Author
Trainer: Gurunatha Dogi

Course Content

    • Question 1 - What is ETL Process with example?
    • Question 2 - Difference between control flow and data flow in SSIS?
    • Question 3 - Explain the architecture of SSIS?
    • Question 4 - Explain the types of Perfmon counters for SSIS?
    • Question 5 - Explain the types of Cache Mode in SSIS Lookup component?
    • Question 6 - How to do Error Handling in SSIS.
    • Question 7 - Types of Containers in SSIS.
    • Question 8 - How to do SSIS Package Deployment to SQL Server?
    • Question 9 - What are Transactions?
    • Question 10 - What are Checkpoints?
    • Question 11 : What is Logging in SSIS?
    • Question 11 : What is Logging in SSIS?
    • Question 13 : Difference between Merge and Union All?
    • Question 14 : What is the Data Profiling task?
    • Question 15 : What is Precedence Constraints?
    • Question 16 : What is Merge Join and explain its different types of Joins?
    • Question 17 : Difference between OLTP & OLAP.
    • Question 18 : What is Fact, Dimension, Cube, Star Schema and Snow Flake?
    • Question 19 : How to create a Cube in SSAS?
    • Question 20 : What is SCD?
    • Question 21 :- What is CDC?
    • Question 22 :- What is SSRS, what is Data Region, can embed/display SSRS Reports in any application, File extension and Code behind of SSRS Report.
    • Question 23 :- How to Deploy SSRS reports?
    • Question 24 :- Difference between Tabular and Matrix Report.
    • Question 25 :- What is Page Break in SSRS?
    • Question 26 :- Difference between Drilldown Report & Sub Report.
  • Question 01 :- What are Calculated columns ?
  • Question 02 :- Where can calculated columns be created in Power BI?
  • Question 03 :- What are calculated measures in Power BI?
  • Question 04 :- Where can calculated measures be created in Power BI?
  • Question 05 :- Difference between Calculated Column and Measure in Power BI?
  • Question 06 :- What are M codes in power bi & Where Can You Write Power Query M Code?
  • Question 07 :- What are Parameters in Power BI?
  • Question 08 :- What is Power BI data gateway?
  • Question 09 :- Do we need data gateway for schedule refresh in Power BI?
  • Question 10 :- What is Query Folding in Power BI?
  • Question 11 :- What is the use of Split function in Power BI?
  • Question 12 :- Difference between visual level, page level and report level filters in Power BI?
  • Question 13:- Difference between ALL and ALL EXCEPT functions?
  • Question 14:- What is "What if" parameter in Power BI?
  • Question 15:- How to keep or remove specific rows in Power BI?
  • Question 16:- What is grouping in power bi and how to use it?
  • Question 17:- Difference between Distinct and Values in Power BI?
  • Question 18:-What is DAX and most common DAX functions used?
  • Question 19:- What is Power Query?
  • Question 20:- What are different types of Filters in Power BI Reports?
  • Question 21 :- Difference between sum and sumx in power bi?
  • Question 22 :- Import Query vs Direct Query in power bi?
  • Question 01 :- What is PHP?
  • Question 02 :- Advantages of using PHP?
  • Question 03 :- What are popular frameworks in PHP?
  • Question 04 :- What are popular Content Management System (CMS) in PHP?
  • Question 05 :- What is the difference between "echo" and "print" in PHP?
  • Question 06 :- How a variable is declared in PHP?
  • Question 07 :- What is the difference between $message and $$message?
  • Question 08 :- How to write JavaScript in PHP?
  • Question 09 :- How show JavaScript alert with PHP variable?
  • Question 10 :- What is the difference between JavaScript and PHP?
  • Question 11 :- How to show PHP errors on the same page?
  • Question 12 :- What is the most used method for hashing passwords in PHP?
  • Question 13 :- What are the different types of Array in PHP?
  • Question 14 :- What is the Purpose of @ in PHP?
  • Question 15 :- What are the different types of variables present in PHP?
  • Question 16 :- How does the 'foreach' loop work in PHP?
  • Question 17 :- What is the use of session_start() and session_destroy() function in PHP?
  • Question 18 :- What are the different ways of handling the result set of MySQLi in PHP?
  • Question 19 :- What are magic constants in PHP?
  • Question 20 :- What are the different loops in PHP?
  • Question 21 :- Explain some of the PHP string functions?
  • Question 22 :- How we can define a static function in class and what are uses?
  • Question 23 :- What is the exact difference between explode and implode?
  • Question 24 :- Difference between $_POSTand $_REQUEST?
  • Question 25 :- How we can change the response header?
  • Question 26 :- What are the steps to create a new database using MySQL and PHP?
  • Question 27 :- What is htaccess ? Why do we use it and where?
  • Question 28 :- Whare the constructor and destructor in PHP?
  • Question 29 :- Is multiple inheritance is supported by PHP?
  • Question 30 :- How to increase the execution time of PHP Script?
  • Question 31 :- How to add 301 redirects in PHP?
  • Question 32 :- Difference between include() and require() ?
  • Question 33 :- What is the difference between "==" and "===" in PHP ?
  • Question 34 :- How to register a variable in PHP Session ?
  • Question 35 :- What is the use of imagetypes() function?
  • Question 36 :- Which method is used to check the data type of any variable?
  • Question 37 :- Which method is used to count the total number of rows returned by any query?
  • Question 38 :- Which function you can use to open a file from a folder?
  • Question 39 :- Which function is used to delete a file from a folder?
  • Question 40 :- What is the use of strip_tags() method?
  • Question 41 :- What is a Lambda function in PHP?
  • Question 42 :- What is Overloading and Overriding in PHP?
  • Question 43 :- What is the static variable in function useful for?
  • Question 44 :- How can we define a variable accessible in functions of a PHP script?
  • Question 45 :-How is a constant defined in a PHP script ?

    MySQL Interview Questions and Answers :-

    • Question 1 : Explain Normalization & Denormalization?
    • Question 2 : Explain 1st,2nd and 3rd Normal Form in MYSQL Database Normalization?
    • Question 3 : Primary Key vs Foreign Key?
    • Question 4 : Primary Key vs Candidate Key vs Unique Key?
    • Question 5 : What is a trigger? How you can create a trigger in MYSQL?
    • Question 6 : Explain Transactions and How to Implement it in MYSQL?
    • Question 7 : What is an index? How can an index be declared in MYSQL?
    • Question 8 : What is the view? How can you create and drop view in MYSQL?
    • Question 9 : Explain Inner Join?
    • Question 10 : Explain Left Join?
    • Question 11 : Explain Right Join?
    • Question 12 : Explain Cross Join?
    • Question 13 : MYSQL Union vs Union All?
    • Question 14 : What are MYSQL Aliases?
    • Question 15 : Explain MYSQL Subquery?
    • Question 16 : Blob vs Text data types in MYSQL?
    • Question 17 : CHAR vs VARCHAR data types?
    • Question 18 : What are the differences between InnoDB and MyISAM engines?
    • Question 19 : What are some of the common MYSQL COMMANDS?
    • Question 20 : What are aggregate functions in MYSQL?
    • Question 21: How can ENUM be used in MySQL?
    • Question 22:Explain GRANT Command in MySQL?
    • Question 23:What is the difference between Truncate and Delete?
    • Question 24 :- Explain MySQL Stored Procedures ?
    • Question 25 :- Explain MySQL Stored Function ?
    • Question 26 :- MySQL - Stored Procedures VS Stored Function
    • Question 27 :- What is self-referencing foreign key?
    • Question 28 :- What is the difference between the LIKE and REGEXP Operators?
    • Question 29 :- How does query cache work in MySQL?

10 Lessons

03 Hours

World-class training and development programs developed by top teachers

Whats Included

  • World-class training teacher
  • Bench has zero learning curve
  • We handle the rest.