실제 시험 환경과 유사한 모의고사로 QV_Developer_01 시험 당일의 긴장감을 미리 경험해 보시기 바랍니다. ExamPassdump의 QlikView 11 Developer Certification Examination 연습문제 70문항은 시간 관리 연습에도 활용하실 수 있습니다.

QlikView QV_Developer_01 시험 개요:

QlikView QV_Developer_01 시험 요강 주제:

QV_Developer_01 시험 자주 묻는 질문 총정리

최신 QlikView Certification QV_Developer_01 무료샘플문제

문제 #1

Which QlikView script should a developer add to a Load script to output the resulting number of rows from a joining Load statement to the Script Execution Progress window and the script log file?

A. SET vNumRows = NoOfRows('TableName'); Response.Write 'Resulting Rows = $(vNumRows)';
B. LET vNumRows = NoOfRows('TableName'); PRINT 'Resulting Rows = $(vNumRows)';
C. SET vNumRows = NoOfRows('TableName'); ECHO 'Resulting Rows = $(vNumRows)';
D. LET vNumRows = NoOfRows('TableName'); TRACE 'Resulting Rows = $(vNumRows)';
E. LET vNumRows = NoOfRows('TableName'); ECHO 'Resulting Rows = $(vNumRows)';

문제 #2

A customer has sales data containing a fact table, Sales and dimension tables, Customer, Item, and Vendor.
After loading the data, the Entity Relationship Diagram (ERD) has a synthetic table containing the fields Name and Address from the Vendor and Customer tables.
How can a developer eliminate the synthetic keys and appropriately link the data?

A. left join the Customer data onto the Sales table
B. qualify all tables
C. qualify all tables and then unqualify all key fields
D. alias all primary key fields

문제 #3

Refer to the exhibit to the right.

A customer has aggregated budgets for products by year and month. Actual data is stored at a more detailed transaction level and so a one-to-many relationship exists between the Budgets to Actuals table.
Budgets have been assigned for all months of the current year, but there are only transactions up to the current month of October. There are transactions for products that were not assigned budgets.
How can a developer remove the synthetic key automatically generated by QlikView and be able to analyze budgets and actuals by product, month, and year?

A. load the Actuals table, and when loading the Budgets table, rename fields Year and Month to BudgetYear and BudgetMonth
B. load the Actuals table, and when loading the Budgets table, use the Concatenate function to append the Budgets table to the Actuals table
C. load the Actuals table, and when loading the Budgets table, use Outer Join to join the BudgetAmount field to the Actuals table
D. create a concatenated key of Product-Year-Month in both the Budgets and Actuals table and comment out the individual fields in the Budgets table

문제 #4

Refer to the exhibit to the right.

The Sales table displayed in the exhibit represents the entire data set.
Given the expression.
=sum( {$< Month={'Oct'}, RegionID={'4'} >} SalesAmount)
What is the result with the selections for SalesPersonID=1 and RegionID=3?

A. 5000
B. 4500
C. 3500
D. 0

문제 #5

A customer's data set contains information for multiple departments.
The customer needs a document to show only one specific department when a user first accesses the application.
Which trigger and action will meet the requirement?

A. trigger. OnOpen; action. Set Variable
B. trigger. OnSelect; action. Select in Field
C. trigger. OnOpen; action. Select in Field
D. trigger. OnPostReload; action. Lock Field

질문과 대답: