Free Qlik Sense Data Architect Certification Exam QSDA2019 Exam Practice Test

A company generates 1 GB of ticketing data daily. The data is stored in multiple tables Business users need to see trends of tickets processed for the past two years. Users very rarely access the transaction-level data for a specific date. Only the past two years of data must be loaded which is 720 GB of dataWhich method should a data architect use to meet these requirements?

• Load only two years of data in an aggregated app and create a separate transaction app for occasional use
• Load only two years of data and use best practices in scripting and visualization to calculate and display aggregated data
• Load only aggregated data for two years and use Direct Discovery for transaction data
• Load only aggregated data for two years and use ODAG for transaction data

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 QVDsWhich strategy should the data architect use to meet these requirements?

• Use the Rename function and a mapping load
• Create master items using business-friendly names
• Use the Alias function and a mapping load
• Load in the Excel file as a data island and use the Peek function

A data architect needs to create an app that combines employee data from the Sales system and the Human Resources (HR) system.These systems identify employees differently. Employees in the HR system are identified with an alpha-numeric key. Employees in the Sales system are identified using an integer keyThe Human Resources manager creates a table which maps these keys to one another, called Associations.The resultant data model must meet the following requirements:* Associations must be valid* The model must be optimized for performance* The option must support multiple tables added from both systems now and in the futureWhich function should the data architect use to meet these requirements?

• APPLYMAP { 'Associations' , EmployeeKey) AS EmployeeKey;
• MAP EmployeeKey USING Associations;
• RENAME FIELDS USING Associations;
• MapSubString('Associations', EmployeeKey) AS EmployeeKey;

A data architect needs to efficiently prepare a data model for a meeting in an hour.The data source to be used contains five date fields. The app needs to display sales trends and compare the current year to date (CYTD) to last year to date (LYTD). The app is NOT going to be published. It will only be used for this meeting and a single user's ad-hoc analysis.What should the data architect do to meet these requirements?

• Create a canonical calendar
• Load a calendar island
• Use the data manager
• Create five master calendars

A data architect completes development of a new app with two data sources Both data sources will also be used by other apps in the future The sources have different data refresh frequencies* Source 1 Contains frequently updated data and must be refreshed hourly* Source 2 Contains data that is transferred from a partner and must be refreshed weeklyTasks must be created to load the data sources and make sure that the new app uses the most current data The data will be stored in two QVDs Which tasks should be created to meet these requirements'?

• 1 Schedule Task 1 to run hourly and refresh data from Source 1 2 Schedule Task 2 to run weekly and refresh data from Source 2 3. Schedule a task for the app that is dependent on completion of Tasks 1 or 2 that loads the two QVDs
• 1. Schedule Task 1 to run hourly and refresh data from Source 1 2 Schedule Task 2 that is dependent on Task 1 to refresh data from Source 2 3. Schedule a task for the app that is dependent on completion of Task 2 that loads the two QVDs
• 1. Schedule Task 1 to run hourly and refresh data from Source 1 2 Schedule Task 2 that is dependent on Task 1 to refresh data from Source 2 3 Schedule a task for the app that is dependent on completion of Tasks 1 and 2 that loads the two QVDs
• 1 Schedule Task 1 to run hourly and refresh data from Source 1 2 Schedule Task 2 to run weekly and refresh data from Source 2 3. Schedule a task for the app that is dependent on completion of Task 2 that loads the two QVDs

A data architect builds a data model for a large user group. Some sheets will be published, and the app will allow users to create their own visualizations and analyze data. Some fields must NOT appear in any field list.How should a data architect meet these requirements?

• Use HidePrefix variable
• Add fields to master items
• Use security rules
• Use HideField variable

A company decides to migrate all apps from QlikView to Qlik Sense. After converting an apps: there are several unconverted objects What should the data architect do?

• Save the unconverted objects as extensions and import them into Qlik Sense
• Remove the set analysis statements from the unconverted objects
• Re-create the unconverted objects
• Save the unconverted objects as master items

A data architect is using an Include statement to load the collection of variables from a TextFiles folder connection into an app. The data architect needs to load the data and generate an error if it fails.Which statement should the data architect use?

• $<Include=lib://TextFiles/Variables.txt);
• $(Must_Include=lib://TextFiles/Variables.txt);
• (Must_Include=lib://TextFiies/Variables.txt);
• (Includs=lib://TextFiles/Variables.txt);

A human resources (HR) team manager is due to go on leave. The manager needs to assign permissions to colleague to help the HR team publish apps. Which action(s) should the manager assign to the colleague before going on leave?

• Owner Publish
• Publish
• Owner Publish, Read
• Publish, Read

Multiple department fields in a dataset require a description.A data architect needs to add the department descriptions or a default value when the department does NOT have a description.Which strategy should the data architect use to meet these requirements?

• ApplyMap with two parameters after the Mapping load
• Left Join between tables and Description.xlsx in every Department table
• Enter 'Missing description' in the blank rows for Description.xlsx, then use Mapping Load
• ApplyMap with three parameters after the Mapping load