試験問題と解答はQSDA2019学習ガイド問題を試そう！ [Q15-Q33]

試験問題と解答はQSDA2019学習ガイド問題を試そう！

Qlik Sense Data Architect Certification Exam認証サンプル問題と練習試験合格させます

質問 15
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:\373948870. The data connection points to this folder.
The data architect plans a script which will:
1. Verify that the file exists
2. 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?

A. FileSize, IF, THEN, END IF
B. FilePath, IF, THEN, Drop
C. FilePath, FOR EACH, Peek, Drop
D. FileExists, FOR EACH, IF

正解: D

質問 16
A data architect wants to combine data on present and historic sales performance. The historic data is stored in a de-normalized archive, and the present data is maintained in a database. The output must be contained in a single table.
Which script should the data architect use?
A)

B)

C)

D)

A. Option D
B. Option B
C. Option C
D. Option A

正解: D

質問 17
Refer to the exhibit.

A data architect loads sales data and creates a table which shows only customers who made purchases in 2018 and 2019. The data architect applies the following set analysis expression on the sales measure. Count<{<Year={'2 018'}, CustomerID=P({<Year={'2019*}>})>} Customer ID) Which option shows the resulting table after the expression is applied?
A)

B)

C)

D)

A. Option D
B. Option B
C. Option A
D. Option C

正解: A

質問 18
A data architect needs to create an app to analyze 30-day re-admissions at a hospital.
* The medical record system does NOT calculate re-admission data
* The business rule to follow: if a patient is admitted to a hospital within 30 days after being discharged from a previous hospital stay, that event should be captured in the app with a flag called "30-day Re-admission"
* Data being used from the patient record includes hospital account ID, patient ID, admission dater and discharge dateWhich action should the data architect perform first to meet these requirements?

A. Calculate the days since previous discharge using admission date and discharge date
B. Sequence patient records by hospital account ID and patient ID using the Peek function
C. Order patient records by patient ID and admission date
D. Sequence patient records by patient ID using the Peek function

正解: B

質問 19
A table is generated resulting from the following script

When the data architect selects a date, some, but NOT all, orders for that date are shown How should the data architect modify the script to show all orders for the selected date?
A)

B)

C)

D)

A. Option D
B. Option B
C. Option A
D. Option C

正解: D

質問 20
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?

A. Load a calendar island
B. Create five master calendars
C. Use the data manager
D. Create a canonical calendar

正解: C

質問 21
Refer to the exhibit.

A. * The UserAccess Table contains seven fields: Year, Month. Hour. AccessID, AccessDate. UserlD, and Duration (minutes)
* The table is linked to the Access table with the AccessID field and linked to Users on the UserlD field
B. * The UserAccess table contains seven fields Year Month, Hourr AccesslD. AccessDate. UserlD, and Duration (minutes)
* The table is only linked to Users on the UserlD field
C. * The UserAccess table contains seven fields AccessYear, AccessMonth, Hour AccesslD, AccessDate, UserlD, and Duration (minutes)
* The table is only linked to Users on the UserlD field
D. * The UserAccess table contains seven fields AccessYear. AccessMonth. Hour. AccesslD, AccessDate. UserlD. and Duration (minutes)
* The table is linked to the Access table on the AccesslD field and linked to Users on the UserlD field

正解: D

質問 22
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 What is the most likely cause?

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

正解: C

質問 23
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?

A. Remove records from the Exams table where StudentID is null
B. Update the Exams table and add 33.4% of the missing records
C. In the LOAD script, add DISTINCT before the Students and Exams tables
D. Update the Students table and add 16.7% of the missing records

正解: B

質問 24
Refer to the exhibits.

Executives need to see the total sales by region for the current year. The data architect inherits App1 from a former employee who tried to address this requirement. Two Excel spreadsheets, Region and Employee, are used as the data source. The data architect creates a table and identifies errors in the amount of sales per region.
How should the data architect resolve the errors?

A. In the data manager, concatenate the Region table and associate by Region.ID
B. In the data manager split the Region table and associate by Region.ID
C. In the data manager split the Region table and associate by EmployeelD
D. In the data load editor, concatenate the Region and Employee tables

正解: B

質問 25
Refer to the exhibit.

An existing app on Qlik Sense Enterprise is duplicated and transferred to a data architect to add some additional data When trying to manually reload the original script, the data architect receives an error What should be done to make sure the script runs correctly?

A. Make the data architect the owner of the app in the QMC
B. Give the data architect the Read rights on the data connections in the QMC
C. Add the line lib connect to 'QVD(abc_qservice/orderData.qvd) '; before the LOAD for the Order Data table
D. Add the line lib connect to ' SQL (abc_qs9rvi.es) ' ;before the LOAD for the Order Detail table

正解: C

質問 26
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?

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

正解: C

質問 27
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?

A. FirstSortedValue{DISTINCT Salesperson,-Aggr{Sum(Sales),Salesperson))
B. Concat(DISTINCT IF{Aggr{Rank{Sum(Sales),1),Salesperson)=1, Salesperson) , ' ')
C. FirstSortedValue {Salesperson, -Aggr (Sum{Sales), Salesperson))
D. Concat(DISTINCT IF{Aggr{Rank{Sum(Sales),4),Salesperson)=1,Salesperson),' ')

正解: D

質問 28
Refer to the exhibit.

USER1 has an app protected using this Section Access statement.
Which countries can USER1 see in the app''

A. Italy, The Netherlands
B. Italy, United Kingdom, The Netherlands
C. Germany Italy, The Netherlands
D. Germany. Italy, United Kingdom, The Netherlands

正解: C

質問 29
A data architect needs to load data from two different databases. Additional data will be added from a folder that contains QVDs, text files, and Excel files. What is the minimum number of data connections required?

A. Five
B. Three
C. Two
D. Four

正解: C

質問 30
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?

A. IntervalMatch and use variables
B. Class function in a calculated dimension
C. Class function in the script and use variables
D. Nested IFs in a calculated dimension

正解: B

質問 31
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?

A. Owner Publish, Read
B. Owner Publish
C. Publish
D. Publish, Read

正解: D

質問 32
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?