Wednesday, 30 December 2015

Top 30 Mapreduce Quiz/Test with Answers : Big Data and Hadoop Interview Questions Quiz

 TOP 30 MAPREDUCE OBJECTIVE TYPE INTERVIEW QUESTIONS QUIZ WITH ANSWERS (BIG DATA & HADOOP)

Here we come with most growing technology quiz set, which is know as Big Data, Many database developer are now taking training for same to make there career in this technology. Expert says that this technology have bright future, So if you are taking training or prepare side by side then must go through this quiz to test you knowledge in Big data & Hadoop. These are questions with answer which can be asked during interview. If you want more quiz/test like this then comment, we will prepare most test set. We have more such test like this one
Click here for another Quiz/Test 1
Click here for another Quiz/Test 2

1). Which of the following describes the map function?  
A) It processes data to create a list of key-value pairs
B) It converts a relational database into key-value pairs
C) It indexes the data to list all the words occurring in it
D) It tracks data across multiple tables and clusters in Hadoop

2). In a word count query using MapReduce, what does the map function do?
A) It sorts the words alphabetically and returns a list of the most frequently used words.
B) It returns a list with each document as a key and the number of words in it as the value.The master JobTracker sends map and reduce functions to the same machines or nodes in a cluster.
C) It creates a list with each word as a key and every occurrence as value 1.
D) It creates a list with each word as a key and the number of occurrences as the value.

3).The Combine stage, if present, must perform the same aggregation operation as Reduce.True or False?
A) True
B) False

4). A combinator in MapReduce is a function that:
A) Assembles program fragments
B) Builds programs from program fragments
C) Helps in fragmenting the program
D) Builds program fragments

5)Indentify the utility that allows you to create and run MapReduce jobs with any executable or script as the mapper and/or the reducer?
A) Oozie
B) Sqoop
C) Flume
D) Hadoop Streaming

6). What messages does a data node also provide to detect and ensure connectivity between the NameNode and the data nodes?
A) Heartbeat
B) Pipeline
C) Map
D) None

7). Which MapReduce phase is theoretically able to utilize features of the underlying file system in order to optimize parallel execution? 
A) Split
B) Map
C) Combine
D) MapCombine

8). In designing the MapReduce framework, which of the following needs did the engineers consider?
A) Developers should be able to create new languages
B) Processing should expand and contract automatically
C) Processing should be stopped in the case of network failure
D) It should be cheap and distributed free of cost

9). MapReduce can best be described as a programming model used to develop Hadoop-based applications that can process massive amounts of unstructured data.
A) True
B) False

10). The function of secondary namenode: 
A) is to serve as a backup for NameNode
B) is to continue the functioning of NameNode
C) is to serve as a checkpoint mechanism for primary NameNode
D) is to provide advanced technology as compared with primary
 
11). Hadoop is a framework that works with a variety of related tools. Common cohorts include:
A) MapReduce, Hive and HBase
B) MapReduce, MySQL and Google Apps
C) MapReduce, Hummer and Iguana
D) MapReduce, Heron and Trumpet

12). In a MapReduce job, you want each of your input files processed by a single map task. How do you configure a MapReduce job so that a single map task processes each input file regardless of how many blocks the input file occupies?
A) Set the number of mappers equal to the number of input files you want to process.
B) Write a custom MapRunner that iterates over all key–value pairs in the entire file.
C) Write a custom FileInputFormat and override the method isSplittable to always return false.
D) Increase the parameter that controls minimum split size in the job configuration

13). What is the input to the Reduce function? 
A) An arbitrarily sized list of key/value pairs.
B) An arbitrarily sized list of key/value with that key.
C) One key and a list of all values associated with that key.
D) One key and a list of some values associated with that key.

14). A combinator in MapReduce is a function that:
A) Assembles program fragments
B) Helps in fragmenting the program
C) Builds programs from program fragments
D) Builds program fragments

15). What is the implementation language of the Hadoop MapReduce framework?
A) Java
B) FORTRAN
C) Python
D) C

16). Which of the following MapReduce execution frameworks focus on execution in shared-memory environments? 
A) Hadoop
B) Twister
C) Phoenix
D) BitXise

17). If the output directory specified in the output format already exists, MapReduce execution:
A) Throws an error
B) Continues as execution
C) Seeks further instructions
D) Shuts down completely

18). Which of following statement(s) are correct? 
a) Master and slaves files are optional in Hadoop 2.x
b) Master file has list of all name nodes
c) Core-site has hdfs and MapReduce related common properties
d) hdfs-site file is now deprecated in Hadoop 2.x

19). What does the following piece of code return?
pempublic abstract float getProgress() throws IOException, InterruptedException/em
A) A number above 1
B) A number below 0
C) Either 0 or 1
D) A number between 0 and 1

20). Mike has a Hadoop cluster with 50 machines under default setup (replication factor 3, 128MB input split size). Each machine has 100GB of HDFS disk space. The cluster is currently empty (no job, no data). Mike intends to upload 1 Terabyte of plain text (in 5 files of approximately 200GB each), followed by running Hadoop’s standard WordCount job. What is going to happen?
A) WordCount fails: too many input splits to process
B) WordCount runs successfully
C) The data upload fails at the last file: due to replication, all disks are full
D) The data upload fails at the first file: it is too large to fit onto a node

Note: WordCount runs successfully Explanation:the total HDFS storage is 50*100 = 5000 GB. The total input file size is 5*200 = 1000 GB, with 3 times replication factor, it is 3000 GB, which is still lesser than the total HDFS storage. So the files will get loaded and Wordcount will run successfully.

22). How does HDFS ensure the integrity of the stored data?
A) Through checksums
B) Through error logs
C) By comparing the replicated data blocks with each other
D) By comparing the replicated blocks to the master copy Shuffle and sort

23). The time it takes for a Hadoop job’s Map task to finish mostly depends on?
A) The duration of the job’s Reduce task by comparing the replicated data blocks with each other
B) The duration of the job’s shuffle & sort phase
C) The placement of the NameNode in the cluster
D) The placement of the blocks required for the Map task

24). What is speculative execution in Hadoop?
A) Hadoop executes the delayed map/reduce tasks in parallel in other Datanodes, speculating failures/delays in Datanodes.
B) Hadoop always executes every map/reduce task in more than one Datanode, speculatively.
C) Hadoop does not implement any speculative execution unless specified by the user.
D) Nodes in Hadoop cluster never fail. So there is no speculative execution in Hadoop.

25). If the output directory specified in the output format already exists, MapReduce execution:
A) Seeks further instructions
B) Throws an error
C) Shuts down completely
D) Continues execution

26). What decides number of Mappers for a MapReduce job?
A) File Location
B) mapred.map.tasks parameter
C) Input file size
D) Input Splits

27). What happens if mapper output does not match reducer input?
A) Hadoop API will convert the data to the type that is needed by the reducer.
B) Data input/output inconsistency cannot occur. A preliminary validation check is executed prior to the full execution of the job to ensure there is consistency
C) A real-time exception will be thrown, and MapReduce job will fail
D) The Java compiler will report an error during compilation, but the job will complete with exceptions.

28).A 10-GB file is split into chunks of 100 MB and is distributed among the nodes of a Hadoop cluster.
Due to power failure, the system got switched off, and when power returns, the system administrator restarts the process. How will the NameNode know what kind of processing was being performed on which file?
A) Through the combiner
B) Through the scheduler
C) Through the input list
D) Through the DataNode

29). What are the core methods of a Reducer?
A) setup (),reduce (),cleanup ()
B) Get (),Mapreduce (),cleanup ()
C) Put (),reduce (),clean ()
D) set-up (),reduce (),cleanup ()

30).Which of the following is the correct sequence of MapReduce flow? 
A) Map ??Reduce ??Combine
B) Combine ??Reduce ??Map
C) Map ??Combine ??Reduce
D) Reduce ??Combine ??Map

Answers: 1). A 2). C 3).B  4).B  5).D  6).A  7).A  8).B  9).A  10).A  11).A  12).B  13).C  14).C  15).A  16).C  17).A  18).C  19).D  20).B  21).  22).A  23).D  24).A  25).B  26).C  27).C  28).C 29).A  30).C
Click here for another Quiz/Test 1
Click here for another Quiz/Test 2

Thursday, 17 December 2015

Configure Database Email Using Gmail SMTP/Gmail Account

