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

Refer to the exhibits.

Executives need to see the total sales by region for the current year. The data architect inherits App1 from a former employee who tried to address this requirement. Two Excel spreadsheets, Region and Employee, are used as the data source. The data architect creates a table and identifies errors in the amount of sales per region.
How should the data architect resolve the errors?

• A.In the data manager, concatenate the Region table and associate by Region.ID
• B.In the data load editor, concatenate the Region and Employee tables
• C.In the data manager split the Region table and associate by Region.ID
• D.In the data manager split the Region table and associate by EmployeelD

Refer to the exhibit.

The Section Access security table for an app is shown User ABC\PPP opens a Qlik Sense app with a table using the field called LEVEL on one of the table columns What is the result?

• A.The table is displayed without the LEVEL column
• B.The user gets an "Invalid visualization" error
• C.The user gets a "Field not found" error
• D.The table is removed from the user interface

Refer to the exhibit.

The data architect needs to build a model that contains Sales and Budget data for each customer. Some customers have Sales without a Budget, and other customers have a Budget with no Sales During loading, the data architect resolves a synthetic key by creating the composite key For validation, the data architect creates a table containing Customer, Month. Sales, and Budget columns.
What does the data architect see when selecting a month?

• A.Customer, Sales, and Budget records for that month
• B.Customer and Sales records for that month, but missing values for Budget
• C.All Customers, all Budget and all Sales records
• D.Customer and Budget records for that month, but missing values for Sales

Refer to the exhibit.

A data architect needs to analyze the number of orders by customer. The data is stored in two Excel files: Orders and Customers The data architect creates a bar chart, but the data is obviously incorrect. What should the data architect do to resolve this issue?

• A.Open the data manager split the Customers table, and associate on CustomerlD
• B.Open the data manager, split the Customers table, and Concatenate Orders and Customers on the CustomerlD field
• C.Open the data load editor, use CONCATENATE to concatenate Orders and Customers
• D.Open the data load editor, rename the CustomerlD field, and concatenate Orders and Customers

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.242 because field name appears in the output Panel of the debugger
• B.251 because the field name appears in the Variable panel of the debugger
• C.251 because the field name appears in the Qlik Log files
• D.251 because the field name appears in the Output panel of the debugger