TCS Senior Microstrategy Developer Interview Questions, Process, and Tips

Creating and activating OData involves defining data models and enabling services in SAP Gateway.

• Define data model using transaction code SEGW in SAP Gateway

• Create entity types, entity sets, and associations in the data model

• Implement service provider class and define CRUD operations for entities

• Activate OData service using transaction code /IWFND/MAINT_SERVICE

• Assign the service to a system alias and publish the servic

TMG is a Microsoft Forefront Threat Management Gateway used for secure web access. Authentication t code is a two-factor authentication method.

• TMG is a firewall and secure web gateway product developed by Microsoft.

• It provides protection against malware, spam, and other internet threats.

• Authentication t code is a two-factor authentication method where users enter a code along with their password for added security.

• Exam...read more

Split a dataset into two datasets with 90% and 10% of the data respectively.

• Use the SAS DATA step to read the original dataset and create two new datasets.

• Use the OBS statement with the POINT= option to specify the percentage of data to include in each dataset.

• Calculate the number of observations for 90% and 10% based on the total number of observations in the original dataset.

• Example: data dataset1; set original_datas...read more

Create a flag to identify data that has not been updated

• Add a new column in the dataset called 'Updated Flag'

• Use a formula to check if the data has been updated recently

• For example, if the last update date is more than 30 days ago, set the flag to 'Not Updated'

Bias is error due to overly simplistic assumptions, variance is error due to overly complex models.

• Bias is error introduced by approximating a real-world problem, leading to underfitting.

• Variance is error introduced by modeling the noise in the training data, leading to overfitting.

• High bias can cause a model to miss relevant relationships between features and target variable.

• High variance can cause a model to be overl...read more

Learning rate is a hyperparameter that controls how much we are adjusting the weights of our network with respect to the loss gradient.

• Learning rate determines the size of the steps taken during optimization.

• A high learning rate can cause the model to converge too quickly and potentially miss the optimal solution.

• A low learning rate can cause the model to take a long time to converge or get stuck in a local minimum.

• Com...read more

Types of LODs in Tableau include Fixed, Include, and Exclude.

• Fixed LOD: Computes a value using specified dimensions, regardless of the visualization level.

• Include LOD: Computes a value at a specified level of detail, including dimensions not in the visualization.

• Exclude LOD: Computes a value at a specified level of detail, excluding dimensions not in the visualization.

Tableau follows a client-server architecture with a three-tier structure.

• Tableau Desktop is the client application used for creating and publishing content.

• Tableau Server is the central server that manages user authentication, data sources, and content distribution.

• Tableau Online is a cloud-based version of Tableau Server.

• Tableau's three-tier structure includes the data source, the VizQL server, and the application ser...read more

Different filters in Tableau include dimension filters, measure filters, top N filters, wildcard filters, and context filters.

• Dimension filters allow users to filter data based on categorical variables.

• Measure filters allow users to filter data based on numerical variables.

• Top N filters allow users to filter data based on the top or bottom N values.

• Wildcard filters allow users to filter data based on patterns or partia...read more