Python Interview Questions Set - 6 Released
Intermediate Level Is Python case sensitive when dealing with identifiers? Yes. Python is case-sensitive when dealing with identifiers. It is a case sensitive language. Thus, variable and Variable would not be the same. How to create a new column in pandas by using values from...
Python Interview Questions Set - 5 Released
Intermediate Level What is __init__ in Python? _init_ methodology is a reserved method in Python aka constructor in OOP. When an object is created from a class and _init_ methodology is called to access the class attributes. What are the tools present to perform static...
Python Interview Questions Set - 3 Released
Intermediate Level What are Pandas? Pandas is an open-source python library that has a very rich set of data structures for data-based operations. Pandas with their cool features fit in every role of data operation, whether it be academics or solving complex business problems. Pandas...
Tableau Interview Questions Set - 4 Released
Intermediate Level Can we see SQL generated by Tableau Desktop? Tableau Desktop Log files are placed in C: UsersMy DocumentsMy Tableau Repository. In case of live connection to any data source, check the log file “log.txt” and “tabprotosrv.txt” files. In case of extract connection to...
Tableau Interview Questions Set - 2 Released
Intermediate Level What is Mark Card in Tableau? There is a card to the left of the view where we can drag fields and control mark properties like color, size, type, shape, detail, label, and tooltip. Define published data source? When you are ready to...
SQL Interview Question Set - 5 Released
Intermediate Level How do I count the number of records in a MySQL query? select count(*) from TABLE_NAME where 'status' = 1; What is heap table in MySQL? HEAP tables are in memory. No TEXT or BLOB fields are allowed inside HEAP tables. They are...
SQL Interview Question Set - 4 Released
Intermediate Level What are Storage Engines in Mysql? Storage engines are Mysql components, that can handle the operations for different table types to store and manage information in a database. • InnoDB • MyISAM • MEMORY • MERGE • EXAMPLE • CSV • ARCHIVE etc...
Python with Gemini (Gen AI) using Google Colab
Introduction Hi folks! Welcome to an another exciting blog at Gamaka AI. This article basically deals with the use of Python with Gen AI using Google Colab. The advantage of using Google Colab is that it allows you to write and execute Python code directly in your...
Power BI Interview Question Set - 3 Released
Intermediate Level 1. Explain the concept of incremental data refresh in Power BI and its benefits? Incremental data refresh in Power BI allows you to refresh only the new or modified data since the last refresh, rather than refreshing the entire dataset. This improves performance...
Power BI Interview Question Set - 2 Released
Intermediate Level 1. What is the role of Power Query in Power BI, and how does it facilitate data preparation? Power Query is used for data transformation and cleansing tasks within Power BI. It enables users to extract, transform, and load data from various sources,...
Recent Comments
Archives
Categories
Categories
- Inspiration (1)
- Style (1)
- Technical Blog (12)
- Tips & tricks (2)
- Uncategorized (17)