QSDA2018 試験問題を無料オンラインアクセス

Refer to the exhibit.
A data architect is reviewing an app that is under development. The app has NOT been published All data has been validated in all charts and KPIs. The data architect notices that the data model has two fact tables with common field names that cause a synthetic join Which step should the data architect take to correct the data model without affecting the app?

• A.Create a composite key in the Sales and Budget tables instead of loading Year Employee!^ and ProductID
• B.Create a composite key in the Sales and Budget tables that consists of the Year, EmployeelDr and ProductID
• C.Perform a mapping load for the Employees table and use ApplyMap in the Sales and Budget tables
• D.Concatenate LOAD the data from the Sales and Budget tables to combine into a single table

Refer lo the exhibit.

A data architect loads order data for a global sales organization. The Order Details contains 100 million rows.
The data architect must load only the data for the North America division Which WHERE clause should the data architect use in the Order Details LOAD script?

• A.WHERE Exists{OrderNum);
• B.WHERE Division = 'North America';
• C.WHERE OrderNum = [Order Header].[OrderNum";
• D.WHERE Exists('North America');

Refer to the exhibits



Which corrective action should be taken to achieve the expected view?

• A.Use distinct in the LOAD statement.
• B.Add a link table.
• C.Use upper () to align the Salesperson fields
• D.Alias one of the fields in the Orders table.

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

A data architect uses the Qlik GeoAnalytics connector to determine the closest airports to cities in an existing app. The built-in location servicetjenerates data for the airport locations The data load editor runs the script and sees a circular reference and a synthetic key How should the data architect fix these issues'?

• A.Concatenate the airport table and the existing tables into one master table.
• B.When selecting an operation in the Qlik GeoAnalytics connector, select Only load distinct .
• C.When selecting an operation in the Qlik GeoAnalytics connector, change the CRS to 'None".
• D.When choosing which data to load, uncheck the non-unique field in the new data tables.