Hi guys, if you are facing problem in configure database email using gmail account or trying first time to configure database email then this blog for you.
Actually I was trying to setup my account in my local server using gmail SMTP, but I was facing problem in it was not sending email.
And after lots of analysis and discussing with colleague I found that in my gmail account 2 step verification was on, so if same with you first set it off.
But still I was facing problem and I found that there is one more thing we need to do is to set Access for less secure apps - turn on, these was main problem with setup my gmail account. After that you can do following step wise everything will work fine. If you still facing problem then comment here.

Turn off  2-Step Verification :: First login with your gmail Account and turn off "2-Step Verification"


Turn on, Access for less secure apps:: for this follow this link https://support.google.com/accounts/answer/6010255?hl=en


Now follow these basic database mail configuration steps.













Monday, 23 November 2015

Top 18 Armani Exchange Outfit Interview Questions with Answers

Today we come with fashion related interview questions answers, asked in very popular brand job Interview session which is know as Armani Exchange.
I am big fan of this brand, I was enjoying to search googled about this company interview questions, I have Google and take the help of glassdoor.com and collected the best interview question with answers which are asked in AX interview, So if you are going to attend AX interview or any other such company/brand interview then must go through this collection, you must enjoy it.

1). Tell me about   yourself?
Ans: Describe about yourself.

2). Describe a time you had to deal with a angry/difficult customer?
Ans: I'd be as specific as can be, and if no such experience, try to give a detailed version of what you think would have been the proper thing to do, such as stay calm and try to figure out the situation before he/she causes a scene.

3). What's your sense of fashion, and if you could which   celebrity would you most likely want to be with for an entire day?
Ans: Kanye and Kim

4).What is our direct competition?
Ans: Express, Guess (Marciano)

5).How do you keep up with current fashion trends?
Ans: I said that I keep up through blogs and websites like lookbook.nu

6).How are you going to familiarize yourself with all of our   product mens and womans?
Ans: Rely on management for coaching and training on product knowledge.

7).Why do you think you would be successful at Armani exchange? 
Ans: On you.

8).Are you fine with commission based environment?
Ans: Yes

9).How would you describe the Armani exchange style?
Ans: Modern urban club meets the street for the everyday fashionable person.

10).Draw and design a shirt for them.
Ans: Generic A/X design t-shirt

11). What do you know about fashion? 

12). Why do you want to work at AX? Why do you want a career in fashion?
Ans: Because I love fashion and I have a eye for what looks good and I'm pretty convincing... Its not hard to sell a product that you actually utilize. I'm already a customer (I lied) lol Side note... Unfortunately they won't hire u if they don't carry your size. So ladies over a size 10/12 more than likely won't be hired. Sane giez for the bug boys.
OR
This job is a logical step forward for me and if I was appointed then I feel you would not be disappointed.

13). What is your Favorite designer? Dead or alive? 
Ans: I answered Patricia Fields as MY favorite designer... The general managers face lit up as if he couldn't believe I knew who she was. Lol. Don't be cliche and say Georgio Armani. He doesn't even own the company any more.

14). What salary do you think you deserve?
Ans: On you

15). How would I benefit the company?
Ans: Provide quality customer service.

16). When are you available to speak? 
Ans: I gave my availability, and kept in contact to confirm interview, but Human Resources did not respond.

17). Describe an incident where you went above and beyond to   help out a customer? 
Ans: A customer pulled me aside as I was finishing my shift. Instead of informing her that I was off the clock, I spent 30 minutes with her to identify her needs, and I formulated and implemented the best strategy to address them. She walked away a satisfied customer, and I walked away knowing that I did a good job.

18). Do you have any question?
Ans: You must always have a question!

Tips:
I have a Job Interview with Armani Exchange tomorrow, and I'm wondering what you guys think I should wear?
Usually It depend on your position for which position you are going to attend interivew but you shouldn't wear their trendy/casual style clothes for the interview.

Sunday, 22 November 2015

Sukesh Marla MVC Book PDF | Learn MVC Project IN 7 Days

One of the very well known .net Geeks Sukesh Marla, Who is know for his blog. going to launch a MVC book, book named as "Learn MVC Projects in 7 Days" so if you are looking for PDF/ebook, then change your mood and go for hard copy. This book will be great for MVC learner guys. Keep it up Sukesh Marla

Friday, 20 November 2015

Lua Programming langauge Interview Questions and Answers

LUA INTERVIEW QUESTIONS WITH ANSWERS
Here we come with Lua programming language interview questions with answers, As we writing all type of interview questions, so we are start getting mail from Lua learners, they want Lua language related interview questions with answers, because there is no enough material available on internet. So we come with this article which will help you to clear you interview.

1). What is Lua?
Ans: Lua is a lightweight multi-paradigm programming language designed primarily for embedded systems and clients. Lua is cross-platform since it is written in ANSI C, and has a relatively simple C API.

2). When is the next version due?
Ans: Lua is in continuous development but new versions are infrequent.
Lua 5.3 was released on 12 Jan 2015.

3). Who is/are the founder of Lua?
Ans: Lua was created in 1993 by Roberto Ierusalimschy, Luiz Henrique de Figueiredo, and Waldemar Celes, members of the Computer Graphics Technology Group (Tecgraf) at the Pontifical Catholic University of Rio de Janeiro, in Brazil.
4). Is Lua free software?
Ans: Yes, Lua is freely available for any purpose, including commercial purposes, at absolutely no cost, and using it requires no paperwork. Read the details in the license page.

5). Is Lua compatible with GPL software?
Ans: Yes. Lua is distributed under the terms of the very liberal and well-known MIT license, which is compatible with GPL and is approved by the Open Source Initiative. Read the details in the license page.

6). Is there a public revision control repository?
Ans: No, there is no publicly available repository of Lua development code. Read this explanation. If you want to see a preview of what is coming in the next version, you'll have to wait until a work version is available.

7). What are the Advantages and disadvantages of using Lua?
Ans: Lua has a couple of advantages:
  • It's lightweight: It doesnt require much storage and is easy to learn
  • It's 'quite fast': It is actually about as fast as python
  • It's fully written in C: You can easly manipulate lua if you know C
  • Lua also has a great documentation.
  • There's LuaJIT!
Lua has a couple of disadvantages aswell:
  • It's lightweight: If you want python style regex, you'll have to code your own, or download a library.
  • It has a small community: If hou have questions, it might take a while before you get answers.
8). Do you accept patches?
Ans: We encourage discussions based on tested code solutions for problems and enhancements, but we never incorporate third-party code verbatim. We always try to understand the issue and the proposed solution and then, if we choose to address the issue, we provide our own code. All code in Lua is written by us. See also the previous question.

9). Is there a mailing list for Lua?
Ans: Yes, a friendly and active one called lua-l. Everyone is welcome. Read all about it here.
For discussions in Portuguese, there is Lua BR, the Brazilian version of lua-l.

10). What make Lua distinct from other languages?
Ans: Lua provides a set of unique features that makes it distinct from other languages. These include
  • Extensible
  • Simple
  • Efficient
  • Portable
  • Free and open
11). What are some use of Lua?
Ans: Lua is mainly use for following purpose
  • Game Programming
  • Scripting in Standalone Applications
  • Scripting in Web
  • Extensions and add-ons for databases like MySQL Proxy and MySQL WorkBench
  • Security systems like Intrusion Detection System.
12). What are the advantages of using Lua with C?
Ans: It's great if you know what you're using Lua for. Lua is a scripting language commonly used in games like Multi Theft Auto or Garry's Mod.
You don't need it unless you're planning on implementing a plugin/resource system or interested in easy modding.
It's really easy to set up and really easy to use for its purpose.

13). Can or will Lua be used as a web programming language?
Ans: Yes, given its a general interpreted programming language just like Python or Ruby, but with a smaller library and a small community.
At this point I would say: do it if you want to experiment, but not for professional stuff.

14). What is LuaJIT?
Ans: LuaJIT is a Just-In-Time Compiler for the Lua programming language. LuaJIT offers more performance, at the expense of portability. On the supported OS's (all popular operating systems based on x86 or x64 CPUs (Windows, Mac OSX, Linux, ...), ARM based embedded devices (Android, iOS) and PPC/e500v2 CPUs) it offers an API- and ABI-compatible drop-in replacement for the standard Lua interpreter.

