Ishttaa TechCraft Interview Questions, Process, and Tips

Sum is a function used to calculate the total of a set of values, while sum x is a specific value being summed.

• Sum calculates the total of a set of values, while sum x is a specific value being summed.

• Sum is used with a range of values, like sum(A1:A10), while sum x is used with a single value, like sum x = 10.

• Sum x is often used in mathematical equations to represent a specific value being summed.

DAX stands for Data Analysis Expressions and is a formula language used in Power BI, Excel, and Analysis Services.

• DAX is used to create custom calculations, measures, and columns in Power BI and Excel.

• It allows for complex calculations and aggregations on data.

• DAX functions can be used to manipulate data and perform calculations like SUM, AVERAGE, and CALCULATE.

• DAX is optimized for querying large datasets and can impro...read more

Row context filter is a filter applied to individual rows of data in a table or dataset.

• Row context filter is used to filter data at the row level in Power BI or other BI tools.

• It allows for filtering specific rows based on certain criteria or conditions.

• For example, you can apply a row context filter to only show sales data for a specific product category.

Power Query is used for data transformation and loading, while DAX is a formula language for creating calculated columns and measures in Power BI.

• Power Query is used for data transformation and loading from various sources.

• DAX is a formula language used for creating calculated columns and measures in Power BI.

• Power Query is more focused on data preparation and shaping, while DAX is used for calculations and analysis.

• Po...read more

Power BI offers powerful data visualization capabilities but may have limitations in handling large datasets.

• Advantages: user-friendly interface, wide range of data connectors, interactive dashboards

• Disadvantages: limitations in handling large datasets, requires a good understanding of data modeling

• Example: Power BI allows users to easily create interactive reports and dashboards by connecting to various data sources s

The default value of int is 0.

• int is a value type in C#

• If a variable of type int is not initialized, it will have a default value of 0

• This default value is assigned by the compiler

To improve SQL query performance, optimize indexes, use proper data types, and avoid using SELECT *.

• Optimize indexes by creating indexes on columns used in WHERE, JOIN, and ORDER BY clauses.

• Use proper data types to reduce storage space and improve query execution time.

• Avoid using SELECT * and instead specify only the necessary columns to reduce data retrieval time.

• Use stored procedures and parameterized queries to redu...read more

Action methods are methods in ASP.NET MVC that handle HTTP requests and return responses.

• Action methods are defined in controllers.

• They can be public or non-public.

• They can return different types of results such as ViewResult, JsonResult, and PartialViewResult.

• They can have parameters that are bound from the request data.

• They can have attributes that specify HTTP verbs, caching, authentication, and authorization.

• Exampl...read more

Lack of growth opportunities and limited exposure to new technologies.

• Limited career growth prospects in the current organization.

• Lack of opportunities to work on new and challenging projects.

• Limited exposure to the latest technologies and tools.

• Desire to work in a more dynamic and innovative environment.

• Seeking better learning and development opportunities.