MoreExam
1. Question Content...
EXPLANATION
Answer: X - EXPLANATION Content.
Question1: 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 rules Which two products should the data architect use to build this solution? (Select two.)
Question2: A data architect is loading two tables into a data model from a SQL database. These tables are related on key fields CustomerlD and CustomerKey. Which scripts should be used to load the data while maintaining the correct associations?A)B)C)D)
Question3: A customer has a dataset that contains latitude and longitude data for service points around the country. The data is retrieved using the following statement:It must be clear to the end user that this is geographic data. Drag and drop, map-based visualization of this data is required. Which two steps should the data architect take to support this data? (Select two.)
Question4: 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 key The 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 future Which function should the data architect use to meet these requirements?
Question5: Refer to the exhibit.A data architect needs to modify the script to ONLY load rows from Table_B when Field_1 and Field_2 are the same as in Table_A.(For example, only the row containing A. 1. 456 should be loaded from Table_B ) Which script should the data architect use?A)B)C)D)
Question6: Refer to the exhibit.An app has been built to analyze salesperson performance by department. Salespeople often move between departments. There is a strict business rule which states a salesperson must be associated with ONLY one department at all times.The data architect creates a summary of department performance and notices the values are incorrect. The KPI showing the total sales shows the correct result.How should the data architect modify the data model to correct the issue?
Question7: 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?
Question8: 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?
Question9: Refer to the exhibit.A clothing retailer wants to review their product pricing strategy.A data architect must classify each product into a price group. The price groups must be the same width by default and allow users to dynamically change the width of the bucket during analysis.Which feature should the data architect use to meet these requirements?
Question10: 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 dat a. Some fields must NOT appear in any field list.How should a data architect meet these requirements?
Question11: Refer to the exhibits.A business analyst needs to see the currency conversion rate for any given date in a chart The currency conversion rate data comes from Qlik DataMarket and only contains a record when the rate changes An existing master calendar exists in the data model which contains a full set of dates Which technique should the data architect use to meet this requirement?
Question12: A data architect needs to load Table_A from an Excel file and sort the data by Field_2.Which script should the data architect use?A)B)C)D)
Question13: Refer to the exhibit.A company has different departments Executive and Sales should always be the first values in a Department filter pane Which script must the data architect use to meet this requirement^ A)B)C)D)
Question14: A data architect needs to load large amounts of data from a database which is continuously updated New records are added, and existing records get updated and deleted. Each record has a LastModified field All existing records are exported into a QVD file. The data architect wants to load the records into Qlik Sense efficiently.Which steps should the data architect take to meet these requirements?
Question15: 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?
Question16: Refer to the exhibit.The data architect needs to create a KPI that displays the average amount of orders per customer. This aggregated field should be added to the existing orders table Which script should the data architect use?A)B)C)D)
Question17: 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?
Question18: Refer to the exhibit.A business department is forecasting revenue within an Excel spreadsheet.A data architect needs to include this forecast into the existing data model, and without losing any data.Which two sets of steps will meet these requirements? (Select two.)
