[2023年04月28日]QSDA2022試験問題集、QSDA2022練習テスト問題 [Q20-Q36]

[2023年04月28日]QSDA2022試験問題集、QSDA2022練習テスト問題

無料で使えるQSDA2022学習ガイド試験問題と解答

質問 20
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 aggregated data for 2 years and apply filters on a sheet for transaction data
B. Load only 2 years of data and use best practices in scripting and visualization to calculate and display aggregated 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

質問 21
A data architect needs to arrange data to create an app with a map where multiple location points consolidate into hexagonal areas based on postal codes The areas will be color coded based on the number of vendors in thelocation.
Which GeoAnalytics operation should the data architect use?

A. Simplify
B. Binning
C. Intersect
D. AddressLookup

正解: B

解説:
Explanation
Binning is a GeoAnalytics operation that can be used to arrange data into hexagonal areas based on postal codes. The areascan then be color coded based on the number of vendors in the location.Source: Qlik Binning is a GeoAnalytics operation that allows data points to be grouped into hexagonal areas based on a geographic field, such as postal codes. The data architect can use binning to group the location points by postal code and then color code the resulting hexagonal areas based on the number of vendors in each location.
This operation is useful for visualizing spatial data and identifying patterns or trends in the data.

質問 22
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

正解: B

解説:
Explanation
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.

質問 23
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. Order patient records by patient ID and admission date
B. Sequence patient records by patient ID using the Peek function
C. Sequence patient records by hospital account ID and patient ID using the Peek function
D. Calculate the days since previous discharge using admission date and discharge date

正解: A

質問 24
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. FileSize, IF, THEN, END IF
B. FilePath, FOR EACH, Peek, Drop
C. FilePath, IF, THEN. Drop
D. FileExists, FOR EACH, IF

正解: A

質問 25
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. Create a composite key using OrderlD and LineNo, and remove OrderlD and LineNo from Shipments
B. Remove the LineNo field from Shipments and use the AutoNumber function on the OrderlD field
C. Remove the LineNo field from both tables and use the AutoNumber function on the OrderlD field
D. Create a composite key using OrderlD and LineNo

正解: D

解説:
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.

質問 26
Refer to the exhibits.

A music teacher needs to know which artists are eligible to enter this year's competition.
The teacher needs to find only the artists who have a music grade rank above two and play more than one instrument.
Which expression is needed for the Number of Instruments measure in the table?

