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"

Wednesday, 4 November 2015

TOP 50 R PROGRAMMING INTERVIEW QUESTIONS WITH ANSWERS PDF

TOP 50 R PROGRAMMING INTERVIEW QUESTIONS WITH ANSWERS PDF

Hey guys this time we came with R programming interview questions with answers, for them who want to make there career in Data(data science). Here are top 50 R programming interview questions, at the end of this post you will get the PDF file link from where you can download this list.

1). What is R programming language?
Ans: R is a programming language and software environment for statistical analysis, graphics representation and reporting. R was created by Ross Ihaka and Robert Gentleman at the University of Auckland, New Zealand, and is currently developed by the R Development Core Team.

2). Why this is named as R programming language?
Ans:This programming language was named R based on the first letter of first name of the two R authors (Robert Gentleman and Ross Ihaka), and partly a play on the name of the Bell Labs language S.

3). What is R used for?
Ans:R is used mostly for statistics and data modeling, but it is also used to extract data from graphics for analysis. It contains standard and recommended packages used for storing functions and data sets. R uses features from S, a statistical system that is commonly used by statisticians. S processes statistical analysisin series with only halfway results, but R will provide minimal output and store results for assessment later.

4). Does R allows integration with the procedures written in the C, C++, .Net, Python or FORTRAN languages for efficiency?
Ans:Yes

5). What are the main features of R?
Ans:Following important features of R:

  • R is a well-developed, simple and effective programming language which includes conditionals, loops, user defined recursive functions and input and output facilities.
  • R has an effective data handling and storage facility.
  • A collection of tools for analyzing data.
  • Effective for developing methods that require interactive data analysis.
  • R provides a suite of operators for calculations on arrays, lists, vectors and matrices.
  • R provides a large, coherent and integrated collection of tools for data analysis.
  • R provides graphical facilities for data analysis and display either directly at the computer or printing at the papers.
  • It includes objects, such as regression models, time series, and geo-spatia coordinates.
6). What do you understand by R-objects?
Ans:While doing programming in any programming language, you need to use various variables to store various information. Variables are nothing but reserved memory locations to store values. This means that when you create a variable you reserve some space in memory.In contrast to other Programming languages like C and java in R the variables are not declared as some data type. The variables are assigned with R-Objects and the data type of the R-object becomes the data type of the variable.

7). What are the frequently used R-objects?
Ans:
  • Vectors
  • Lists
  • Matrices
  • Arrays
  • Factors
  • Data Frames
8). Can you tell me some of the function that R provides?
Ans:The function that R provides are
  • Mean
  • Median
  • Distribution
  • Covariance
  • Regression
  • Non-linear
  • Mixed Effects
  • GLM
  • GAM. etc.
9). What is R Base package?
Ans:This is the package which is loaded by default when R environment is set. It provides the basic functionalities like input/output, arithmetic calculations etc. in the R environment.

10). What do you understand by Data Frame?
Ans:Data frame is a table or a two-dimensional array-like structure in which each column contains values of one variable and each row contains one set of values from each column.

11). Name some file format supported by R?
Ans:R can read and write into various file formats like csv, excel, xml

12). List out some most popular file format used in R programming language?
Ans:
  • .RDA files: These are saved R objects that are used to attaching and loading files. They use the .rda or .RData extension. Files with the .RData and the .rda extension are the same.
  • .R files: These files are created inside the R editor by the dump function. They include R commands. Some R files may also have the .q extension.
  • .TXT files: These are text files that are used to store datasets. R uses theread.table() function and thewrite.table function. R uses theread.table() for data input and reading from text files. It then automatically creates a data frame with it. Thewrite.table() function on the other hand is used to create the text files.
  • .CSV files: CSV or comma seprated values files are common data files typesinputted with theread.csv() function.
13). What is csv file, and how you can create it?
Ans:The csv file is a text file in which the values in the columns are separated by a comma. You can create this file using windows notepad by copying and pasting this data. Save the file as input.csv using the save As All files(*.*) option in notepad.
Example
id,Firstname,LastName
1,Vikas,Ahlawat
2,Amit,Arya

14). Which function is used to read csv file? can you give some example?
Ans: read.csv() function to read a CSV file available in your current working directory.
data <- read.csv("input.csv")
print(data)

15). What is the use of Scan() function?
Ans: The scan() function is used to read various types of data or data objects, for example data vactors. You can customize the command to read specific data. The command waits for input from the user and then return the value entered at the prompt.

