Welcome! Preparing for the QlikView Data Architect (QV12DA) certification exam can be a daunting task, but we're here to make it easier for you. Here are the sample questions that will help you become familiar with the Qlik QV12DA exam style and structure. We encourage you to try our Demo QlikView Data Architect Certification Practice Exam to measure your understanding of the exam structure in an environment that simulates the actual test environment.
Why Use Our QlikView Data Architect Sample Questions?
To make your preparation easier for the Qlik 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 more than 85% in your actual QlikView Data Architect exam if you score 100% in our premium 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 to us at feedback@analyticsexam.com if you find any data entry errors in these QlikView 12 Data Architect (QV12DA) sample questions.
Get Started Today!
Equip yourself with the best resources and practice exams to ace your QlikView Data Architect exam. Explore our comprehensive study materials and take the first step towards certification success.