15). What makes LuaJIT faster than Lua?
Ans: Firstly, LuaJIT has a faster baseline interpreter.  Even without the JIT, LuaJIT is already faster than baseline Lua for three reasons:
The interpreter uses a custom bytecode format.  The Lua 5.1 format needs a bit more bit fiddling to decode an instruction, but LuaJIT's format only uses fields that are multiples of 1 byte.  This makes decoding instructions faster.  Since decoding has to be done for every single instruction, a simpler format directly translates into a faster interpreter.  (By how much depends on the complexity of each instruction, though.)
It uses direct dispatch.  The standard way of implementing an interpreter in C is to use a loop and a big `switch` statement at the top which then dispatches to the code that executes the instruction.  A faster way is to use a table of code labels, have each instruction decode the next instruction, and directly jump to the label for the next instruction based on the opcode of the following instruction.  If you want to do this in C you need a special GNU/Clang instruction. You cannot do this in ANSI C, which standard Lua aims to.
LuaJIT's interpreter is written in assembly.  This makes matters quite a bit more complicated (and obviously unportable), but opens the potential to outsmart the compiler.  For this specific use case hand-rolled assembly indeed beats a compiler in almost all cases.  Google's Dalvik VM interpreter is also written in assembly, and I believe so is JVM's.

16). What are the pros and cons of Lua vs. Python and vice versa?
Ans: Following are the pros/Advantages and cons/disadvantage of Lua vs Python
  • Lua is off-the-charts portable. It's by far the most portable language I've ever seen, maybe even the most portable program.
  • What I mean by this isn't that Lua programs are portable (they're not, compared to Java), but Lua itself is.
  • Just recently I built Lua on an IBM iSeries, with zero changes to the source code, I just compiled each Lua source file with the IBM ILE C compiler.
  • Compare that to getting say, Python building on some unknown UNIX, let alone a completely different OS like IBM i (OS/400).
  • Lua is very simple, easy to port to a new platform, easy to integrate with C on that platform. It's a nice enough language, but nothing special, but it's portability is special.
  • If the platform has an ANSI C compiler (and they pretty much all do, I can only think of a couple that do not), then you can almost certainly build Lua, that's very cool indeed.
17). Give example of for loop in Lua programming language?
Ans: for variable = x, 1, .5 do
print (y)
end

18). How can you convert a string to an integer in Lua? If you have a string like this: a = "10", You would like it to be converted to 10, the number.
Ans: I will use the tonumber function. As in a = tonumber("10")

19). What are the differences between Lua and JavaScript?
Ans: Click here to see the answer

Lua Interview Questions: What are the differences between Lua and JavaScript?

Lua programming language Interview Question with Answer FAQ:

What are the differences between Lua and JavaScript?
Following are the difference between both scripting language (Lua and JavaScript)

  • Lua has native support for coroutines.
  • Lua doesn't convert between types for any comparison operators. In JS, only === and !== don't type juggle.
  • Lua has an exponentiation operator (^); JS doesn't. JS has many more operators, including the ternary conditional operator (?:), increment/decrement, bitwise operators, type operators (typeof and instanceof), additional assignment operators and additional comparison operators.
  • In JS, the equals and not equals operators are of lower precedence than less than et al. In Lua, all comparison operators are the same precedence.
  • Lua supports tail calls.
  • Lua supports assignment to a list of variables. While it isn't yet standard in Javascript, Mozilla's JS engine (and Opera's, to an extent) has supported a similar feature since JS 1.7 (available as part of Firefox 2) under the name "destructuring assignment". Destructuring in JS is more general, as it can be used in contexts other than assignment, such as function definitions & calls and loop initializers. Destructuring assignment has been a proposed addition to ECMAScript (the language standard behind Javascript) for awhile.
  • In Lua, you can overload operators.
  • In Lua, you can manipulate environments with getfenv & setfenv.
  • In JS, all functions are variadic. In Lua, functions must be explicitly declared as variadic.
  • Foreach in JS loops over object properties. Foreach in Lua (which use the keyword for) loops over iterators and is more general.
  • Integer literals in JS can be in octal.
  • JS has explicit Unicode support.
  • In Lua, ~ is used in place of !. (as in, if foo ~= 20 then ... end) (technically syntax, but it's easily overlooked and causes subtle bugs).
  • In Lua, the not/or/and keywords are used in place of !/||/&& (also syntax but also easily forgotten).
  • In Lua, any type of value (except nil and NaN) can be used to index a table; in JavaScript, object indexes are converted to strings.
  • Not equal is spelled ~= in Lua. In JS it is !=
  • Lua arrays are 1-based - their first index is 1 rather than 0.
  • Lua requires a colon rather than a period to call object methods. You write a:foo() instead of a.foo() 
For more Lua Interview Question Click here


Tuesday, 17 November 2015

Top 10 Ionic Framework Interview Questions with Answers for Mobile App Developers

Today we came with rapidly growing mobile development technology, which is know as Ionic framework, If you are looking job in Ionic framework and prepare for interview then must go through following interview questions. There are only few books available in market so only 10 questions are there with answers. We will come with more question answers soon.

What is Ionic framework?
Ionic is a complete open-source SDK for hybrid mobile app development. Built on top of AngularJS and Apache Cordova, Ionic provides tools and services for developing hybrid mobile apps using Web technologies like CSS, HTML5, and Sass. Apps can be built with these Web technologies and then distributed through native app stores to be installed on devices by leveraging Cordova. Ionic was created by Max Lynch, Ben Sperry, and Adam Bradley of Drifty Co. in 2013, and is used by software developers around the World.

What are the advantages and disadvantages of using Ionic framework?
Being short, the advantages:
  • 1. One source for all the suported platforms (mainly Android and OSX).
  • 2. Main development in html, css and js, which almos all web developers know (or at leas the good ones).And being able to use great frameworks like angular, which is embedded in ionic by default.
  • 3. Cross-platform, javascript for everything, css for designing
Dissadvantages:
  • 1. Less performance as it's not completely native, not that much of an issue unless making games or high load apps, the ones that uses a lot of resources.
  • 2. Slow, tricky sometimes, annoying to use when dependent of third party libs
What is the difference between AngularJS and Ionic framework?
AngularJS: AngularJS is a open source web application framework mainly to build single page apps (SPAs).
Ionic framework: Ionic framework is used for developing native like mobile applications using a web technology stack consisting of HTML5, CSS3, SAAS, AngularJS and Cordova.

What is the difference between ionic polymerization and free-radical?
Simply, these names refer to the mechanism by which the polymerization occurs. The attacking species can be a free radical or an ion.

What is the difference between Cordova and Ionic?
Ionic uses cordova. Cordava makes able other than native applications have an access to the device.
Ionic also provides a lot of libs to make your app look like a native one. With gestures enabled etc...
Using both of them, you'll be able to provide a full app looking like native but developed using Javascript for front-end and whatever you like for back-end. What an useful tool!

What is the difference between HTML5, Native and a Hybrid app?
Native app: Mobile apps built for specific platforms like iOS, Android, Blackberry, Windows, etc, using their respective development tools and language. Native App will work only on the platform it has been designed for.

HTML5 Web App: Mobile optimized websites that appear to be apps and run on the mobile browser. These are platform independent but lack superior UX and functionality. These apps wont run in the offline mode.

Hybrid/ Cross- Platform App: Single mobile app built on HTML5 and optimized for multiple platforms (using native containers). They are downloaded from the app stores like native apps.

What are some succesfull apps built with Ionic?
Sworkit, Mallzee, Chefsteps

What is ngCordova?
Cordova offers ngCordova which is set of wrappers specifically designed to work with AngularJS

Wednesday, 11 November 2015

TOP 100 TABLEAU INTERVIEW QUESTIONS WITH ANSWERS FOR FRESHER AND EXPERIENCED : PDF


 Hey data player, here we comes with most FAQ tableau software interview questions with answers, if you are preparing for tableau developer job (data analyst/dashboard developer) then must go through these questions which would be very helpful to make your career. Please must give feedback

Here are TOP 100 Tableau Interview questions with answers, PDF download link will be available in set 4, Here we divided all interview question in set.
Our last article is about Power BI Interview Questions , powerBI growing very fast these days, So If you are preparing for Tableau then must through PowerBI Interview questions as well, because interviewer can ask some question related to PowerBI.
Please give your feedback about this set, if you faced any new interview question then please post here as a comment or any other suggestion most welcome.


TOP 80 TABLEAU INTERVIEW QUESTIONS ANSWERS FOR FRESHER SET-8

This is SET-8, to read from start click here This set contain top 10(out of 80) tableau interview questions answer.
Our last article is about Power BI Interview Questions , powerBI growing very fast these days, So If you are preparing for Tableau then must through PowerBI Interview questions as well, because interviewer can ask some question related to PowerBI.

TOP TABLEAU INTERVIEW QUESTIONS FOR FRESHER AND EXPERIENCED

71). What is the process to adjust the size of a Dashboard? 
Ans: Dashboard sizing options are on the left side of the dashboard user interface in the lower right corner. Various sizes such as size for blogs, iPads, and laptops. It makes sizing easy for any display medium.

72). How do I share results? 
Ans: Publish secure dashboards to Tableau Server or Tableau Online.
A non-secure option is sharing with Tableau Reader.

