信頼できるQlik Sense Data Architect QSDA2022問題集PDF 2023年04月12日最近更新された問題
必ず合格できるQlik QSDA2022試験正確な78問題と解答あります
質問 # 46
Refer to the exhibit.
A data architect is loading the tables and a synthetic key is generated.
How should the data architect resolve the synthetic key?
- A. Remove the LineNo field from both tables and use the AutoNumber function on the OrderlD field
- B. Remove the LineNo field from Shipments and use the AutoNumber function on the OrderlD field
- C. Create a composite key using OrderlD and LineNo
- D. Create a composite key using OrderlD and LineNo, and remove OrderlD and LineNo from Shipments
正解：C
解説：
Explanation
This is the recommended approach to resolving synthetic keys, as it allows you to maintain the integrity of the data by combining two or more fields into a single key. The composite key can then be used to join the two tables together, ensuring that the data is consistent and accurate.
質問 # 47 
Refer to the exhibit
A data architect is working on an app that contains orders, invoices, and shipping data. There are three different date fields within the data:
* OrderDate
* InvoiceDate
* ShippingDate
The business analyst needs to replicate the chart above to show Order and Shipping amounts on the same Month axis.
What should the data architect do?
- A. Left Join the three date fields onto one bridge table using the key field containing KeyField and Date
- B. Load the key field and the three date fields into a concatenated bridge table that contains KeyField and Date
- C. Create a Month field for each of the three dates in the fact table and use that in the chart
正解：B
質問 # 48
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 date Which 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
正解：C
質問 # 49
Refer to the exhibit.
What are the values of the variables vLoadStart and vLoadComplete after the script executes?
- A. vLoadStart: current system date and time when the script started vLoadComplete: 'now()'
- B. vLoadStart: system date when the app was opened vLoadComplete: current system date and time when the script ended
- C. vLoadStart; 'NOW{)'
vLoadComplete: current system date and time when the script ended - D. vLoadStart: system date when the app was opened vLoadComplete 'now()'
正解：A
解説：
Explanation
vLoadStart variable is assigned the current system date and time when the script starts, and vLoadComplete variable is assigned the current system date and time when the script ends.
質問 # 50 
Refer to the exhibit.
A data architect is loading two tables: Orders and Product. The Product table includes attributes and values for each ProductID such as Colour, Price, Category, and Description.
The business analyst can filter by the value of these attributes. For performance reasons, the Data Model will use two tables.
Which solution should the data architect apply in the Data Load Editor to build the ProductDetails table?
For performance reasons, the Data Model will use two tables a Load Editor to build the ProductDetails table?
- A. Use a Generic Loadin the Product table and a For loop to left join each Generic table
- B. Use a For loop to apply a Generic load to the Product table and concatenate the generic tables together
- C. Use a For loop to concatenate all of the Products table and apply a Generic Load to the final concatenate table
正解：A
質問 # 51
A data architect of an organization that has implemented Qlik Sense on Windows needs to load large amounts of data from a database that 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 aQVD file. The data architect wants to load the records into Qlik Sense efficiently.
Which steps should the data architect take to meet these requirements?
- A. 1. Load the existing data from the QVD
2. Load new andupdated data from the database Concatenate with the table loaded from the QVD.
3. Create a separate table for the deleted rows and use a WHERE NOT EXISTS to remove these records - B. 1. Use a partial LOAD to load new and updated data from the database.
2.Load the existing data from the QVD without the updated rows that have just been loaded from the database and concatenate with the new and updated records
3. Use the PEEK function to remove the deleted rows - C. 1 Load the new and updated data fromthe database.
2. Load the existing data from the QVD without the updated rows that have just been loaded from the database and concatenate with the new and updated records.
3. Load all records from the key field from the database and use an INNER JOIN onthe previous table. - D. 1 Load the existing data from the QVD
2. Load the new and updated data from the database without the rows that have just been loaded from the QVD and concatenate with data from the QVD
3. Load all records from the key field from the database and use an INNER JOIN on the previous table
正解：C
質問 # 52
A data architect needs to develop multiple apps for various departments.
More departments are requesting apps over time The company uses specific requirementsfor the number interpretation variables (e.g., ThousandSep, DecimalSep) found at the beginning of a LOAD script.
The data architect wants to reduce duplicate scripts but does not want to copy and paste the number interpretation variables each time new appis created. The data architect prefers to use the least amount of script in Qlik Sense.
How should the data architect meet these requirements?
- A. Create an Excel file with the number interpretation variables and use a FOR Next loop to load the variables into Qlik Sense
- B. Save the script for the number interpretation variables in a text file and INLUDE function to insert the variables
- C. Save the script for the number interpretation variables in a text file and use the CALL function to insert the variables.
- D. Create an Excel file with the number interpretation variables and apply the variables to the app using a mapping table
正解：B
解説：
Explanation
This method involves saving the script for the number interpretation variables in a separate text file, and then using theINCLUDE function to insert the variables into each new app script that is created. This reduces the need to copy and paste the number interpretation variables each time a new app is created and allows the data architect to use the least amount of script in Qlik Sense.
The INCLUDE function is a script statement that allows you to insert the contents of one script file into another script file. This can be used to insert common scripts, such as the number interpretation variables, into multiple app scripts.
質問 # 53
Refer to the exhibit.
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 script is valid to load the tables and maintain the correct association?
A)
B)
C)
D)
- A. Option C
- B. Option B
- C. Option A
- D. Option D
正解：A
質問 # 54 
A data architect is creating an app using three tables. After executing thescript, a warning displays Which two steps should the data architect do to resolve this warning? (Select two.)
- A. Move the preceding Load statement in line 10 between table name (line 23) and Load statement (line
24). - B. Rename the Category field in theProductPriceLis table to PnceCategory (line 24).
- C. insert "Join (ProductDetails)" in front of the Load statement in line 24 to combineProductPriceList with ProductDetails
- D. Remove the rename statement (line 24) in the ProductPriceList table leaving the Product field name as is.
正解：B
質問 # 55
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 A439926003 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 architectuse to meet these requirements?
- A. FilePath, IF, THEN. Drop
- B. FileSize, IF, THEN, END IF
- C. FilePath, FOR EACH, Peek, Drop
- D. FileExists, FOR EACH, IF
正解：B
質問 # 56 
Refer to the exhibits.
The first table, Mastersports, contains the master list of all sport names that need to be loaded into the app. The second table, TeamMembers, containsthe teams and team members registered for specific sports.
In a Qlik Sense app, a data architect is loading the two tables that need to be linked together based on the Sport field. The table format cannot be changed in the source.
What should the dataarchitect do in the data load editor?
- A. Apply a preceding LOAD from the TeamMembers table with the SUBFIELD function and rename the field to Sport
- B. Apply a FOR loop to load to the MasterSports table creating the values for the Sport field
- C. Apply a preceding LOAD to the MasterSports table with the SUBFIELD function to create the Sport field
正解：B
質問 # 57
Refer to the exhibit.
A data architect needs to add a Budget table to the current Qlik Sense app. A Budget table with the fields Budget, CustomerlD, and ProductlD is loaded into the model. What will be created?
- A. A circular reference with one table disconnected
- B. A synthetic table with two synthetic keys
- C. A synthetic table and one synthetic key
- D. A synthetic table with three synthetic keys
正解：A
質問 # 58
A data architect needs to write theexpression 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. Concat (DISTINCT IF (Aggr (Rank (Sum (Sales) , 1) , Salesperson) =1, Salesperson) , ' ')
- B. FirstSortedValue (DISTINCT Salesperson, -Aggr (Sum(Sales) , Salesperson) )
- C. FirstSortedValue (Salesperson, -Aggr (Sum(Sales) , Salesperson) )
- D. Concat(DISTINCT IF (Aggr (Rank (Sum (Sales) , 4) , Salesperson) =1, Salesperson) , ' ')
正解：A
質問 # 59
A company generates 1 GB of ticketing data daily. The data is stored in multipletables 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. Load only 2 years of data and use best practices in scripting and visualization to calculate and display aggregated data
- B. Load only aggregated data for 2 years and apply filters on a sheet for transaction data
- C. Load only 2 years ofdata in an aggregated app and create a separate transaction app for occasional use
- D. Load only aggregated data for 2 years and use On-Demand App Generation (ODAG) for transaction data
正解：D
質問 # 60
A data architect executes the following script:
What will Field_1 contain after this script is executed?
- A. abcd
- B. Abcd, abcd
- C. Abed, abed, ABCD, ABCDABCD
- D. Abed, abed, ABCD
正解：D
質問 # 61
A data architect needs to add the UnitCost field from the ProductCost table in the Dim_Products Table.
Which script code should the data architect use?
- A.
- B.
- C.
- D.
正解：C
質問 # 62
A data architect is building a model to show trends in visualizations across seven date fields. The seven date fields reside in different tables. The data architect must efficiently build this data model.
Requirements:
* A single date selector
* Show all dates, even those with NO activity
* Minimize the impact on server resources and p
Which two solutions should the data architect use? (Select two.)
- A. Data island
- B. Generic load
- C. Multiple calendars
- D. Link table
- E. Canonical calendar
正解：D、E
解説：
Explanation
A canonical calendar should be used to create a single date selector that can be used to show all dates, even those with no activity. A link table should be used to join the seven date fields from different tables, which willminimize the impact on server resources and performance.Source: Qlik
質問 # 63
Refer to the exhibits.
A business analyst needs to see the currency conversion provided by a third party process, and only contains a record when the rate changes in a chart. The currency conversion rate data is An existing master calendar exists in the data model that contains a full set of dates.
Which technique should the data architect use to meet this requirement?
- A. Use ITERNO and AUTOGENERATE to create a new calendar from max and min dates of the currency conversion table
- B. OUTER JOIN the calendar with the currency conversion table
ORDER BY the date and use the PEEK function to fill in blank values - C. Utilize INTERVALMATCH to load the currency conversion rate between dates theconversation changed INNER JOIN the resultant table back into the master calendar
- D. Leverage a FOR loop between the start date and end date of the master calendar Use the MATCH function to add the currency conversion rates to the master calendar
正解：B
質問 # 64 
Refer to the exhibits.
An app is built to analyze salesperson performance by department. Departments are unique within the Departments table, but Salespeople often move between departments. A strict business rule states that 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 total sales KPI shows the correct result.
How should the data architect modify the data model to correct this issue?
- A. Create a bridge table between the Transactions and Salespeople tables to resolve the many-to-many relationship
- B. Join the Transactions and Salespeople tables to resolve the many-to-many relationship
- C. Create a bridge table between the Departments and Salespeople tables to resolve the many-to-many relationship
- D. Join theDepartments and Salespeople tables to resolve the many-to-many relationship
正解：C
質問 # 65
A company decides to migrate all apps from QlikView to Qlik Sense. After converting an apps: there are several unconverted objects What should the data architect do?
- A. Save the unconverted objects as master items
- B. Re-create the unconverted objects
- C. Remove the set analysis statements from the unconverted objects
- D. Save the unconverted objects as extensions and import them into Qlik Sense
正解：B
解説：
Explanation
After migrating an app from QlikView to Qlik Sense, there may be some unconverted objects. In this case, the data architect should re-create the unconverted objects in order to ensure that the app works properly in Qlik Sense. The other options will not work, as saving the unconverted objects as extensions or master items will not ensure that the app works properly, and removing set analysis statements will not help either.
qlik-sense-certification-exam-study-guide-en.pdf
https://www.qlik.com/us/-/media/files/training/global-us/qlik-sense-certification-exam-study-guide-en.pdf?la=en Talk to Experts Tuesday - Migrating from QlikView to Qlik Sense FAQ
https://community.qlik.com/t5/Support-Knowledge-Base/Talk-to-Experts-Tuesday-Migrating-from-QlikView-to Certifications & Qualifications | Qlik
https://www.qlik.com/us/services/training/certifications-and-qualifications
質問 # 66
......
2023年最新の実際にある検証済みのQSDA2022問題集：https://jp.fast2test.com/QSDA2022-premium-file.html
合格させるQSDA2022試験で更新された78問題あります：https://drive.google.com/open?id=18lV6-UDqE8BJaWXpiBkucumpi8N1GAEG