Download Qlik Sense Business Analyst Certification Exam Questions and Answers and more Exams Business Informatics in PDF only on Docsity!
QLIK BUSINESS ANALYST CERTIFICATION EXAM |
ALL QUESTIONS AND CORRECT ANSWERS |
GRADED A+ | VERIFIED ANSWERS | LATEST EXAM
While traveling, a business analyst checks email on a tablet and receives a CSV file which needs to be immediately loaded into new Qlik Sense Applications for different analysis by various teams. The file is also saved in the company shared folder. How should the applications be created and shared with the various teams? A. Create the application on Qlik Sense Enterprise and upload to Qlik Sense Cloud B. Create the application on Qlik Sense Desktop and upload to Qlik Sense Cloud C. Create and share the application on Qlik Sense Enterprise D. Create and share the application on Qlik Sense Desktop --------- CORRECT ANSWER-----------------C Why should a business analyst add useful descriptions to master items? A. To make it easier to find the right master item because descriptions are searchable B. To provide users additional information and context when adding master items to a sheet items to a sheet C. To provide users additional information and context when viewing the visualization D. To provide users additional information to help design a visualization ---- -----CORRECT ANSWER-----------------B Which of the following statement describes a master item?
A. Master items are only available in published apps B. A master item is an aggregation function that can be used throughout the whole app C. A master item is a visualization object that can be used in multiple apps D. Master items are reusable assets that can be used throughout the app -- -------CORRECT ANSWER-----------------D A business analyst needs to build two bar charts side-by-side. The charts use a common dimension but each chart has different measures. The Analyst needs to create a visual link between the two charts for the dimension. Which is the easiest method to meet this requirement using color? A. Use the FieldIndex function to set the colors by expression for each of the dimension values B. Select "By dimension" and Persistent colors" in the Colors property panel C. Use a series of IF statements to set the colors by expression for each of the dimension values D. Update the data model to set colors for each of dimension values --------- CORRECT ANSWER-----------------B A business analyst needs to add an image a sheet using text object. Which object properties should the analyst consider? A. Position, content library, responsive behavior B. Responsive behavior; size; position C. Data;size;Master Item D. Content library; master item; size ---------CORRECT ANSWER------------- ----B
B. Import the images into the appropriate content library, then copy the CountrySales app and publish a copy into each stream C. Publish the CountrySales app into each stream D. Import the images into the appropriate content library and publish the CountrySales app into each stream ---------CORRECT ANSWER-------------- ---A What are the three ways of creating a Master dimension or measure? ------- --CORRECT ANSWER-----------------1. Master Items section in Asset Panel
- Fields section in Asset Panel
- Data Model Viewer When is the Field section in the Asset Panel not available within an app? --- ------CORRECT ANSWER-----------------When an app is published What are the sections within the Asset Panel? ---------CORRECT ANSWER-----------------Charts, Custom Objects, Master Items, and Fields What are some key differences between Desktop and Enterprise version of Qlik Sense? ---------CORRECT ANSWER-----------------1. Extensions, images and apps must be copied to a specific directory on the local Hard Drive in desktop but in Enterprise, they must be imported via QMC into Content and Media library
- Sharing of apps is different. In Desktop, QVF files need to be sent to other users whereas in Enterprise, apps can be accessed online.
- In Enterprise, data connections need to be granted to users whereas in desktop, users have access to all data connections
What's a Line Chart and what are the # of dimensions and measures supported? (Options 1, 2, 3) ---------CORRECT ANSWER----------------- Display trends of a given measure or measures over time. Option 1: 1 Dimension, 1 Measure Option 2: 1 Dimension, Multiple Measures Option 3: 2 Dimensions, 1 Measure What's a KPI and what are the # of dimensions and measures supported? (Options 1, 2, 3) ---------CORRECT ANSWER-----------------Display one or two aggregated measure values. Option 1: 1 Measure Option 2: 2 Measures What's a Text & Image chart and what are the # of dimensions and measures supported? (Options 1, 2, 3) ---------CORRECT ANSWER---------- -------Display text, images, links, and measures. Option 1: 1 Measure Option 2: Multiple Measures Distribution Plot ---------CORRECT ANSWER-----------------Compare the overall range and distribution of individual values in a measure field. What's a Gauge chart and what are the # of dimensions and measures supported? (Options 1, 2, 3) ---------CORRECT ANSWER----------------- Display an indicator representing the position of a measure along a range. Option 1: 1 Measure
Box Plot ---------CORRECT ANSWER-----------------Compare distributions in the form of box-and-whisker diagrams, and discover outliers. What's a Map chart and what are the # of dimensions and measures supported? (Options 1, 2, 3) ---------CORRECT ANSWER----------------- Display point, line, and area data upon geographic maps. Option 1: 1 Dimension of Point or Area Option 2: 1 Dimension, 1 Measures What's a Filter Pane and what are the # of dimensions and measures supported? (Options 1, 2, 3) ---------CORRECT ANSWER----------------- Make selections to reduce data set and view green, white and gray associative color-coding. Option 1: 1 Dimension Option 2: Multiple Dimension Waterfall Chart ---------CORRECT ANSWER-----------------Display the cumulative effect of positive and negative contributions on an initial starting amount. What's a Treemap and and what are the # of dimensions and measures supported? (Options 1, 2, 3) - --------CORRECT ANSWER----------------- Display data, organized into a hierarchy of categorical groupings, where relative rectangle size relates the magnitude of a measure, or nested measure values. Option 1: 1 Dimension. 1 Measure Option 2: Multiple Dimensions, 1 measure
What's a Combo Chart and what are the # of dimensions and measures supported? (Options 1, 2, 3) ---------CORRECT ANSWER----------------- Compare measures which occupy different data ranges, using bars, lines, or markers. Option 1: 1 Dimension, 1 Measure Option 2: 1 Dimension, Multiple Measures What's a Pivot Table and what are the # of dimensions and measures supported? (Options 1, 2, 3) ---------CORRECT ANSWER----------------- Create a cross table view of data with the potential to rearrange dimensions and measures. Option 1: 1 Dimension, 1 Measure Option 2: Multiple Dimensions, 1 Measure Option 3: Multiple Dimensions, Multiple Measures Steps to Build App ---------CORRECT ANSWER-----------------Load data, Review data model, develop sheets, analyze sheets, build a story, play story 3 Main Components of a Qlik Sense App ---------CORRECT ANSWER------- ----------Sheets, Stories, Data 3 Places you can Create Master Items ---------CORRECT ANSWER---------- -------Master items section in Assets panel, Data model views Preview panel, and Fields section in Assets panel
Only things you can do to edit an existing snapshot? ---------CORRECT ANSWER-----------------Edit annotation and delete QVD Files ---------CORRECT ANSWER-----------------Used to extract and store data into and from QlikView/ Qlik Sense Types of Data Connections ---------CORRECT ANSWER-----------------File folders, ODBC, OLE DB, Web files from a URL, Customer connectors downloaded from Qlik download page What do the built-in Qlik Sense feature, responsive design, do for the users? ---------CORRECT ANSWER-----------------Allows apps to be developed once and deployed anywhere from your phone, tablet or computer. Depending on the device, it will automatically respond and adjust to the available screen space. What are comparison type charts and what are those charts? --------- CORRECT ANSWER-----------------Comparison charts are used to compare values against each other. They show the differences in values, such as the difference between categories, or how values are changing over time. Questions that might be answered by comparison charts include: What product has the highest total sales this year? How have product sales risen or fallen over the last 24 months? Comparison charts include bar, line and combo charts
When is it best to use a bar chart? ---------CORRECT ANSWER----------------
- Comparing categories against the same measure or measures or viewing the changing composition of a value over a short period of time. When is it best to use line charts? ---------CORRECT ANSWER----------------
- Comparing trends over time or viewing the changing composition of a value over a long period of time When is it best to use combo chart? ---------CORRECT ANSWER------------- ----Comparing measures that are different in scale What are relationship charts and what are those? ---------CORRECT ANSWER-----------------Relationship charts are used to explore how values relate to each other. A relationship chart allows you to find correlations, outliers, and clusters of data. Questions that might be answered by relationship charts include: Is there a correlation between advertising spending and sales for our products? How do expenses and income vary per region? Relationship charts include scatterplot When is it best to use Scatter plot? ---------CORRECT ANSWER--------------- --Viewing the relationship between two or three measures for a dimension or viewing the distribution of two measures What are composition type charts and what are those charts? - -------- CORRECT ANSWER-----------------Composition charts take a total value
What cities have the highest use of our services? Charts include Histogram, scatterplot, distrubution plot and box plot charts When is it best to use histogram charts? ---------CORRECT ANSWER-------- ---------Viewing the how data is distributed over intervals. When is it best to use Distribution plot charts? ---------CORRECT ANSWER-----------------Viewing the distribution of measure values in a dimension. When is it best to use Box Plot charts? ---------CORRECT ANSWER---------- -------Viewing the range and distribution of numerical data. What are performance charts and what are those charts? --------- CORRECT ANSWER-----------------Performance charts provide a quick view of a performance measure. Looking at a performance chart, a user can quickly identify the measure value and whether the results are as expected or not. Questions that might be answered by performance charts include: What are is the current total sales for this quarter? Are current total sales for this quarter meeting the projected sales for the quarter? These charts are Gauge, KPI, and Text & Image When is it best to use the Guage? ---------CORRECT ANSWER----------------
- Viewing a performance value to understand performance immediately.
When is it best to use the KPI? ---------CORRECT ANSWER----------------- Viewing one or two performance measures. When is it best to use the Text & Image? ---------CORRECT ANSWER------- ----------Viewing text or several measures with an image. What are data charts and and what are those charts? ---------CORRECT ANSWER-----------------Data charts present detailed data rather than a visualization of the data. Data charts are useful when you need to view precise values, and when you want to compare individual values. Questions that might be answered by data charts include: What are the records for each transaction for this month? What are the quantity and sales for each item in each product group for each of our customers? These charts are table, pivot table When is it best to use a Table chart? ---------CORRECT ANSWER------------ -----Viewing precise values from your data without trends or patterns. When is it best to use a Pivot table? ---------CORRECT ANSWER------------- ----Viewing precise value for several dimensions and measures. What is a Geographical Chart and what are those charts? --------- CORRECT ANSWER-----------------Geographical charts let you visualize
week, and day level based on the date of individual transactions. The application should also enable users to analyze transactions by regions and products. The organization has operations worldwide. Each region represents a group of different countries. The sales department defines these ad-hoc groups. An existing QVD file that contains all the data needed has been identified as a potential source. What are the minimum fields that the analyst should expect to find in the QVD file? ---------CORRECT ANSWER-----------------TransactionDate, Country, SalesAmount, and Product ID A retailer with 300 locations worldwide needs to analyze revenue to prepare for its next board meeting. The retailer needs to view the distribution of its total revenue by continent and country. A business analyst has created a bar chart that provides a drill down option from continents to countries. However, the board wants to visualize all data in one chart without drill down or scrolling. ---------CORRECT ANSWER----- ------------Treemap A retail store owner needs to analyze sales and profitability for the products sold. The store owner carries approximately 500 products in different categories. The store owner needs to view sales revenue, quantity, and profit margin by product category. The store owner also needs to the ability to drill down to individual products and identify outliers. Which visualization should a business analyst use to show this information for the current period? ---------CORRECT ANSWER-----------------Scatter Plot
A marketing company must analyze the age of customers who view movies at a theater at least once a month, and where those customers are located. The business analyst must consider several requirements:
- Age of customers
- Addresses of customers
- Frequency of theater visits Which objects should a business analyst use to visualize these requirements? ---------CORRECT ANSWER-----------------Histogram and Map A business analyst must arrange the sheets within an app to logically guide user interactions. Which order should the business analyst use to meet this requirement? ----- ----CORRECT ANSWER-----------------High-level dashboard, interactive analysis, reports To analyze current office space utilization, a business analyst must create an office floor plan to show employee density and movements. What are the requirements to create the office floor plan? --------- CORRECT ANSWER-----------------A KML file with the floor plan shapes, the office movements, and employee locations A business analyst must combine the following bar charts on one sheet in a story:
- bar chart that updates with live data
- bar chart that shows static data from a previous period How should the business analyst meet this requirement? ---------CORRECT ANSWER-----------------Embed a sheet with the bar chart for live data, then add a snapshot of the bar chart for the static data
What two types of files can you load map data from? ---------CORRECT ANSWER-----------------.KML or excel file containing point or area data Where in Qlik Sense do you go to add map data? ---------CORRECT ANSWER-----------------Add data from files and attach files Do you add map data to a map chart as an expression a dimension, or both? ---------CORRECT ANSWER-----------------dimension What is the maximum number of points that can be displayed for performance reasons on a map? ---------CORRECT ANSWER----------------- 3333 Can you load a data set that contains the names of cities only? --------- CORRECT ANSWER-----------------Yes, the map object will include countries and cities Can you load a data set that contains country names only? --------- CORRECT ANSWER-----------------Yes, the map will only include pictures of the countries with no cities If only the city or country name is in the loaded data, what data will be automatically created? ---------CORRECT ANSWER-----------------Longitude and latitude data in a single field
Distribution charts show ---------CORRECT ANSWER-----------------how quantitative data is distributed along an axis How many variables can a distribution chart handle? ---------CORRECT ANSWER-----------------1 or 2 What chart do you use if you have 2 variables, such as sales and margin by product category? ---------CORRECT ANSWER-----------------Scatter Chart When can you use a bar or histogram chart? ---------CORRECT ANSWER-- ---------------When you have one variable and few data points Where can you find all the tables in an application? ---------CORRECT ANSWER-----------------Under tables in the Data Manager What are the 3 items that can be used in an expression in a calculated field? ---------CORRECT ANSWER-----------------Functions Fields Operators Can you refer to fields in other tables when adding a calculated field expression? ---------CORRECT ANSWER-----------------No, you can only use the fields in the table you are editing.
