Result for: Ajay Santosh Shinde
Exam Details
Download Result (PDF)Question Analysis
| Sr. No. | Question | Selected Answer | Correct Answer |
|---|---|---|---|
| 1 | Which SQL clause is used to filter the results of an aggregate function? | HAVING | HAVING |
| 2 | Which Window Function finds the 3rd-highest salary, skipping the next rank if duplicates exist? | RANK() | RANK() |
| 3 | What is the difference between DELETE and TRUNCATE? | DELETE can be rolled back | DELETE can be rolled back |
| 4 | What does a 'Bookmark Lookup' in an execution plan indicate? | Optimized query | Missing index columns |
| 5 | Which join returns all rows from the left table and matching rows from the right? | LEFT JOIN | LEFT JOIN |
| 6 | What is the 'SARGability' of a SQL query? | Ability to use an index | Ability to use an index |
| 7 | What is the primary purpose of a 'View' in SQL? | Virtual table for security | Virtual table for security |
| 8 | Which isolation level provides highest consistency but lowest concurrency? | SERIALIZABLE | SERIALIZABLE |
| 9 | What is the purpose of the COALESCE() function? | First non-null value | First non-null value |
| 10 | A 'Clustered Index' in SQL Server determines: | Logical order | Physical order |
| 11 | Normalization is primarily used to: | Minimize redundancy | Minimize redundancy |
| 12 | What does the CROSS APPLY operator do? | Multiplies columns | Join to Table Function |
| 13 | Which operator is used for pattern matching in SQL? | LIKE | LIKE |
| 14 | What is the difference between a CTE and a Temporary Table? | Temp Table no index | CTE for single statement |
| 15 | Which command is used to remove a table structure and its data? | DROP TABLE | DROP TABLE |
| 16 | In SSIS, what does ETL stand for? | Extract, Transform, Load | Extract, Transform, Load |
| 17 | Which of these is a 'Blocking Transformation' in SSIS? | Multicast | Sort |
| 18 | What is the primary purpose of SSAS? | OLAP and Data Mining | OLAP and Data Mining |
| 19 | What is 'Incremental Loading'? | Load only new/changed | Load only new/changed |
| 20 | Which schema is more optimized for BI due to simpler joins? | Star Schema | Star Schema |
| 21 | In SSIS, what do 'Checkpoints' do? | Verify password | Restart from failure |
| 22 | What is a 'Fact Table' in a star schema? | Quantitative measures | Quantitative measures |
| 23 | Which MSBI tool is best for paginated, printable reports? | Excel | SSRS |
| 24 | In SSAS Tabular modeling, 'DAX' stands for: | Data Analysis Expressions | Data Analysis Expressions |
| 25 | What is the purpose of 'Data Mapping' in ETL? | Source to Destination field | Source to Destination field |
| 26 | Which SSIS component performs actions based on a condition? | Precedence Constraints | Precedence Constraints |
| 27 | A 'Slightly Changing Dimension' (Type 2) tracks history by: | Overwriting data | New record per change |
| 28 | In Tableau, what are 'Dimensions'? | Categorical data | Categorical data |
| 29 | What is a 'LOD Expression' in Tableau? | Independent detail level | Independent detail level |
| 30 | Which Excel feature summarizes large datasets without formulas? | Pivot Tables | Pivot Tables |
| 31 | In Tableau, what is a 'Packaged Workbook' (.twbx)? | Design + Data Source | Design + Data Source |
| 32 | Which chart is best for correlation between Spend and Revenue? | Scatter Plot | Scatter Plot |
| 33 | In Excel Power Query, what are 'Applied Steps'? | Transformation sequence | Transformation sequence |
| 34 | What is 'Data Granularity'? | Level of detail per row | Level of detail per row |
| 35 | What is the primary function of VLOOKUP? | Search and return value | Search and return value |
| 36 | In Tableau, what is a 'Live Connection'? | Real-time connection | Real-time connection |
| 37 | Which chart is best for showing a 'Part-to-Whole' relationship? | Gantt Chart | Pie Chart |
| 38 | Which SDLC model relies on frequent stakeholder feedback? | Waterfall | Agile |
| 39 | In Data Analysis, what is an 'Outlier'? | Missing value | Significant difference |
| 40 | What is 'Requirements Gathering'? | Documenting needs | Documenting needs |
| 41 | What is a POC (Proof of Concept)? | Demo to verify theory | Demo to verify theory |
| 42 | Technical Documentation is used for: | Future maintenance | Future maintenance |
| 43 | A 'Functional Specification Document' (FSD) describes: | User perspective intent | User perspective intent |
| 44 | Data 'Integrity' refers to: | Accuracy and reliability | Accuracy and reliability |
| 45 | In an Agile environment, a 'Sprint' is: | Long meeting | Fixed period of work |
| 46 | First step if a dashboard is loading too slowly? | Check SQL query/volume | Check SQL query/volume |
| 47 | How is 'Customer Retention Rate' defined? | % purchased in both periods | % purchased in both periods |
| 48 | Where should a date format fix (DD-MM to YYYY-MM) happen? | ETL Transformation | ETL Transformation |
| 49 | What is 'Critical Thinking' in data analysis? | Question assumptions | Question assumptions |
| 50 | Which step follows 'Data Extraction' in a BI project? | Transformation/Cleaning | Transformation/Cleaning |
Page 1