QlikView QV12DA 考試概覽:

認證廠商:	Qlik
考試名稱:	QlikView 12 資料架構師認證考試
考試代碼:	QV12DA
考試時間:	120 分鐘
實際考試題數:	50
證照有效期限:	2 年
及格分數:	70%
考試形式:	情境式題目, 多選題, 單選題
考試費用:	$250 USD
相關認證:	QlikView 12 開發人員認證（QV12DE） Qlik Sense 商業分析師認證（QSBA2018） Qlik Sense 資料架構師認證（QSDA2018）
支援語言:	English
範例考題:	QlikView QV12DA 範例考題
考試方式:	線上遠端監考測驗，或於 Pearson VUE 考試中心應考
必備條件:	建議具備：6 至 12 個月的 QlikView 12 實作經驗，並完成 QlikView 資料架構師訓練課程
官方大綱網址:	https://www.qlik.com/services/training/certification

QlikView QV12DA 考試大綱主題:

章節	權重	目標
主題 1: 效能最佳化	15-20%	- 資料表檢視器分析 - 聯結類型及其對效能的影響 - 資料模型最佳化技巧 - 記憶體使用管理 - 合成索引鍵的辨識與解決方法
主題 2: 資料轉換	20-25%	- 對照表與 ApplyMap 函數 - 交叉資料表與樞紐分析表 - 資料品質與驗證 - 資料清理技巧 - 區間比對
主題 3: 安全性與治理	15-20%	- 欄位層級與資料列層級的權限控管 - 資安實務最佳做法 - 區段存取權限設定 - 資料範圍縮減技巧
主題 4: 資料架構與設計	20-25%	- 連結資料表與串接資料表 - 循環參照問題與解決方案 - 認識維度資料模型 - 資料模型複雜度與效能的平衡 - 星型綱要與雪花綱要設計
主題 5: 資料載入設計	20-25%	- LOAD 敘述與資料轉換 - QVD 檔案建立與最佳化 - 指令碼基礎 - 處理不同類型的資料來源 - 增量載入策略 - RESIDENT 載入與前置載入

最新的 QlikView Certification QV12DA 免費考試真題：

問題 #1

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?
Response:

A. A treemap using Patient Name and Duration of Stay as the as 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 bar chart with Patient Name as the dimension, and Duration of Stay and Total Payment as the measures
D. A line chart with Patient Name as the dimension, and Duration of Stay and Total Payment as the measures

問題 #2

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 Qlik View which DB connector needs to be used. Which step should the data architect perform?
Response:

A. Select OLE DB 32-bit from the drop-down list
B. Select 32-bit connector from the drop-down list
C. Check Force 32-bit
D. Let Qlik View automatically choose the correct connector

問題 #3

Which two functionalities become available when a QlikView Publisher license is applied to & QlikView deployment? (Select two.)

A. More complex reload schedules can be configured
B. Reloads can be scheduled on the Reload tab of a QlikView document in the QlikView Management Console
C. QlikView PDF reports can be distributed by email only to users who have leased a CAL from the QlikView Server
D. The QlikView Distribution Service becomes responsible for the reload of the QlikView documents instead of the QlikView Server service
E. The QlikView Distribution Service can be installed on a different logical or physical server than the other QlikView services

問題 #4

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?
Response:

A. Dimension: =class (Margin, 250, ,Margin, )Expression: =Count (DISTINCT OrderlD)
B. Dimension: =class (OrderID, 250, ,Margin, )Expression: =Count (DISTINCT OrderlD)
C. Dimension: =OrderIDExpression: =Class (Margin, 250, ,Margin, )
D. Dimension: =Aggr (Sum (Margin) ,OrderID) )Expression: =Count (DISTINCT OrderlD)

問題 #5

A system administrator finds this error message in the event log file
500 Warning WorkingSet: Virtual Memory is growing beyond parameters - 22.761(22.393) GB Which is the cause of the error?

A. QlikView Server memory is above the Cache limit for the Working Set
B. QlikView Server memory is above the Low limit for the Working Set
C. QlikView Server memory is below the Low limit for the Working Set
D. QlikView Server memory is above the High limit for the Working Set

問題與答案：

問題 #1
答案： B

問題 #2
答案： C

問題 #3
答案： B,D

問題 #4
答案： A

問題 #5
答案： D