16). What is the difference between an Array and a matrix?
Ans: A matrix is always two dimensional as it has only rows and columns. But an array can be of any number of dimensions and each dimension is a matrix. For example a 3x3x2 array represents 2 matrices each of dimension 3x3.

17). What is the output of runif(5)?
Ans: It generates 5 random numbers between 0 and 1

18). What is the use of apply() in R?
Ans: It is used to apply the same function to each of the elements in an Array. For example finding the mean of the rows in every row.

19). What is the latest version of R?
Ans: When this question written, R latest version is 3.2.2

20). How you will create an object in R?
Ans: Objects can be created in R by reading in data from a file or directly from the internet, by creation within a program, or through direct creation within R, as shown below:
Example:
x <-10
This will create an object called as x which has a value equal to 10

21). How you will create a function for divide two numbers, give example?
Ans: divider <- function(x,y){
result <-x/
print(result)
}

22). Can you give example of an array?
Ans: f<-c(1,2,3,4,5,6)

23). How you will make comment in R?, Example
Ans: A comment is easy to apply in R, via the hash symbol(#)
Example:
x<-10 #This is a simple object example

24). What command is used for stop/close R?
Ans: "q()"

25). Name some text editors for R?
Ans:
  • Tinn-R : This is an easy to use GUI text editor for R programming in Windows.
  • RKward : An easy to R text editor that works with GNU/Linux, Windows, and Mac OS X environments. It is an extensible IDE/GUI for R.
  • JGR: This is like Rstudio with similar GUI that integrates with the R command line console.
26). What is One-factor ANOVA?
Ans: The one-factor analysis of variance, or ANOVA, is used to compare the means of several
different groups on a single, quantitative outcome variable.
Example
# CREATE SIMULATION DATA
# Step 1: Each group in a separate variable.
x1 <- rnorm(30, mean = 40, sd = 8) # Group 1, mean = 40
x2 <- rnorm(30, mean = 41, sd = 8) # Group 1, mean = 41
x3 <- rnorm(30, mean = 44, sd = 8) # Group 1, mean = 44
x4 <- rnorm(30, mean = 45, sd = 8) # Group 1, mean = 45

27). What's the difference between "=" and "<-" in R?
Ans: The operators <- and = assign into the environment in which they are evaluated. The operator <- can be used anywhere, whereas the operator = is only allowed at the top level (e.g., in the complete expression typed at the command prompt) or as one of the subexpressions in a braced list of expressions.

28). What's the difference between seq_len() and seq_along() in the R programming language?
Ans:
seq_along(x): takes a vector for x, and it creates a sequence upto the count of elements in the vector.
seq_len(y): takes numeric for y, it creates a sequence upto the number y

29). What are the most popular R packages?
Ans:
  • Ggplot2
  • Plyr
  • Reshape
  • Lme4
  • RODBC
30). What is R-Forge?
Ans: R-Forge offers a central platform for the development of R packages, R-related software and further projects.

31). How can I sort the rows of a data frame?
Ans: To sort the rows within a data frame, with respect to the values in one or more of the columns, simply use order() (e.g., DF[order(DF$a, DF[["b"]]), ] to sort the data frame DF on columns named a and b).

32). What are the competitive benefits is using R for data analysis?
Ans: 6000 packages on CRAN spread across various domains of study.
Strong support on stackoverflow and good documentation reducing the learning curve for beginners
Availability of *almost all* machine learning packages
Incredible plotting system (ggplot2).
Give you exposure to the latest analytics techniques, including forecasting, socail network analytics and text mining.
Able to add-on to your existing analytics knowledge and methodology.

33). Mostly all thing which are done by R, can be done by other language like Java then why R?
Ans: R programming for data science can by use to acive following thing
1. Loading data from file or from database
2. Data exploration like summary,scatter plots , box plots etc
3. Processing data like fixing missing data.
4. Segregating data into Training and testing set
5. Creating a model based and predicting.
6. Validating your results.
7. Data visualization.
All the above can be done by mainstream programming languages like Java and C++ , but will be cumbersome but with R  all the above can be achieved in a fraction of seconds as  all these  functions are built in within R.

34). Why is R programming used instead of MS excel?
Ans: There are a number of reasons:
  • Excel can't deal with data sets that are too large to fit in the memory of a single machine, and there's no way to extend it to do so.
  • Excel's computation model is somewhat difficult to extend.  It's possible to use VBA to write your own functions, but the language is extremely simple, so it's going to take a lot longer to write anything complicated.
  • On a somewhat related note, we don't have good debugging tools for spreadsheets.  If you're getting the wrong answer, it's very hard to find out why.  R has much better tools for this.
  • Excel can't handle data that lives in more than two dimensions.  R has no problems with this.
  • Excel only provides the absolute bare minimum of statistical and text processing functions.  It doesn't even support regular expressions out of the box.
  • Furthermore, the implementations of Excel's statistical functions are somewhat suspect.
  • Excel's charts are limited to the small number that it provides.  I guess you can extend that too with VBA, but base R graphics and ggplot2 are much easier to use.