73). Is it possible to export data or print PDFs? 
Ans: Yes, Export data as a .csv or as a crosstab to Excel.
Printing PDFs is just like using a Microsoft Office product. The caveat is inability to interact with a view or dashboards.
Since the end goal is not to have interactivity become static, Tableau is also not pixel perfect.

74). What is Tableau Data Server? 
Ans: Data Server is a Tableau Server component that acts like a middle man between Tableau users and the data.

75). What is Tableau Online? 
Ans: Tableau Online is a hosted, SaaS version of Tableau Server. It makes business intelligence faster and easier than ever before. Publish dashboards with Tableau Desktop and share them with colleagues, partners or customers.
The power of Tableau, in the cloud.

76). What is the difference between Tableau Online and Tableau Server? 
Ans: Tableau Online is simply a cloud based version of Tableau Server; Tableau Software hosts it so the customer doesn't have to make a hardware investment.

77). When publishing to online sometimes an error about needing to take an extract appears. Why is this occurring and why does it only happen occasionally? 
Ans: This happens when a user is trying to publish a workbook that is connected to an internal server or a file stored on a local drive, such as a SQL server within a company's network. As Tableau Online is not hosted within a customers network our company requires an extract to access the data. If a user is connecting to a local file such as some cloud based data sources such as Google Big Query; this will not be necessary.

78). What is the DRIVE program methodology? 
Ans: Tableau Drive is a methodology for scaling out self-service analytics. Drive is based on best practices from successful enterprise deployments. The methodology relies on iterative, agile methods that are faster and more effective than traditional long-cycle deployment. A cornerstone of the approach is a new model of a partnership between business and IT.
CLICK HERE TO READ FROM START

TOP 80 TABLEAU INTERVIEW QUESTIONS ANSWERS FOR FRESHER SET-7

This is SET-7, to read from start click here This set contain top 10(out of 80) tableau interview questions answer.
Our last article is about Power BI Interview Questions , powerBI growing very fast these days, So If you are preparing for Tableau then must through PowerBI Interview questions as well, because interviewer can ask some question related to PowerBI.

TOP TABLEAU INTERVIEW QUESTIONS FOR FRESHER AND EXPERIENCED

61). How are targets or goals added to a chart?
Ans :On the left, switch from the Data Pane to the Analytics Pane and drag the reference measure out into the view. Configure reference line to address the table, pane, or cell.

62). Can an ANOVA table be seen for a trendline? 
Ans :After dragging out a trendline for the analytics pane, right click the trendline and select describe. All stats are now available without even having to calculate them.

63). When is a trend considered significant? 
Ans :Looking at the p-value in the ANOVA table can determine if a trend is significant.
A p-value of 0.05 or less is considered good.

64). Can the shape of a trendline be changed if there is a low correlation? 
Ans :Yes, Right click any trendline and change it using edit to better fit the data.

65). How you will quickly filtered out from a field? 
Ans :Right click the field > Quick Filter

66). What is a Set? 
Ans :Custom fields that define a subset of data based on some conditions.

67). Is there a way for end users to make all their selections in a view first and then have the view update? 
Ans :This can easily be accomplished by customizing a quick filter with an apply button. An apply button would allow selections to not be applied until the button is pressed.

68). What are Story Points? 
Story Points are a way to build narrative from data; to tell a story.
Story Points focuses on providing a platform for story building. Presenting data in this way can lessen time to communicate insight, increase depth of understanding, and increase memory of key concepts.
The "PowerPoint" of Tableau.

69). What is the process to make a Dashboard? 

  1. Quick click icon on tool bar. Represented by a chart with a plus sign on the right.
  2. Click new dashboard in the view and dashboard tabs.
  3. Select dashboard drop down in the toolbar. Select "new dashboard."
  4. Right click on a view or dashboard tab. Select "new dashboard."

70). What is the process to show an image, webpage, or text in a Dashboard (dashboard objects)?
Ans :All of these options are available in the dashboard window on the left of the dashboard user interface, below sheets.
Drag and drop onto view.
Pre-select the option to be tiled or floating.

71). CLICK HERE FOR SET-8(Q-71 to Q80)

TOP 80 TABLEAU INTERVIEW QUESTIONS ANSWERS FOR FRESHER SET-6

This is SET-6, to read from start click here This set contain top 10(out of 80) tableau interview questions answer.
Our last article is about Power BI Interview Questions , powerBI growing very fast these days, So If you are preparing for Tableau then must through PowerBI Interview questions as well, because interviewer can ask some question related to PowerBI.

TOP TABLEAU INTERVIEW QUESTIONS FOR FRESHER AND EXPERIENCED

51). What is a Hierarchy?
Ans: Refers to the systematic organization of data, often in a hierarchical form. Data organization involves fields, records, files and so on.

52). Does their need to be any metadata or semantic layers set-up before a customer can use Tableau?
Ans: No, Tableau Desktop offers very quick and easy direct connectivity to over 40 types of databases (plus tons other through ODBC). Simply point Tableau Desktop directly at a database and a customer can choose what table(s) and view(s) they'd like to connect to and they are on their way. No pre-configuration necessary.

53). What is a Measure?
Ans: Measure is a numeric value stored in a fact table.

54). What is a Dimension? 
Ans: Dimension is a categories for organizing items in a data set.

55). What is shelf?
Ans: The Columns shelf creates the columns of a table, while the Rows shelf creates the rows of a table. You can place any number of fields on these shelves.
When you place a dimension on the Rows or Columns shelves, headers for the members of that dimension are created. When you place a measure on the Rows or Columns shelf, quantitative axes for that measure are created. As you add more fields to the view, additional headers and axes are included in the table and you get an increasingly detailed picture of your data.
For example, the members of the Segment dimension are displayed as column headers, while the Profit measure is displayed as a vertical axis.

56). What is card? 
Ans: Every worksheet contains a variety of different cards that you can show or hide. Cards are containers for shelves, legends, and other controls.
For example, the Marks card is where you control mark properties. It contains the mark type selector along with controls for Color, Size, Label, Detail, Tooltip, Shape, and Angle. The controls that are available depend on the mark type.

57). Whenever a Measure is drag and dropped onto a shelf, it does a SUM. How would a user change it to a Median? *Practice in Bronze Study Workbook 
Ans: Right click on a measure (green) or column shelf and choose 'Measure->Median'

58). How would a user replace a measure or dimension on the rows or columns shelf?
Ans: Drag and drop field over the current field on the shelf. The new field will replace the other field.

59). What is a group in Tableau Desktop? Why is it important? 
Ans: A group is a combination of dimension members that make higher level categories.
In Tableau there isn't any coding or scripting required to group. Other software grouping can require coding or scripting which is difficult and time consuming.

60). What are the benefits of a discrete date vs. a continuous one? 
Ans: Treating dates as a continuous quantity is particularly useful in Gant bars or to see trends using line charts.

61). CLICK HERE FOR SET-7(Q-61 to Q70)

TOP 80 TABLEAU INTERVIEW QUESTIONS ANSWERS FOR FRESHER SET-5

This is SET-5, to read from start click here This set contain top 10 tableau interview questions answer.
Our last article is about Power BI Interview Questions , powerBI growing very fast these days, So If you are preparing for Tableau then must through PowerBI Interview questions as well, because interviewer can ask some question related to PowerBI.

