QSDA Exam: Questions With In-Depth Solutions
3 Ways to solve a many to many relationship Right Ans - Concatenate
tables
link table
surrogate key
Concatenate tables Right Ans - common fields are 100% populated
Link table Right Ans - a. Links two or more fact tables by taking all common
fields out of the original tables and placing them into a new one, contains all
possible combination of values for that set of fields, through a unique key, is
associated to original tables.
Solving synthetic keys Right Ans - 1. Alias field names
2. Remove conflicting fields from one of the tables
3. Create a complex (concatenated) key and remove those 2 conflicting fields
Solving Circular reference Right Ans - a. Concatenate tables
b. Create a link table
c. Rename a field or use qualify function
QMC Right Ans - Qlik management console: used to monitor apps, streams,
sercurity, user, ect..
Data connections: Right Ans - 1. File folders
2. ODBC - Open Database Connectivity
3. OLE DB - Object Linking and Embedding Database
4. Web files from a URL
5. Custom connectors downloaded from the Qlik download page
3 Connections with default security rules Right Ans - 1. Webfile
2. ODBC
3. OLEDB
Select...From Right Ans - • Passed through and executed by the source
database
• Any functions or transformation must be a valid syntax of the source
database, not Qlik functions
, • Data is usually pulled from these sources and stored into a QVD (extract
layer)
Load...From Right Ans - • Used when loading from any file (only one source
file at a time, unlike SELECT)
• Any statement that starts with the word LOAD may include QlikView Load
Script syntax and functions
Available clauses in load statements Right Ans - Where exists
While
Group by
Order by
Where exists Right Ans - a. WHERE EXISTS clause will limit data to show
only what is specified in the clause.
b. Has 2 parameters
c. 1st-specifies the field on which we need to check to see if there are any
occurrences of the values contained in second field, the one specified in the
second parameter
d. Can use one parameter too
e. When have one parameter the QVD is optimized, while 2 parameters are not
optimized
While Right Ans - a. Used in conjunction with AutoGenerate and the IterNo
(Iteration Number) function to create a loop that continues to run, generating
rows of data, as long as the condition in the WHILE clause is true.
Group By Right Ans - a. is a clause that is required whenever using
aggregation functions in conjunction with non-aggregated fields.
b. Aggregation function in script
c. When grouping, cannot use aliased field name
Order By Right Ans - a. Sorts the rows in a table by one or many fields in
ascending or descending order. If no sort order is specified it will sort by
ascending order.
b. Can only be used with a resident load
c. Used to sort the data in a table by one or many fields
d. If sort order is not specified, data will be sorted in ascending order
e. Can only be used when loading from a Resident Table
3 Ways to solve a many to many relationship Right Ans - Concatenate
tables
link table
surrogate key
Concatenate tables Right Ans - common fields are 100% populated
Link table Right Ans - a. Links two or more fact tables by taking all common
fields out of the original tables and placing them into a new one, contains all
possible combination of values for that set of fields, through a unique key, is
associated to original tables.
Solving synthetic keys Right Ans - 1. Alias field names
2. Remove conflicting fields from one of the tables
3. Create a complex (concatenated) key and remove those 2 conflicting fields
Solving Circular reference Right Ans - a. Concatenate tables
b. Create a link table
c. Rename a field or use qualify function
QMC Right Ans - Qlik management console: used to monitor apps, streams,
sercurity, user, ect..
Data connections: Right Ans - 1. File folders
2. ODBC - Open Database Connectivity
3. OLE DB - Object Linking and Embedding Database
4. Web files from a URL
5. Custom connectors downloaded from the Qlik download page
3 Connections with default security rules Right Ans - 1. Webfile
2. ODBC
3. OLEDB
Select...From Right Ans - • Passed through and executed by the source
database
• Any functions or transformation must be a valid syntax of the source
database, not Qlik functions
, • Data is usually pulled from these sources and stored into a QVD (extract
layer)
Load...From Right Ans - • Used when loading from any file (only one source
file at a time, unlike SELECT)
• Any statement that starts with the word LOAD may include QlikView Load
Script syntax and functions
Available clauses in load statements Right Ans - Where exists
While
Group by
Order by
Where exists Right Ans - a. WHERE EXISTS clause will limit data to show
only what is specified in the clause.
b. Has 2 parameters
c. 1st-specifies the field on which we need to check to see if there are any
occurrences of the values contained in second field, the one specified in the
second parameter
d. Can use one parameter too
e. When have one parameter the QVD is optimized, while 2 parameters are not
optimized
While Right Ans - a. Used in conjunction with AutoGenerate and the IterNo
(Iteration Number) function to create a loop that continues to run, generating
rows of data, as long as the condition in the WHILE clause is true.
Group By Right Ans - a. is a clause that is required whenever using
aggregation functions in conjunction with non-aggregated fields.
b. Aggregation function in script
c. When grouping, cannot use aliased field name
Order By Right Ans - a. Sorts the rows in a table by one or many fields in
ascending or descending order. If no sort order is specified it will sort by
ascending order.
b. Can only be used with a resident load
c. Used to sort the data in a table by one or many fields
d. If sort order is not specified, data will be sorted in ascending order
e. Can only be used when loading from a Resident Table