A. Count({$<Instrument={">=2"}, Artist={"=Grade>2"}>}Instrument)
B. Count({$<Artist={"=Count(Instrument)>=2"}, Artist={"=Grade>2"}>}Instrument)
C. Count({S<Count(Instrument)={">=2"}, Grades={">2"}>}Instrument)
D. Count ({S<Artist={"=Count(Instrument)>=2M}, Grades={">2"}>}Instrument)

正解: B

解説:
Explanation
The correct expression to use for the Number of Instruments measure in the table is Option A.
This expression will count the number of instruments played by artists with a music grade rank greater than two.
How to build a data architecture to drive innovation--today and ...
https://www.mckinsey.com/capabilities/mckinsey-digital/our-insights/how-to-build-a-data-architecture-to-drive- Big data in healthcare: management, analysis and future prospects ...
https://journalofbigdata.springeropen.com/articles/10.1186/s40537-019-0217-0 Obtaining Data From Electronic Health Records - Tools and ...
https://www.ncbi.nlm.nih.gov/books/NBK551878/

質問 27
A data architect completes development of a new app with two data sources Both data sources will also be used by other apps in the future The sources have different data refresh frequencies
* Source 1 Contains frequently updated data and must be refreshed hourly
* Source 2 Contains data that is transferred from a partner and must be refreshed weekly Tasks must be created to load the data sources and make sure that the new app uses the most current data The data will be stored in two QVDs Which tasks should be created to meet these requirements'?

A. 1. Schedule Task 1 to run hourly and refresh data from Source 1
2 Schedule Task 2 that is dependent on Task 1 to refresh data from Source 2
3. Schedule a task for the app that is dependent on completion of Task 2 that loads the two QVDs
B. 1 Schedule Task 1 to run hourly and refresh data from Source 1
2 Schedule Task 2 to run weekly and refresh data from Source 2
3. Schedule a task for the app that is dependent on completion of Tasks 1 or 2 that loads the two QVDs
C. 1 Schedule Task 1 to run hourly and refresh data from Source 1
2 Schedule Task 2 to run weekly and refresh data from Source 2
3. Schedule a task for the app that is dependent on completion of Task 2 that loads the two QVDs
D. 1. Schedule Task 1 to run hourly and refresh data from Source 1
2 Schedule Task 2 that is dependent on Task 1 to refresh data from Source 2
3 Schedule a task for the app that is dependent on completion of Tasks 1 and 2 that loads the two QVDs

正解: D

解説:
Explanation
This option ensures that the data in the two data sources is always up-to-date by scheduling the data refresh tasks to run at the appropriate frequencies. Task 1 runs hourly to refresh data from Source 1, and Task 2 is dependent on Task 1 so that it runs only after Task 1 is completed. This ensures that the data from Source 2 is loaded only after the most current data from Source 1 is loaded.

質問 28
Refer to the exhibit.

The data architect needs to build a model that contains Sales and Budget data for each customer.
Some customers have Sales without a Budget, and other customers have a Budget with no Sales During loading, the data architect resolves a synthetic key by creating the composite key For validation, the data architect creates a table containing Customer, Month. Sales, and Budget columns.
What does the data architect see when selecting a month?

A. All Customers, all Budget and all Sales records
B. Customer and Budget records for that month, but missing values for Sales
C. Customer and Sales records for that month, but missing values for Budget
D. Customer, Sales, and Budget records for that month

正解: D

質問 29
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)

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

正解: B

質問 30
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 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
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 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
D. 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

質問 31
Refer to the exhibit.

A data architect is loading the tables and a synth key is generated.
How should the data architect resolve the synthetic key?

A. Remove the LineNo field from both tables and use the AutoNumberfunction on the OrderlC field
B. Create a composite key using OrdertD and LineNo
C. Remove the LineNo field from Shipments and use the AutoNumber function on the
D. Create a composite key using OrderlD and LineNo. and remove OrderlD and LineNo from Shipments

正解: D

質問 32
Users of a published app report incomplete visualizations. The data architect checks the app multiple timesand cannot replicate the error. The error affects only one team.
What is the most likely cause?

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

正解: C

解説:
Explanation
Section access restricts access to certain records, and if too many records are restricted, it can lead to incomplete visualizations.Source: Qlik Section access is used to control access to the data in an app. If the section access settings are too restrictive, they can prevent certain users or teams from seeing all of the data they need, resulting in incomplete visualizations.
It is possible that the affected team has been assigned a section access that is too restrictive, preventing them from seeing all of the necessary data. This could be a misconfiguration or an oversight in the section access settings.

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

A. QVDs
B. Loop and Reduce
C. In-memory
D. ODAG

正解: A

解説:
Explanation
Using QVDs is the best approach for this scenario, as it allows the data to be stored in a highly compressed format, which will have minimal impact on server resources. Additionally, QVDs can be loaded quickly, which allows for faster access to the data based on user run-time selections. The other options, Loop and Reduce, In-memory, and ODAG, are not valid strategies for this scenario.

質問 34
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.)

A. Add the following to the end of the script:
TAG FIELD LocationName With 'Sgeoname', *@relates_Pt';
TAG FIELD Point With 'Sgeopoint*f 'Srelates Location', '$hidden';
B. Add the following to the end of the script:
TAG FIELD LocationName With 'Sgeodata1, 'Srelated'; TAG FIELD Point With 'Sgeodata', 'Srelated1;
C. Define Location as a master item, and set the tag to Sgeodata
D. Add GeoKakePoint (Lat, Long} as Point to Location's preceding load
E. Add GeoProject{' Point' , Lat&Long) AS Point to the preceding load

正解: A,E

質問 35
A data architect executes the following script:

What will Field_1 contain after this script is executed?