TOP TABLEAU INTERVIEW QUESTIONS FOR FRESHER AND EXPERIENCED

41). How are the Tableau Personal and Professional, different from each other?
Ans: Personal is the same as Professional except:
1. Personal only connects to flat files (Excel, Access, CSV, and Tableau Data Extract.)
2. Personal can't publish to Server.

42). Can Tableau Desktop be install on a Mac OS?
Ans: Yes, Tableau Desktop can be installed on both Mac and Windows operating systems.

43). What API support does Tableau offer?

  1. Tableau Data Extract API: Create a program to bring data from a non-supported data source into Tableau. The program will automate Tableau Data Extract data-source creation.
  2.  Javascipt API: For deeply embedding vizzes inside intranet/extranet applications. Developers creating web applications can integrate fully interactive Tableau content into their applications via the new JavaScript API.
  3.  Rest API: Representational State Transfer API. For server automation such as user/group replication, life-cycle management, portal wrappers.

44). What languages does Tableau support? 
Ans: English, French, German, Brazilian, Portuguese, Spanish, Simplified Chinese, Korean, Japanese

45). What is the difference between "Connect Live" and "Extract"?
Ans: Connecting Live: Connecting Live to a database leverages its computational processing and storage. New queries will go to the database and are reflected as new or updated within the data.
Extract: An Extract will make a static snapshot of the data to be used by Tableau's data engine. The snapshot of data can be refreshed on a recurring schedule as a whole or incrementally append data. One way to set up these schedules is via Tableau Server.

46). What's the maximum number of rows Tableau can utilize at one time?
Ans: Tableau is not restrained by the number of rows in a table.
Customers use Tableau to access petabytes of data because it only retrieves the rows and columns needed to answer your question. Let me share some customer use cases focusing on big data.

47). What is the Tableau data engine?
Ans: Data engine is really a cool feature of Tableau. It's an analytical database designed to achieve instant query response, predictive performance, integrate seamlessly into existing data infrastructure, and is not limited to loading entire data sets into memory. If you work with a large amount of data it takes some time to import, create indexes and sort data but after that every thing speedup. Tableau data engine is not really in-memory technology. The data is stored in disk after imported and then RAM is hardly utilized. This conception brings the desired performance.

48). A Customer can't connect to their data. What is the procedure to set them up for a solution?
Ans: Have the customer share the error message they're receiving with you and Tableau's technical support. Try to troubleshoot the error on the fly, but if you also want to completely solve the issue. Schedule additional support if needed.

49). What is Metadata in Tableau?
Ans: Data that describes other data.
Meta is a prefix that in most information technology usages means "an underlying definition or description." Metadata summarizes basic information about data, which can make finding and working with particular instances of data easier.

50). What are semantic layers?
Ans: Semantic Layers are a business representation of corporate data that helps end users access data autonomously using common business terms.
Simplifying complex data into familiar business terms such as product, customer or revenue.

51). CLICK HERE FOR SET-6(Q-51 to Q60)

Monday, 9 November 2015

TOP 80 TABLEAU INTERVIEW QUESTIONS ANSWERS FOR FRESHER SET-2


This is SET-2, to read from start click here This set contain top 10 tableau interview questions answer. To read more click on continue button in the bottom of this post.
Our last article is about Power BI Interview Questions , powerBI growing very fast these days, So If you are preparing for Tableau then must through PowerBI Interview questions as well, because interviewer can ask some question related to PowerBI.

TABLEAU INTERVIEW QUESTIONS - ANSWERS SET-2 (Q-11 to Q-20)

11). What is disadvantage of context filters?
Ans: *The context filter is not frequently changed by the user – if the filter is changed the database must recompute and rewrite the temporary table, slowing performance.
*When you set a dimension to context, Tableau creates a temporary table that will require a reload each time the view is initiated. For Excel, Access and text data sources, the temporary table created is in an Access table format. For SQL Server, MySQL and Oracle data sources, you must have permission to create a temporary table on your server. For multidimensional data sources, or cubes, temporary tables are not created, and context filters only define which filters are independent and dependent.

12). How To remove the All options from a Tableau auto-filter ?
Ans: Right click filter >> customize >> uncheck show all option

13). Can we use non-used columns (Columns which are not used in reports but data source has columns) in Tableau Filters?
Ans: Yes!
Ex: In data source I have column like empID,EmpName,EmpDept,EmpDesignation,EmpSalary
In reports I am using empname on columns and empsalry on rows.
I can use empDesignation on Filters

14). What is benefit of tableau extract file over the live connection?
Ans: Extract can be used anywhere without any connection and you can build your own visualizations without connecting to Database.

15). How to combine two excel files with same fields but different data (different years)?
Ans: I have 5 different excel files(2007.xls, 2008.xls.. 2011.xls) with same fields(film name, genre,budget, rating, profitability) but with data from different year(2007 to 2011). Can someone tell me how can I combine the film name, genre and profitability so that I can see the visualization of 2007 to 2011 in a singe chart ?
Ans: http://community.tableau.com/thread/156217

16). Max no of tables we can join in Tableau?
Ans: We can join max 32 table, it’s not possible to combine more than 32 tables.

17). What is the difference between joining and blending in Tableau?
Ans: http://www.interviewquestionspdf.com/2015/03/what-is-difference-between-joining-and.html

18). What are Dimensions and Facts?

Ans: Dimentions is nothing but the descriptive text columns and facts are nothing but mesures (numerical values).dimention ex:productname city..facts:sales ,profit

19). Can we place an excel file in a shared location and use it to develop a report and refresh it in regular intervals?
Ans: Yes you can do it.. but for the better performance use extract

20). What is the difference between heat map and tree map?
Ans: A heat map is a great way to compare categories using color and size. In this, you can compare two different measures. Tree map is a very powerful visualization, particularly for illustrating hierarchical (tree-structured) data and part-to-whole relationships.
21). CLICK HERE FOR SET-3(Q-21 to Q30)

TOP 80 TABLEAU INTERVIEW QUESTIONS ANSWERS FOR FRESHER/EXPERIENCED SET-4

This is SET-4, to read from start click here This set contain top 10(out of 80) tableau interview questions answer. To read more click on continue button in the bottom of this post.
Our last article is about Power BI Interview Questions , powerBI growing very fast these days, So If you are preparing for Tableau then must through PowerBI Interview questions as well, because interviewer can ask some question related to PowerBI.

TABLEAU INTERVIEW QUESTIONS - ANSWERS SET-4 (Q-31 to Q-40)

31). What are the similarities and differences between Tableau software and Palantir?
Ans: Palantir and Tableau are very different.  Palantir has its roots in large data computer science problems involving security, payments, fraud detection and the likes.  Customers/Investors include Paypal, CIA and others.
Tableau is a visualization player - with roots in Stanford U research.  It's Visual Query Language (VizQL) allows users to build visualizations on top of standard data warehouses or spreadsheets.

32). How to create cascading filters without context filter ?
Ans: I have filter1 and filter2..Based on filter1 I need to filter2 data
Ex: Filter1 as Country and Filter 2: States
I have chosen country as INDIA and filter2 should display only INDIA states
Choose options of Filter2 states :
select option of "Only relevant values "

33). Is Tableau Software good for a strategic acquisition?
Ans: Yes for sure!
It gives you data insight to the extend that others don't.
Helps u plan and point the anomalies and improvise your process for betterment.

34). How to display top 5 and last 5 sales in same view?
Ans: Using filters or calculated fields we can able to display the top 5 and last 5 sales in same view?

35). Design a view to show region wise profit and sales.I did not want line and bar chat should be used for profit and sales. How you will design and please explain?

Ans: Generate the Map using cities -->then Drag the Profit and sales to the Details-->Add the state as Quick filter

36). Design a view in a map such that if user selects any state the cities under that state has to show profit and sales.
Ans: If you want to show the Sales and profit in each and every city under the states in the same work sheet.
According to your question you should have State, City, Sales and Profit filed in your dataset.
1. Double click on the State filed.
2. Drag the City and drop into Marks card (under the State fied)
3. Drag the sales and drop into size.
4. Drag the profit and drop into color.
5. Click on Size legend and increase the size.(75%)
6. Right click on the State field and select show quick filter.
7. Select any state and check whether you got the required view or not.
In this view size indicates the amount of sales and color indicates the Profit values

