Interview Questions

Q1 : Explain Tableau File ExtensionsA : The below ones are few extensions in Tableau: Tableau Workbook (.twb) Tableau Data extract (.tde) Tableau Datasource (.tds) Tableau Packaged Datasource (.tdsx) Tableau Bookmark (.tdm) Tableau Map Source (.tms) Tableau Packaged Workbook (.twbx) – zip file containing .twb and external files Tableau Preferences (.tps) Q2 : How to remove the All options from a Tableau auto – filter?A : Right click filter>>customize>>uncheck show all option Q3 : Max no of tables we can join

Q1 : What is the segment in Greenplum?A : Database instances in the Greenplum system are called segments. Segment stores the data and carries out the query processing. In Greenplum distributed systems, each segment contains a distinct portion of the data. Q2 : How to delete a standby?A : To remove the currently configured standby master host from your Greenplum Database system, run the following command in the master only:# gpinitstandby -r Q3 :  How many user schemas are there

Q1 : What is Splunk indexer? What are stages of Splunk indexing?A : The indexer is the Splunk Enterprise component that creates and manages indexes. The primary functions of an indexer are:1. Indexing incoming data.2. Searching the indexed data. Q2 : Define Splunk. Why is it used for the analysis of machine data?A : Splunk is a great tool to allow visibility into data generated from machines like hardware devices, servers, IoT devices, networks, and other sources. It is used

Question 1 : What is the use of Okta? Answer : Okta connects any person with any application on any device. It’s an enterprise-grade, identity management service, built for the cloud, but compatible with many on-premises applications. By using Okta, IT can manage any employee’s access to any application or device. Question 2 : What is Okta authentication? Answer : The Okta Authentication API provides operations to authenticate users, perform multi-factor enrollment and verification, recover forgotten passwords, and unlock accounts.

Q1 : What is relational data modeling?A : The visual representation of objects in a relational database (usually a normalized) is called as relational data modeling. Table contains rows and columns Q2 : Distinguish between OLTP and OLAP?A : OLTP stands for Online Transaction Processing system & OLAP stands for Online Analytical processing system. OLTP maintains the transactional data of the business & is highly normalized generally. On the contrary, OLAP is for analysis and reporting purpose & it is

Q1 : What is Inline memory in QlikView ?A : Create table or add field to table . Q2 : Explain QlikView architecture?A : QlikView deployments have three main infrastructure components: (Check for Qlikview Architecture) 1.QlikView Developer: Is a Windows-based desktop tool that is used by designers and developers to create 1) a data extract and transformation model and 2) to create the graphical user interface (or presentation layer). 2.QlikView Server (QVS): Handles the communication between clients and QlikView applications. It

Q1 : Define the SQL Server Analysis Services (SSAS)?A : SQL Server Analysis Services (SSAS) is the On-Line Analytical Processing (OLAP) Component of SQL Server. SSAS enables you to manufacture multidimensional structures called Cubes to pre-compute and store complex conglomerations, and furthermore to construct mining models to perform information examination to recognize profitable data like patterns, designs, connections and so forth inside the information utilizing Data Mining capacities of SSAS, which generally could be extremely hard to decide without Data

Q1 : What is Flume? A : A distributed service for collection, aggregating, and moving giant amounts of log knowledge, is Flume. Q2 : Why we are using Flume?A : Most often Hadoop developer use this tool to get log data from social media sites. It’s developed by Cloudera for aggregating and moving very large amount of data. The primary use is gather log files from different sources and asynchronously persists in the Hadoop cluster. Q3 : What Is Flumeng?

Q1: Can you explain “insert topic” to me in a simple way? A: Inbound marketing is about making your industry interesting and helping to solve customer problems with content. This question is used to make sure that someone can drop industry jargon and communicate a simple idea in a clear and engaging way. Q2: What do you read online? A: Part of inbound marketing is understanding industry news and leveraging for the benefit of the business. Does the person have

Q1: Explain Mobile Marketing? A: Mobile Marketing is a new channel of marketing that uses smartphones, tablets, or other mobile devices to reach customers. The medium could be SMS, MMS, videos, email, social media or mobile application. Q2: What Are The Limitations Of Mobile Marketing? A: Yes, there are certain things that make mobile marketing less preferred. Some of them are: Limited Ads – While sending a message on phone you cannot send all types of ads. You have to limit