QSDA2018 무료 덤프문제 온라인 액세스

A business analyst must see a currency conversion rate for any given date in a chart The currency conversion rate data is held in a separate table in the database and only contains a record when the rate changes. An existing master calendar exists in the data model that contains a full set of dates Which technique should the data architect use to meet this requirement?
A business analyst must see a currency conversion rate for any given date in a chart The currency conversion rate data is held in a separate table in the database and only contains a record when the rate changes. An existing master calendar exists in the data model that contains a full set of dates.
Which technique should the data architect use to meet this requirement?

• A.* Use a For loop between the start date and end date of the master calendar
  * Use the Match function to add the currency conversion rates to the master calendar
• B.* Use IntervalMatch to load the currency conversion rate between dates the conversion changed
  * Inner Join the resultant table back into the master calendar
• C.* Use IterNo and autogenerate to create a new calendar from max and min dates of the currency conversion table
  * Force concatenate with the master calendar
• D.* Join the calendar with the currency conversion table
  * Order by the date and use the Peek function to fill in blank values

A customer must create a production app that pulls data from two sources Source 1 is a large legacy system It takes more than one hour to read and save the data to a QVD Reading from the QVD only takes 20 seconds The data only needs to be refreshed every month because it does not change very often Source 2 is a small online data source Reloading this data takes less than one minute The production app must be refreshed every hour to see the most updated data and needs both data sets to meet the analysis requirements How should the data architect set up the data reload?

• A.1 Create the productioff app to connect to both data sources
  2. Create a variable and set this to the last reload time using ReloadTimeQ function
  3. Use an IF() statement and only load the legacy data when TodayO > 30 days from last reload 4 Create a task to run every hour to reload the production app
• B.1 Create two QVD generation apps
  2- Create two scheduled tasks one runs every month and one runs every hour
  3. Load the data in the production app from the QVDs
  4. Create a task to run every hour to reload the production app
• C.1. Create a QVD generation app for the legacy system only
  2. Create a scheduled task to generate the QVD every month
  3 Build the production app using the QVD and use ADD LOAD prefix to connect to the online data source
  4. Create a task to run every hour to perform a partial reload on the production app
• D.1. Create a QVD generation app to pull both data sources in different script sections
  2. Create two reload schedules from the QVD app based on the script section
  3. Build the production app using the QVD files
  4. Create a task to run every hour to reload the production app

The data model from an existing Qlik Sense app needs to be reused in another Qlik Sense app.
Which load strategy should a data architect use to transfer this data in the most efficient way?

• A.Generic load
• B.QVD load
• C.Binary load
• D.Preceding load

Refer to the exhibit.

In the data load editor, the tables are loaded in the following sequence;
1 OrderHeader
2. OrderDetails
3. Products
The three tables CANNOT be modified as all fields are required.
A data architect must create a Cost of Goods Sold (COGS) field calculated as UnitCost * Quantity. Some products may NOT have UnitCost so the COGS value must be zero for these products.
How should the data architect meet this requirement?

• A.1. Load the Products table as the first table
  2. Create a new field in the OrderDetails table: Quantity * isNull (unitcost) as cogs
• B.1. Perform a preceding load on the Products table
  2. Create a new field in the OrderDetails table, if (Unitcost = nulio or *', 0) * Quantity as cogs
• C.1. Create a mapping load table as the first table from the Products table
  2. Create a new field to the OrderDetails table: toplyMap('unitcos^Map', ProductID, 0) * Quantity as cogs
• D.1 Join the Products and OrderDetails tables on ProductID
  2. Create a new field in the OrderDetails table: Replace (Null, o, unitcost) * Quantity as cogs

A new app is being developed. Users need to see;
* Total sales for each customer
* Total sales for a given state
* Customers that have not had any sales
* Names of salesperson and regional manager
* Total number of sales by date
The data architect constructs several data models and tests the validity of each model. Which two data models meet these requirements? (Select two.) A)

B)

C)

• A.Option C
• B.Option B
• C.Option A