CGI Group Senior Tableau Developer Interview Questions and Answers

Switch case is used for multiple conditions while if else is for binary conditions. Sorting can be done using various algorithms.

• Switch case is faster than if else for multiple conditions

• If else is more readable for binary conditions

• Sorting can be done using bubble sort, insertion sort, quick sort, etc.

• Example code for bubble sort: for(i=0;iarr[j+1]){swap(&arr[j],&arr[j+1]);}}}

Difference between compiler and interpreter with a coding challenge

• Compiler translates the entire code into machine language before execution while interpreter translates line by line during execution

• Compiler generates an executable file while interpreter does not

• Compiler is faster but debugging is harder while interpreter is slower but debugging is easier

• Coding challenge: Write a program to find the sum of two numbers

I am familiar with a wide range of technologies used in software development.

• Java

• Python

• C++

• JavaScript

• HTML/CSS

• SQL

• Git

• Linux

• RESTful APIs

• Agile methodologies

OOPs concepts in Java include encapsulation, inheritance, polymorphism, and abstraction.

• Encapsulation: Bundling data and methods together in a class.

• Inheritance: Creating new classes from existing ones, inheriting their properties and behaviors.

• Polymorphism: Objects of different classes can be treated as objects of a common superclass.

• Abstraction: Hiding complex implementation details and providing a simplified interfa

Abstraction can be achieved through interfaces, abstract classes, and encapsulation.

• Using interfaces to define a set of methods that a class must implement

• Using abstract classes to provide a base implementation that can be extended by subclasses

• Encapsulating implementation details to hide complexity and provide a simpler interface

• Using design patterns such as Factory and Strategy to abstract away implementation details

Class is a blueprint for creating objects while interface defines a contract for implementing classes.

• Class is a template for creating objects with properties and methods.

• Interface is a contract that defines a set of methods and properties that a class must implement.

• Object is an instance of a class that has its own set of properties and methods.

• Function instance is a reference to a function that can be called with arg...read more

Access modifiers control the visibility and accessibility of class members.

• Access modifiers include public, private, protected, and internal.

• Public members can be accessed from anywhere.

• Private members can only be accessed within the same class.

• Protected members can be accessed within the same class and its subclasses.

• Internal members can be accessed within the same assembly.

• Access modifiers help enforce encapsulation ...read more

Cloud refers to the delivery of computing services over the internet.

• Cloud computing allows users to access data and applications from anywhere with an internet connection.

• Cloud services can be categorized into three main types: Infrastructure as a Service (IaaS), Platform as a Service (PaaS), and Software as a Service (SaaS).

• Cloud providers include Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform.

• ...read more

There are multiple ways to achieve tasks on AWS depending on the specific task.

• Using AWS Management Console

• Using AWS CLI

• Using AWS SDKs

• Using AWS CloudFormation

• Using AWS Elastic Beanstalk

• Using AWS Lambda

• Using AWS Step Functions

• Using AWS Batch

SID stands for Security Identifier. It is a unique identifier assigned to a user, group, or computer account in Windows.

• SID is used to control access to resources in Windows

• It is a string of alphanumeric characters

• SID is generated by the Windows operating system during the creation of an account

• It is used to identify users, groups, and computers in a network

• Example: S-1-5-21-3623811015-3361044348-30300820-1013