A data architect plans to build an app that contains geographically diverse data that must be specific to user run-time selections. The source contains transactional data. The app must have minimal impact on already limited server resources.
Which approach should the data architect use?
Refer io the exhibit.
A data architect needs to modify the script to ONLY load rows from Table_B when Field_1 and Field_2 are the same as in Table_A. (For example, only the row containing A, 1, 456 should be loaded from Table_B.)
Which script should the data architect use?
A)
B)
C)
D)
A company needs to analyze sales data based on the exchange rate of the different countries every day About 30 reports must be produced with an average of 20r000 rows each. This process is estimated to take about three hours.
Reports will be in Excel and distributed to business users according to defined security rules
Which two products should the data architect use to build this solution? (Select two.)
Refer to the exhibit.
A business analyst reports that the 'CompanyAge' field does NOT display for users The data architect examines the LOAD script and wants to place the breakpoint in the script to check the field name.
Which line number should the data architect use?
A data architect needs to add the UnitCost field from the ProductCost table in the Dim_Products Table.
Which script code should the data architect use?
A)
B)
C)
D)
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 tliey 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?
Refer to the exhibits.
While debugging an app, a developer loads data from an application layer QVD file.
In the process of separating a concatenated key into two parts, some split results are missing data
What should the data architect do?
Refer to the exhibit.
A data architect is loading two tables into a data model from a SQL database These tables are related on key fields CustomerlD and CustomerKey.
Which script is valid to load the tables and maintain the correct association?
A)
B)
C)
D)
A data architect needs to load Table_A from an Excel file and sort the data by Field_2.
Which script should the data architect use?
A)
B)
C)
D)
A table is generated resulting from the following script
When the data architect selects a date, some, but NOT all, orders for that date are shown How should the data architect modify the script to show all orders for the selected date?
A)
B)
C)
D)
A data architect is developing an app that will generate QVDs for multiple business analysts. The field naming conventions on the source data are NOT business friendly. For every table loaded, multiple fields will require a name change.
An Excel file is maintained centrally that lists all source data field names and the appropriate names as they should appear in the QVDs
Which strategy should the data architect use to meet these requirements?