37). Suppose my license expires today, can users able to view the dashboards or workbook which i published in server earlier.
Ans: If your server license expires today, your user name on the server will have the role 'unlicensed' which means you cannot access, but others can. The Site Admin can 'Change Ownership' to another person, so extracts if enabled do not fail.

38). Think that I am using Tableau desktop and have a live connection to Cloudera hadoop data. I need to press F5 to refresh the visualization. Is there anyway to automatically refresh the visualization every x minutes instead of pressing F5 every-time?

Ans: Here is the example of refreshing dashboard in every 3 seconds,
Replace api src and server url with yours. The interval below is for 3 seconds.

<!DOCTYPE html>
<html lang="en">
  <head>
  <title>Tableau JavaScript API</title>
  <script type="text/javascript" src="http://servername/javascripts/api/tableau_v8.js"></script>
  </head>
  <body>
  <div id="tableauViz"></div>
<script type='text/javascript'>
var placeholderDiv = document.getElementById("tableauViz");
  var url = "http://servername/t/311/views/Mayorscreenv5/MayorScreenv2";
  var options = {
    hideTabs: true,
    width: "100%",
    height: "1000px"
  };
  var viz = new tableauSoftware.Viz(placeholderDiv, url, options);
setInterval(function () {viz.refreshDataAsync() }, 3000);
</script>
</body>
</html>

39). How to add custom Color to Tableau?
Ans: Create Custom Color code in "Preferences.tps"
Navigation ::: Documents >> My Table Repository >>Preferences.tps
Add custom color code
Note: In tableau 9.0 version we have color picker option..
So problem solved.

40). How can we combine database and flat file data in tableau desktop?
Ans: Connect data two times, one for database tables and one for flat file. The Data->Edit Relationships
Give a join condition on common column from db tables to flat file

41). What is disaggregation and aggregation of data?
Ans: http://www.interviewquestionspdf.com/2015/05/tableau-interview-question-what-is.html

42). CLICK HERE FOR SET-5(Q-42 to Q50)

TOP 80 TABLEAU INTERVIEW QUESTIONS ANSWERS FOR FRESHER SET-3

This is SET-3, to read from start click here This set contain top 10(out of 80) tableau interview questions answer. To read more click on continue button in the bottom of this post.
Our last article is about Power BI Interview Questions , powerBI growing very fast these days, So If you are preparing for Tableau then must through PowerBI Interview questions as well, because interviewer can ask some question related to PowerBI.

TABLEAU INTERVIEW QUESTIONS - ANSWERS SET-3 (Q-21 to Q-30)

21). What is the difference between twb and twbx file extensions. Please explain.
Ans: .twb is a live connection, it points to the data source; the user receiving .twb needs permission to said data source and no data is included. .twbx takes data offline, stores the data as a package or zip like file, thereby eradicating the need for permissions from end user; it's now a snapshot in time of the data as of the time it was Saved As .twbx

22). What is dual axis?
Ans: To display two measure in one graph.
Navigation : choose options for any measure -->Choose dual axis.

23). What is blended axis?
Ans: Multiple Measures are shown in single axis and also all the marks shown in single pane
Drag a dimension in a column
Drag the first measure in column
drag 2nd measure in existing axis
http://onlinehelp.tableau.com/current/pro/online/mac/en-us/multiplemeasures_blendedaxes.html

24). What makes Tableau software stand out?

Ans: In my view, Tableau stands out for several reasons:
First, most of the BI tools out there are pricey.  However, Tableau has a free offering (Tableau Public) as well as a very popular (also free) academic distribution.
Tableau is well recognized by firms like Forrester research to be one of the most easy to use, and agile products currently available. see here:   Tableau Ranks #1 in The Forrester Wave: Advanced Data Visualization (ADV) Platforms  That makes it easy to pick up and try new things with, which data visualization people love about it.
On the other hand, unlike some of the other BI tools, Tableau is not a complete technology stack, it is most useful for visualization and analytics.  - you will need other products in addition to tableau for heavier enterprise data ETL, maintenance, and storage, etc.
http://www.tableau.com/about/blog/2012/7/tableau-ranks-1-forrester-wave-advanced-data-visualization-adv-platforms-18522

25). How do we do testing in Tableau?
Ans: You can't test in Tableau as far as I know. It is a data visualization software.

26). In Dashboard, if we right click on the view, we can able to see delete option and some times we can't, What would be the reason?
Ans:

27). Can you get values from two different sources as a single input into parameter?
Ans: No you cannot. Each data source corresponds to a Tableau workbook. If you include both data variables in the same data source you can input them in the same workbook.

28). How many ways we use parameters in Tableau?
Ans: We can use parameters with filters,calculated fields ,actions, measure-swap, changing views and auto updates

29). What is the use of new Custom SQL Query in tableau?

Ans: Custom SQL Query written after connecting to data for pulling the data in a structured view, One simple example is you have 50 columns in a table, but we need just 10 columns only. So instead of taking 50 columns you can write a sql query. Performance will increase.

30). What are the differences between Tableau Software and Traditional BI tools?

Ans: Tableau provides easy to use, best in class, Visual Analytic capabilities, but it does not help with the plumbing (data foundation). You could, for example, marry SQL Server with Tableau to get the complete package. Tableau licenses are relatively expensive if you are looking to scale.
Traditional BI can handle it all but with significant upfront costs. Higher consulting, hardware and software costs. Among the mega-vendors, only Microsoft can provide a reasonable value proposition. Open source vendors like Pentaho and JasperSoft do not have an abundant enough talent pool, yet.

31). CLICK HERE FOR SET-4(Q-31 to Q40)

SQL SERVER QUIZZES TEST/PDF FOR FRESHERE | VERY BASIC - SET 1

Here we come with Sql server quiz for fresher only, who are very new to sql server, can try there knowledge. Here are top 15 questions with answers, first try to answers them then you can see the answers at the top.

Answers:
15) DESC, 14) Diagram, 13) Query Designer, 12) Management Studio, 11) Dialect,
10) One-to-many, 9) Foreign key,8) DDL,7) T-SQL, 6) Type, 5) Cell, 4) Primary key, 3) Tables, 2) Network, 1) Sql query,

SQL SERVER QUIZ FOR FRESHER SQL DEVELOPERS

1). To retrieve or update the data in a database, the client sends a/an ______ to the database

2). The three main hardware components of a client/server system are the clients, the server, and the ____________

3). A relational database consist of one or more ______

4). A ______ uniquely identifies each row in a table

5). The intersection of a row and a column is commonly called a/an ______

6). When a column in a table is defined, it is given a data ______ that determines what kind of data it can store

7). The SQL dialect that Microsoft SQL Server uses is called ___

8). SQL statements that define the tables in a database are referred to as _______ statements

9). To relate one table to another, a/an ________ in one table is used to point to the primary key in another table

10). The most common type of relationship between two tables is a/an ________ relationship

11). Although the American National Standards Institute (ANSI) published the specifications for a standard SQL language, each DBMS vendor has its own ______ of SQL

12). The ________ is a graphical user interface for working with the objects in a SQL Server database

13). Within the Management Studio, you can build a SQL statement without having to write your own code by using the _______

14). A database _______ is a schematic drawing that shows you the relationships between the tables you're working with

15). To sort the records that are retrieved by a SELECT statement in descending sequence by InvoiceTotal, you code ___________ after ORDER BY InvoiceTotal.

Pdf will be available soon..

TRICKY SQL INTERVIEW QUERIES QUESTIONS ANSWERS FOR EXPERIENCED SQL DEVELOPERS

Hey guys, I am writing this post after many days, after many comment by SQL Guys, Every one want to see new post related to SQL Interview questions, I have already written many Sql interview queries, In the bunch which are related, So the visitor looking for new queries so in this post, at a time I cant post many but, keep posting new query which I will face.
So for new tricky queries I need you help, If you have any tricky Sql queries then please post as a comment. It will be helpful for other.

So lets discuss new a query, This is not new but little bit tricky.

Query : There are two tables T1 and T2 with two columns, I want to swap the name of both tables, based on ID column. How you will do that.
Tables:


Ans:
--First copy T1 data in to temp table
SELECT * INTO #T1 FROM T1
--Then Update T1 with T2
UPDATE T1 SET T1.NAME = T2.NAME FROM T1 INNER JOIN T2 ON T1.ID = T2.ID