35). What are the most common methods used in R programming?
Ans: Personally, I use a lot of data frame manipulation routines like apply, subset and others. plyr is also my most commonly used module and it involves data frame manipulation too.

36). What does library() do?
Ans: Loading a package in order to make its functions/processes/dependencies available to the user. Just type
?library
and you will see the help for library ().

37). How to read selective lines in R programming language?
Ans: How do I read selective lines in R from an external file. For example: if the first column is a date, how do I read only lines between two given dates without reading the whole file into memory.
Ans:
Here's a workable, but non-robust solution -- others might have better ones:
This will store everything in a character variable called input_file:
input_file <- scan(file="x", skip = y, n = z, what = "raw", sep = "\n")
Replace x with file path
Replace y with the count of rows up to (but not including) the row that you want as the start date.
Replace z with the count of of rows up to (and including) the row you want as the end-date.
The option sep = "\n" specifies that each item is on a new row.
The option what = "raw" specifies that you're inputting a raw text file.

38). What's the difference between Hadoop and R Programming?
Ans: Hadoop is an open source framework user for distributed data storage and very huge data processing whereas R is a programming language used to form data science patterns and predictions.

39). How can I draw N beta distribution curves in one plot?
Ans: I was able to do this In R using the add property :
curve(dbeta(x,642,101),col="green");
curve(dbeta(x,1286,130),add=TRUE,col="blue");
curve(dbeta(x,2058,634),add=TRUE,col="orange");
curve(dbeta(x,2131,651),add=TRUE,col="brown");

40). What is the difference between package and library in R?
Ans: A package is a standardized collection of material extending R, e.g. providing code, data, or documentation. A library is a place (directory) where R knows to find packages it can use (i.e., which were installed). R is told to use a package (to “load” it and add it to the search path) via calls to the function library. I.e., library() is employed to load a package from libraries containing packages.

41). What machines/OS does R run on?
Ans: R is being developed for the Unix-like, Windows and Mac families of operating systems. Support for Mac OS Classic ended with R 1.7.1.

42). What do you understand by CRAN?
Ans: The "Comprehensive R Archive Network" (CRAN) is a collection of sites which carry identical material, consisting of the R distribution(s), the contributed extensions, documentation for R, and binaries.

43). What mailing lists exist for R?
Ans: Thanks to Martin Maechler(Martin Maechler is a member of R-Core), there are four mailing lists devoted to R.

R-announce :
  • A moderated list for major announcements about the development of R and the availability of new code.

R-packages :
  • A moderated list for announcements on the availability of new or enhanced contributed packages.
R-help :
  • The ‘main’ R mailing list, for discussion about problems and solutions using R, announcements (not covered by ‘R-announce’ and ‘R-packages’) about the development of R and the availability of new code.
R-devel :
  • This list is for questions and discussion about code development in R.
44). What are the differences between R and S?
Ans: Some known differences are the following.
  • In R, if x is a list, then x[i] <- NULL and x[[i]] <- NULL remove the specified elements from x. The first of these is incompatible with S, where it is a no-op. (Note that you can set elements to NULL using x[i] <- list(NULL).)
  • In S, the functions named .First and .Last in the .Data directory can be used for customizing, as they are executed at the very beginning and end of a session, respectively.
  • In R, T and F are just variables being set to TRUE and FALSE, respectively, but are not reserved words as in S and hence can be overwritten by the user. (This helps e.g. when you have factors with levels "T" or "F".) Hence, when writing code you should always use TRUE and FALSE.
  • In R, dyn.load() can only load shared objects, as created for example by R CMD SHLIB.
  • In R, attach() currently only works for lists and data frames, but not for directories. (In fact, attach() also works for R data files created with save(), which is analogous to attaching directories in S.) Also, you cannot attach at position 1.
  • Categories do not exist in R, and never will as they are deprecated now in S. Use factors instead.
  • In R, For() loops are not necessary and hence not supported.
  • In R, assign() uses the argument envir= rather than where= as in S.
  • The random number generators are different, and the seeds have different length.
  • R passes integer objects to C as int * rather than long * as in S.
  • R has no single precision storage mode. However, as of version 0.65.1, there is a single precision interface to C/FORTRAN subroutines.