A data architect needs to develop three separate apps (Sales, Finance, and Operations). The three apps share numerous identical calculation expressions.
The goals include:
* Reducing duplicate script
* Saving time on expression modifications
* Increasing reusable Qlik developer assets.
The data architect creates a common script and stores it on a file server that Qlik Sense can access. How should the data architect complete the requirements?
A. Include script function
B. Macro on server
C. Call batch file
D. Execute server script
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
質問 2:
Exhibit.

While performing a data load from the source shown, the data architect notices it is NOT appropriate for the required analysis.
The data architect runs the following script to resolve this issue:

How many tables will this script create?
A. 4
B. 1
C. 3
D. 6
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
質問 3:
Exhibit.

Refer to the exhibit.
A data architect is provided with five tables. One table has Sales Information. The other four tables provide attributes that the end user will group and filter by.
There is only one Sales Person in each Region and only one Region per Customer.
Which data model is the most optimal for use in this situation?
A.

B.

C.

D.

正解:B
解説: (Pass4Test メンバーにのみ表示されます)
質問 4:
Exhibit.

Refer to the exhibit.
A data architect is working on a Qlik Sense app the business has created to analyze the company orders and shipments.
To understand the table structure, the business has given the following summary:
* Every order creates a unique orderlD and an order date in the Orders table
* An order can contain one or more order lines one for each product ID in the order details table
* Products In the order are shipped (shipment date) as soon as they are ready and can be shipped separately
* The dates need to be analyzed separately by Year, Month, and Quarter
The data architect realizes the data model has issues that must be fixed. Which steps should the data architect perform?
A. 1. Create a key with OrderlD and ProductID In the OrderDetails table and in the Orders table
2. Delete the ShipmentID in the Shipments table
3. Delete the ProductID and OrderlD in the OrderDetails table
4. Concatenate Orders and OrderDetails
5. Create a link table using the MasterCalendar table and create a concatenated field between OrderDate and ShipmentDate
B. 1. Create a key with OrderlD and ProductID in the OrderDetails table and in the Shipments table
2. Delete the ShipmentID in the Orders table
3. Delete the ProductID and OrderlD In the Shipments table
4. Concatenate Orders and OrderDetails
5. Create a link table using the MasterCalendar table and create a concatenated field between OrderDate and ShipmentDate
C. 1. Create a key with OrderlD and ProductID in the OrderDetails table and in the Orders table
2. Delete the ShipmentID in the Shipments table
3. Delete the ProductID and OrderlD in the OrderDetails table
4. Left join Orders and OrderDetails
5. Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate
D. 1. Create a key with OrderlD and ProductID in the OrderDetails table and in the Shipments table
2. Delete the ShipmentID in the Orders table
3. Delete the ProductID and OrderlD in the Shipments table
4. Left join Orders and OrderDetails
5. Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
質問 5:
A data architect inherits an app that takes too long to load and overruns the data load window.
The app pulls all records (new and historical) from three large databases. The reload process puts a heavy load on the source database servers. All of the data is required for analysis.
What should the data architect do?
A. Implement Direct Discovery with partial load
B. Implement ODAG to split out the app into smaller chunks
C. Implement incremental load on each database using QVD files
D. Make sure the individual reload tasks in the QMC are not running in parallel
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
Niizuma -
試験にある問題はほぼPass4Testのこの問題集にもあって、短時間で答え終わって、今日結果がてて本当に合格になった。地味にすごいね。Pass4Testさんまたお世話になりたいとおもいます。