QSDA2019 Exam Dumps – Our Features

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 rulesWhich two products should the data architect use to build this solution? (Select two.)

• OQIikGeoAnalytics
• ODAG
• QIikDataMarket
• Qlik Storytelling
• QIik NPrinting

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 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 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?

• Loop and Reduce
• QVDs
• In-memory
• ODAG

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

A data architect executes the following script:What will Field_1 contain after this script is executed?

• Abcd, abcd
• abed
• Abed. abed. ABCD, ABCDABCD
• Abcd, abcd. ABCD

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 needs to write the expression for a measure on a KPI to show the sales person with the highest sales. The sort order of the values of the fields is unknown. When two or more sales people have sold the same amount, the expression should return all of those sales people.Which expression should the data architect use?

• Concat(DISTINCT IF{Aggr{Rank{Sum(Sales),4),Salesperson)=1,Salesperson),' ')
• FirstSortedValue{DISTINCT Salesperson,-Aggr{Sum(Sales),Salesperson))
• Concat(DISTINCT IF{Aggr{Rank{Sum(Sales),1),Salesperson)=1, Salesperson) , ' ')
• FirstSortedValue {Salesperson, -Aggr (Sum{Sales), Salesperson))

A data architect needs to upload different data sources. To properly handle null values, the data architect decides to set all of these values to 'Missing Value'.Which syntax should the data architect use?

• NullAsValue*; Set NullValues = 'Missing Value';
• NullasNull *; Set NullValues = 'Missing Value';
• NullasNull *; Set NullValue = 'Missing Value';
• NullAsValue*; Set NullValue = 'Missing Value';

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;