--Then Update T2 With Temp talbe(#T1)
UPDATE T2 SET T2.NAME = #T1.NAME  FROM T2 INNER JOIN #T1 ON T2.ID = #T1.ID

DROP TABLE #T1 --Drop temp table Table

Output after run the above queries.
If you have another solution then please comment.. I will post here..

TOP 40 EMAIL MARKETING / DIGITAL MARKETING INTERVIEW QUESTION WITH ANSWERS PDF DOWNLOAD

Hey guys this time we come with Email/Digital marketing interview questions with answers, Here are 40 most frequently asked email marketing related interview questions. You can also download the complete set as a PDF.
Please give your feedback

1). What do you understand by term Marketing?
Ans: Marketing is an organizational function and a set of processes for creating, communicating, and delivering value to customers and for managing customer relationships in ways that benefit the organization and its stakeholders.

2). What is Digital marketing?
Ans: Digital marketing is an umbrella term for the targeted, measurable, and interactive marketing of products or services using digital technologies to reach and convert leads into customers.The key objective is to promote brands, build preference and increase sales through various digital marketing techniques.

3). What is Opt-in (or Subscribe) email marketing?
Ans: To opt-in or subscribe to an e-mail list is to choose to receive e-mail communications by supplying your e-mail address to a particular company, website or individual thereby giving them permission to e-mail you. The subscriber can often indicate areas of personal interest (e.g. mountain biking) and/or indicate what types of e-mails she wishes to receive from the sender (e.g. newsletters).

4). What is Opt-out (or Subscribe) email marketing?
Ans: Opt-out (or Unsubscribe) To opt-out or unsubscribe from an e-mail list is to choose not to receive communications from the sender by requesting the removal of your e-mail address from their list.

5). What is the difference between single opt-in and double opt-in?
Ans: Double-opt in - rather than immediately adding an email address to the list upon signing up (single opt-in), this sends a confirmation email ad only adds the user's email address to the list when the user confirms that they want to receive emails.

6). Can you use email marketing for hospitals, Is email marketing good way?
Ans: Absolutely. Email marketing for hospitals can help you to reach people interested in healthy tips. People will be definitely more interested to hear the advice from a doctor than blogger.

7). How you keep in mind when writing good email for marketing purpose?
Ans: Good email content deepens your relationship with your audience through effective subject line writing (getting your messages opened), your distinctive voice (getting those messages read), and delivering quality, niche specific content your prospect needs and shares with others (inspiring referrals and word-of-mouth).

8). How does email marketing work?
Ans: For email marketing to work, very first thing required is that, you must have own email list collected over time from you online / offline product or services.
Once, you have list of emails, you can start building relationship with your target leads through email marketing automation by using tools like, Aritic. Once, the leads are converted and using your product / service, then you need to write useful, engaging content/email and frame it into nice aesthetics. then you can send email newsletters by using services like Ariticmail.

9). Name any 3 email service provider?
Ans: •MailChimp
•Constant Contact
•Aweber
•GetResponse
•iContact
•Vero
•Vertical Response

10). How do you get a genuine email database/world mailing list/world email list for email marketing?
Ans: You can speak with a reputable data provider. Once you provide them with the criteria you're looking for they should be able to satisfy your needs.

11). What are the format types of a marketing email?
Ans: 1.Plain text
2.HTML
3.Rich Media

12). What are the activity performed for Digital marketing?
Ans: 1) Search engine optimization
2) Search engine marketing
3) Content marketing
4) E-commerce marketing
5) Social media marketing
6) E-mail direct marketing
7) Display advertising
8) E–books

13). How to write emails that Get opened every time?
Ans: The basics of email personalization look something like this:
1. Use the recipient's name in the email
2. Talk on common grounds
3. Make your point clear
4. Keep it short

14). Why choose email marketing?
Ans: Cheap, wide range, close relationship, higher roi, measurable

15). What is inbound marketing? How it can bolster your company?
Ans: Inbound Marketing is getting target customers to come to you instead of going to them.
A cold call to a prospective customer is Outbound Marketing.
A blog post that attracts a prospective customer through search, social or other channel is Inbound Marketing.
But Inbound Marketing can be more than just blogging. It's anything you can do to get a target customer to come to you.
That can involve all sorts of content including:
Blogging
Ebooks
Videos
Podcasts
Public Relations

16). How email marketing is big business?
Ans: There are 32.2 billion email customers in the world, 95 percent of online consumers use email, 91 percent of consumers reported checking email at least once a day For every one dollar or return on investment-ROI, on email marketing investment.

17). What do you understand by CTR?
Ans: The percentage (the number of unique clicks divided by the number that were opened) of recipients that click on a given URL in your e-mail.

18). What do you understand by hard bounce email?
Ans: A hard bounce is an e-mail message that has been returned to the sender because the recipient's address is invalid. A hard bounce might occur because the domain name doesn't exist or because the recipient is unknown.

19). Differences between a hard bounce and a soft bounce?
Ans: Your email can bounce for a variety of reasons:
Unknown User. The part of the email address before the @ is incorrect or expired)
Over Quote. The recipient's mailbox is full.
Domain Error. The part of the email address after the @ is incorrect.
Spam. Your message was considered spam.
Too Large. Your message was too big (most likely images or attachments).
Of the above reasons, "Unknown User" and "Domain Error" are considered "hard bounces"—this means the email address is no longer valid and should be removed from your list.

The other bounces are considered "soft", because the address may begin to work again at some point in the future. For example, the recipient might clear out his or her mailbox and thus free up some room in their quota. You can safely leave these recipients your list and Direct Mail will try them again the next time you send.

20). What is E-zine?
Ans: An ezine is an electronic magazine emailed to a list of subscribers. Advertisers pay to have their ad (text, HTML or both depending on the publication) inserted into the body of the email. Buying ad space in an e-zine or email newsletter, or sponsoring a specific article or series of articles allow advertisers to reach a targeted audience driving traffic to a website, store or office, signups to a newsletter or sales of a product or service.

21). What is the best day of the week to send an email and why?
Ans: Tuesday may get the best response - this is what often seen in B2B marketing, it perhaps reflects Monday/Friday being meeting days. Tuesday is usually peak day for web traffic too.

22). When do people most check their emails?
Ans: Morning and lunch hour

23). What is email spoofing?
Ans: Email spoofing is the creation of email messages with a forged sender address. It is easy to do because the core protocols do not have any mechanism for authentication. It can be accomplished from within a LAN or from an external environment using Trojan horses.

24). WIIFM or "What's In It For Me?"
Ans: The question at the forefront of every email recipient's mind when making a decision to open, read and take action on your email (e.g. click on a link, call for an appointment, visit an office or retail location).

25). What do you understand by "Open Rate" in email marketing?
Ans: The email open rate is a measure primarily used by marketers as an indication of how many people "view" or "open" the commercial electronic mail they send out. It is most commonly expressed as a percentage and calculated by dividing the number of email messages opened by the total number of email messages sent (excluding those that bounced.)

26). What is Email Spam?
Ans: By definition, email spam is any email that meets the following three criteria:
Anonymity: The address and identity of the sender are concealed
Mass Mailing: The email is sent to large groups of people
Unsolicited: The email is not requested by the recipients

27). What do people like to sign up for?
Ans: Free offers

28). Give 3 examples of free things you can provide?
Ans: Event tourguide/grounds map, schedule, coupons

29). What is RSS Feeds?
Ans: Sending the blog updates (much better then using the blog subscriber because the blog owns the list not you)

30). Three examples of words to use in a subject line?
Ans: Apply, opportunity, demo

31). Three examples of words not to use in a subject line?
Ans: Confirm, join, assistance

32). What do you understand by "White list"?
Ans: List of accepted email addresses that an ISP, subscriber or other email service provider allows to deliver messages regardless of spam filter settings

33). What are the advantages of email marketing?
Ans: -Cost effective
-Timely
-Personalized/targeted messages
-Can track user engagement

34). What are the disadvantages of email marketing?
Ans: -Hard to manage customer lists
-Undeliverable email
-Low effectiveness
-Spreading viruses
-Battling filters
-Angry recipients

35). What do you understand by Business to Business (B2B)?
Ans: When businesses sell products/services to other businesses not consumers.

36). What do you undestand by Business to Consumers (B2C)?
Ans: When businesses sell products/services to consumers.

