Free Qlik Sense Data Architect Certification Exam – 2024 Exam QSDA2024 Exam Practice Test

A data architect needs to upload data from ten different sources, but only if there are any changes after the last reload. When data is updated, a new file is placed into a folder mapped to E:\486396169. The data connection points to this folder.The data architect plans a script which will:

• Verify that the file exists
• If the file exists, upload it Otherwise, skip to the next piece of code.The script will repeat this subroutine for each source. When the script ends, all uploaded files will be removed with a batch procedure. Which option should the data architect use to meet these requirements?
• FilePath, FOR EACH, Peek, Drop
• FileSize, IF, THEN, END IF
• FilePath, IF, THEN, Drop
• FileExists, FOR EACH, IF

Users of a published app report incomplete visualizations. The data architect checks the app multiple times and cannot replicate the error. The error affects only one team.Which is the most likely cause?

• A security rule has been applied to the sheet object.
• The affected users were NOT added to the Section Access table.
• Section access restricts too many records.
• An Omit field has been applied.

A data architect in the Enterprise Architecture team wants to develop a new application summarizing Qlik Sense usage by all company employees. They also want to gather usage metrics for other systems.Who should the data architect contact to be granted access to the data?

• IT Security Director, Human Resources Director, Qlik Sense Administrator
• IT Security Manager, Qlik Sense Account Manager, Enterprise Architecture Director
• IT Security Analyst, Qlik Sense Developers, Solutions Architect
• IT Security Vice President, Human Resources Analyst, Qlik Sense Developers

A data architect needs to retrieve data from a REST API. The data architect needs to loop over a series of items that are being read using the REST connection.What should the data architect do?

• Recreate the SQL Statement with the correct parameters
• Use the REST Connector with pagination mechanism
• Use pagination of the REST Connector to create a template of the desired data
• Use With Connection to pass a parameter to the REST URL

A Chief Information Officer has hired Qlik to enhance the organization's inventory analytics. In the initial meeting, the client's focus was determined to be forecasting inventory levels.Which stakeholder should be consulted first when gathering requirements?

• Product Buyer
• SQL Developer
• Vice President of Marketing
• Chief Information Officer

A company needs to analyze daily sales data from different countries. They also need to measure customer satisfaction of products as reported on a social media website. Thirty (30) reports must be produced with an average of 20,000 rows each. This process is estimated to take about 3 hours.Which option should the data architect use to build this solution?

• Qlik REST Connector
• Microsoft SQL Server
• Qlik GeoAnalytics
• Mailbox IMAP

A data architect needs to develop three separate apps (Sales, Finance, and Operations). The three apps share numerous identical calculation expressions.The goals include:Reducing duplicate scriptSaving time on expression modificationsIncreasing reusable Qlik developer assets.The data architect creates a common script and stores it on a file server that Qlik Sense can access. How should the data architect complete the requirements?

• Macro on server
• Execute server script
• Include script function
• Call batch file

A company's analytics team is migrating from QlikView to Qlik Sense. During the transition there is an opportunity to improve overall reporting.Which set of criteria must the data architect consider while planning for the migration?

• Application size, application theme, storytelling, data model, IT use case
• User sessions, source data architecture, compatibility, data model, business use case
• QlikView archival, source data architecture, load script, data model, business use case
• Application metadata, application theme, user sessions, load script, IT use case

A data architect needs to acquire social media data for the past 10 years. The data architect needs to track all changes made to the source data, include all relevant fields, and reload the application four times a day.What information does the data architect need?

• A field with social media source, a set of key fields to sort out updated records, configure reload task to load four times a day
• A field with record creation time, a secondary key field to remove deleted records, configure reload task to load four times a day
• A field with ModificationTime, a primary key field to sort out updated records, insert and append records, update records
• A field with ModificationTime, a primary key field to sort out updated records, insert and update records, remove records

The data architect has been tasked with building a sales reporting application.Part way through the year, the company realigned the sales territoriesSales reps need to track both their overall performance, and their performance in their current territoryRegional managers need to track performance for their region based on the date of the sale transactionThere is a data table from HR that contains the Sales Rep ID, the manager, the region, and the start and end dates for that assignmentSales transactions have the salesperson in them, but not the manager or region.What is the first step the data architect should take to build this data model to accurately reflect performance?

• Implement an "as of calendar against the sales table and use ApplyMap to fill in the needed management data
• Create a link table with a compound key of Sales Rep / Transaction Date to find the correct manager and region
• Use the IntervalMatch function with the transaction date and the HR table to generate point in time data
• Build a star schema around the sales table, and use the Hierarchy function to join the HR data to the model