Refer to the exhibit.A data architect builds a simple data model to show the relationship between students and exams. The data is loaded. Every StudentID in the Exams table should be found in the Students table. Some students have NOT taken an exam.The data architect selects the field "StudentID" from the Students table and sees the following:A data architect needs to fix this anomaly.What should the data architect do to ensure data integrity?
Answer(s): D
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 QVDs.Which strategy should the data architect use to meet these requirements?
Answer(s): A
The Rename function allows the data architect to rename fields from the source data to the names specified in the Excel file. The mapping load allows the data architect to load the mapping between the source field names and the business-friendly names from the Excel file. The other options, Create master items using business-friendly names, Use the Alias function and a mapping load, and Load in the Excel file as a data island and use the Peek function, are not valid strategies for meeting these requirements.
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. 2 years Users very rarely access the transaction- level data for a specific date. Only the past 2 years of data must be loaded which is 720 GB of data Which method should a data architect use to meet these requirements?
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?
The Owner Publish permission allows the colleague to publish apps on behalf of the manager, allowing the HR team to continue to publish apps while the manager is away. The other options, Publish, Owner Publish, Read, and Publish, Read, do not provide the colleague with the necessary permissions to publish apps on behalf of the manager.
Refer to the exhibit.A global sales organization operates in three regions: AMERICAS, EMEA: and APAC. Each region stores its sales transactions in a separate database in which the employees update customer data through a third-party app. The data is extracted into three QVDs.A data architect sets up a two-tier architecture for the data load. The data architect needs to add the region to the data model.Which technique should the data architect use to create the Region field?
Post your Comments and Discuss QlikView QSDA2022 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the QSDA2022 content, but please register or login to continue.