QlikView Data Architect (QV12DA) Certification Exam Sample Questions

QV12DA Dumps Free, QV12DA PDF Download, QlikView Data Architect Dumps Free, QlikView Data Architect PDF Download, QV12DA Free DownloadHere are the sample questions which will help you be familiar with QlikView Data Architect (QV12DA) exam style and structure. We encourage you to try our Demo QlikView Data Architect Certification Practice Exam to measure your understanding of exam structure in an environment which simulates the QlikView Data Architect Certification test environment.

To make your preparation more easy for QlikView Data Architect (QV12DA) exam, we strongly recommend you to use our Premium QlikView Data Architect Certification Practice Exam. According to our survey with certified candidates, you can easily score 85% in your actual Qlik Certification exam if you can score 100% in our premium QlikView Data Architect Certification practice exams.

Qlik QV12DA Sample Questions:

01. A customer has data for a variety of sales teams. Each sales team should only be able to view its own data. How should a data architect set up Section Access to meet this requirement?
a) Link the NTNAME to the Sales Team field in the initial data reduction
b) Link the NTNAME field to the Sales Team field in the initial data selection
c) Create a single USERNAME for each team and link USERNAME to the SalesTeam field in the initial data reduction
d) Create a single USERID for each team and link USERID to the SalesTeam field in the initial data selection
 
02. A data architect who works on a 64-bit PC needs to set up a 32-bit OLE DB connection. The data architect needs to communicate to QlikView which DB connector needs to be used.
Which step should the data architect perform?
a) Select 32-bit connector from the drop-down list
b) Let QlikView automatically choose the correct connector
c) Select OLE DB 32-bit from the drop-down list
d) Check Force 32-bit
 
03. Which two additional features will QlikView Publisher provide that are NOT available in QlikView Enterprise Server?
(Select two.)
a) Scheduling, monitoring, and managing complex dependencies for reloads
b) Publishing a reloaded document to a specified folder location
c) Full third-party LDAP connectivity through the QlikView Document Metadata Service
d) Loop and Reduce functionality from the same template with different datasets
e) Clustering multiple QlikView servers for scalability
 
04. A sales manager wants a bar chart showing a distribution of the deals displayed in $250 intervals of the profit margin.
Which dimension and expression should a data architect use?
a) Dimension: =OrderID
Expression: =Class (Margin, 250, 'Margin' )
b) Dimension: =class (OrderID, 250, 'Margin' )
Expression: =Count (DISTINCT OrderlD)
c) Dimension: =Class (Margin, 250, 'Margin' )
Expression: =Count (DISTINCT OrderlD)
d) Dimension: =Aggr (Sum (Margin) ,OrderID) )
Expression: =Count (DISTINCT OrderlD)
 
05. A data architect analyzes daily transaction data and wants to reduce the current reload time with the following requirements: 
- The application must show five years of data including the current year
- The data is loaded from yearly QVDs except for the current year
- The current year data is obtained directly from the database
Which two options can reduce the reload time?
(Select two.)
a) Load a smaller period of data directly from the database
b) Load all data directly from the database
c) Reduce the number of rows loaded into the application
d) Reduce the granularity of the data
e) Remove columns from the data model that are NOT required
 
06. Financial managers need to analyze their monthly data on the first day of the following month. However, NOT all of the transactions are entered into the source system on time.
When the managers look at the data later in the month, the results no longer match data from the first of the month. The managers need to be able see both views of the data. 
Which two data modeling techniques can be used to meet the requirements?
(Select two.)
a) Create a field to identify the on time and late transactions
b) Load only the late transactions in another application
c) Use a bookmark to show the view of the first day of the month
d) Create a second application that only loads on the first day of every month
e) Create a QVD to show a snapshot of the data from the first of the month
 
07. A business user reports a summary dashboard sheet takes a long time to load. Other sheets perform well. Which should be the first step for a data architect to identify the source of the problem?
a) Review the Sheet Properties > Performance tab to identify errors and issues with the sheet and/or objects
b) Run a series of tests and use a timer to capture the time that the sheet takes to render each time it is opened
c) Review the settings for each object in the summary dashboard sheet to identify complex calculations
d) Review the Sheet Properties > Objects tab to identify the calculation time and memory use of each object
 
08. A data architect creates an application for a hospital, which admits patients for various procedures. The hospital managers want to see the relationship between the patient's duration of stay and the total payment.
Which object should the data architect use?
a) A treemap using Patient Name and Duration of Stay as the dimensions, and Total Payment as the measure
b) A scatter chart with Patient Name as the dimension, and Duration of Stay and Total Payment as the measures
c) A line chart with Patient Name as the dimension, and Duration of Stay and Total Payment as the measures
d) A bar chart with Patient Name as the dimension, and Duration of Stay and Total Payment as the measures
 
09. A customer needs a single sign-on QlikView application with field level security. Which fields should be created in the Section Access table?
a) ACCESS, NTNAME, OMIT
b) ACCESS, USERID, OMIT
c) ACCESS, NTNAME, OMITFIELD
d) ACCESS, USERNAME, OMITFIELD
 
10. A data source contains metadata, which describes the content of the data fields. How can the metadata for specific fields be shared with other data architects within QlikView?
a) Add metadata as a data row
b) Add metadata as a data column
c) Add metadata by using the Comment command
d) Add metadata to a text-based .meta file

Answers:

Question: 1 Answer: a Question: 2 Answer: d
Question: 3 Answer: b, d Question: 4 Answer: c
Question: 5 Answer: a, e Question: 6 Answer: a, e
Question: 7 Answer: d Question: 8 Answer: b
Question: 9 Answer: a Question: 10 Answer: c

Note: Please write us on feedback@analyticsexam.com if you find any data entry error in these QlikView Data Architect (QV12DA) sample questions.

Rating: 4.8 / 5 (105 votes)