37). What is Sender Policy Framework (SPF)?
Ans: An extension of SMTP that stops email spammers from forging the "From" fields in an email.

38). What are the current email marketing challenges of many firms?
Ans: 1) integrating email data with other data systems
- solution: focus on behavioral segments and tailor information to their needs/interests as shown through their online behavior
2) improving deliverability
- solution: regular maintenance (regularly remove inactive email addresses from your email list); use the double-opt in process; and give subscribers the chance to update their email address
3) growing and retaining subscribers
- solution: clear value proposition in email opt-in; segment the list to make your emails more targeted; optimize and test various elements in your email
4) achieving measurable ROI
- solution: closed-loop marketing (define)
5) using email for funnel optimization
- solution: lead nurturing (define)

39). How email is still effective?
Ans: 1. people check emails everyday
2. no other marketing channel has been adopted as universally. everyone has an email account!
3. email is a channel that you own
4. 77% of consumers prefer email for marketing communications.
5. Email lets you be highly personal.
6. it has an ROI of 4300%.

40). How do you keep your email lists healthy and growing?
Ans: Supplement your email marketing with blog posts and content.

Sunday, 8 November 2015

Hungry Jack's Interview Questions and Answers PDF Australia

Glassdoor: Hungry Jack's Crew Member Interview Questions with Answers(pdf) 2014-15 for Fresher and Experienced 

Here we are come with the interview questions asked in Hungry Jack's interview, with the help of Glassdoor.com.
These are real time interview questions which are faced by many Crew Member which face welkin in Hungry Jack's for the position of "Crew Member".


Q) Tell me about yourself.
Ans: Simply tell about yourself

Q) Why Hungry Jack's ?
Ans: They have a good training process that helps its crew members work together as a team.

Q) If required are you willing to work till late night ?
Ans: Yes, Sir. I would like to contribute as much as I can.

Q) What would you do if the customer gets angry and throws a fit or throws a scene ?
Ans: I would keep calm and immediately apologize

Q) What does respect mean to you?
Ans: Respect means different things to different people so answer with what you think it means to you. There is no right or wrong answer

Q) When was a time you had to help an angry customer - difficult for me as this was my first job and I think would be most people's.
Ans: I said I had never been in that position but if I would have I'd have done this, this and this.

Q) How will this job benefit your career in the future? Why do you want to work here?
Ans: It would give me the chance to meet new people and learn how to work on a team.

Q) What would you like to earn by working here? 
Ans: Experience

Q) What kind of service is better? Fast or friendly? 
Ans: I said friendly because if there was a delay on the food but you were friendly they would be willing to wait where as if the service was fast with no interaction with the customers then it wouldn't give the restaurant a good loom. The manager understood what I meant and he said its better to have a bit of both. He said whilst working in Hungry Jack's you'll learn how to balance this but some people are still get to learn.

Q) How would you handle unruly customers?
Ans: I would first try to handle the situation the best i could without him becoming upset. should this occur I would find the nearest manager and allow them and there trained expertise handle the situation.

Q) What I would do to bring more customers to the company.
Ans: What they would like to hear relates to every worker potential. How can you, as a part time after school team member help bring more customers to the company? By smiling warmly, listening attentively to them, getting a solution if they have an issue, ensuring they get their food hot, fresh and fast, ensuring they have a clean restaurant - and safe restaurant - to dine and relax in. Your attitude, speed and positivity is what will cause each customer to return again and again. The more money coming into the store, the better your future raises and promotions. The base job title for every single employee in every single job in the world is 'team' member. You all work as a team to give the best customer experience you can. This increases profits for all.

Q) Why did you leave your previous job ? 
Ans: Relocated

Q) How would you greet a customer ?
Ans: "How may I help you?"
It seems to me that such a question would be covered in your training, but I've been wrong before. Plus if you can't answer that question correctly without any formal training, this job might not be for you.

Q) Are you sure you want to work here, with all this   experience in desk jobs? This is not, sometimes dirty work, standing for the full shift. 
Ans: I get the "over-qualified" label a lot. I prefer to think of myself as "highly motivated." I've been unemployed for a while, now, and need to get something to bring in some money. Besides, I had children. Sweat and dirt don't scare me anymore.

Q) Convince me to hire you.
Ans: I learn quickly. I'm a great listener and I can get things done right.

Q) Would you clean the bathroom if I tell you to ?
Ans: "Yes, sure"
After then, every time the bathroom is dirty, it's on me. I said yes only because it was my first job interview and didn't know how to say no.

Q) What traits do you possess that would be useful for this   position ? 
Ans: Patience, Quick-thinking, and Understanding

Q) What is the one thing that draws you the most to Hungry Jack's? 
Ans: The dynamic of the working environment.

Q) What would you do if there was an upset long line of   customers and how would you help and provide faster service efficiently ?
Ans: I would address everyone in the line and assure them that I am trying to provide the best service possible and I will call someone to assist the customers with me

Q) What can you do to improve our store ? (Or some variation of   this question)
Ans: I'll make sure to follow procedures to save time and product as well as learn the various positions of the store's operation to ensure that I become an asset to your restaurant.

Q) What would you do if you saw one of your coworkers out in   the lobby socializing with their friends ? 
Ans: Tell them that they need to get back to work, and that there is an appropriate time for said interactions.

Q) Who is my crush ? 
Ans: Hoping that i will be succeeded.

Q) How would you avoid overcharging or forgetting an order   ? Sometimes the customer is trying to trick you and sometimes it was an honest mistake...what do you think is the right approach ?
Ans: The right approach is to treat every situation as if it were an honest mistake. Ultimately the customer is always right and going the extra mile to refund them their money or replace their food will go a long way. Double checking your work quickly as you go, checking receipts, and repeating back orders to a customer are all ways that mistakes can be minimized.

Q) How would you react to a customer using harsh language to   both yourself and the manager ?
Ans: I would remain calm and continue to let the manager handle the situation until the manager would tell me to interfere in the situation.

Q) How much customer traffic do you expect during the night   shift, relative to the day shift ?
Ans: Below average.

Q) Where do you see yourself in 5 years ? 
Ans: Like I said before, be honest. If you see yourself long gone from Hungry Jack's in 5 years, be sure to let them know that you have bigger plans in your life. Be sure not to blab on, and keep answers short and sweet.

Q) If confronted about an illegal action being done at the   work place, what would you do ? 
Ans: That wouldn't happen! and If i was confronted about an illegal action being done at the workplace by fellow co-workers i would tell the truth. And if it was me doing something wrong, i would accept the criticism and try to do it better the next time round.

Q) Are you all right to receive orders from people younger   than you ?
Ans: yes, experience matters, not ages.

Q) What are the worst qualities in you that can affect working   over here ? 
Ans: Don't start explaining your actual bad habits like you're lazy and you don't like to work. Start by something like you need a drink after every half hour.

Q) Would you tell a manager if your best friend stole something worth 4 dollars ?
Ans: For me it depends..

Q) What would you do if you caught someone stealing ?
Ans: I said I would tell someone in a higher position, such as a manager, instead of trying to interfere and deal with it myself.

Q) Working alone or with a team ?
Ans: I would like to work in an environment where there is a blend of both. Its great working in teams while sharing and learning ideas with each other, but it’s also great to sit at my own desk and work hard productively. Therefore I would like to work independently towards a team goal.

Q) How would you handle an angry customer ?
Ans: In order to keep your customers calm, you have to be calm. There is no way you'll be able to calm customers if you're yelling at them. Keep your clam, and just remember that they are going through a temporary tantrum.

Q) Give an example of how you would deal with a customer   complaining about their food taking to long ? 
Ans: Apologize- Remember that customer who was so upset over the long waiting line? Offer an apology. “I understand that you are not happy about the wait, sir, but we are working as fast as we can to get you a table. We really appreciate your patience and willingness to wait. Perhaps you would like to have a drink at the bar until your table is ready.” You demonstrate that you completely understand their frustration and are working diligently on a solution.

Q) How would I deal with a rude customer ?
Ans: Listen and be as polite as possible and figure out the best way to help them

Q) Why Hungry Jack's, when there are other fast food restaurants ?
Ans: I said I picked Hungry Jack's because it's one of the most loved and well known fast food restaurants, that people trust and know more, and I wanted to work for Hungry Jack's then any other.

Q) When are you available ?
Ans: Just say them "ANYTIME"

Find job here...