SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
Search
Test your basic knowledge |
Certified Project Designer Cpd
Start Test
Study First
Subjects
:
certifications
,
it-skills
Instructions:
Answer 50 questions in 15 minutes.
If you are not ready to take this test, you can
study here
.
Match each statement with the correct term.
Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.
This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. OLAP Services does not add any ______ to the report query.
OLTP
Heterogeneous Fact
Locking and Resizing
New SQL
2. The unique values of an attribute obtained from the data-warehouse
To create the Project connectivity
4 parts of the Project Design Process
Attribute or its relationship(s)
Attribute Elements
3. Enables you to select which tables from the data-warehouse to store in the Metadata database
Reports
Column Aliases
Warehouse Catalog
Report Definitions
4. The System Hierarchy is automatically updated whenever you make a change to an __________________.
3 functions of Attribute Forms
Project Creation Wizard
Data Pivoting
Attribute or its relationship(s)
5. Homogeneous - Heterogeneous
2 types of Facts
3 Sections of the MSTR Desktop interface
2 types of Fact Expressions
Shortcut Bar
6. Facts associated to the same column name in 1 or more tables
2 types of Attribute Expression
Homogeneous Fact
3 Schema types
2 types of Attribute Relationships
7. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Stored
Display views you can Print by
View Filters
Thresholding
8. Facts associated to different column names in 2 or more tables
Cannot create project objects
Search Object
2 types of Attribute Expression
Heterogeneous Fact
9. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Types of analysis you can perform with OLAP Services
Methods are there to creating Attributes
4 types of Metrics
Table Keys
10. It contains links to specific folders in the Folder List
Shortcut Bar
Attribute Creation Wizard good for
Object Prompts
Heterogeneous Fact
11. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Column Aliases
Banding
4 types of Metrics
Short-term (2 - 6 months)
12. Attribute Qualification: A condition an attribute element must meet - Set Qualification: To restrict report results based on a Metric - Shortcut to a Report: A resultset of an existing report - Shortcut to a Filter: To use 1 or more existing filters
'View of a Report'
4 types of Report Filters
Very high; part of ETL process
5 steps to creating a logical data model
13. Enables you to further narrow down a report view - using only those objects in the report without altering the SQL of the report query. They are executed after-the-fact.
Cannot create project objects
Compound Attribute
View Filters
Using a Search Object
14. Extraction - transformation - loading
ETL
Search Object
'View of a Report'
MSTR OLAP Services
15. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
4 factors to consider when designing a data-warehouse schema
Outline Mode
5 Report display views
Data warehouse characteristics
16. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
MSTR Connectivity Wizard
Schema Objects
Source system characteristics
Components of a MSTR architecture
17. Creating multiple attributes quickly. Used during the initial project creation.
Attribute Creation Wizard good for
Search-based prompts
Shortcut Bar
Table Keys
18. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
To save a Report Format
Report Filter
To create the Project connectivity
Report Prompts
19. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Lookup Table structure of a completely normalized schema
Search Object
Default Project folder structure
Desktop Administrative Functions
20. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Characteristics of Nested Metrics
Outline Mode
Desktop Designer
Schema
21. Specifies what info to retrieve from a data-warehouse - and how to display it
3 functions of Attribute Forms
Report Template
Types of analysis you can perform with OLAP Services
2 methods to creating Facts
22. The Attribute Form Expression that maps to a single column - no matter the number of tables
Page-by
Simple Attribute Expression
Report Formatting
New SQL
23. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
To "drill down" on a report
Gigabytes (GB)
Reports
Relationship Tables
24. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
Outline Mode
View Filter
4 properties you must know in order to create attributes using the Attribute Editor
Heterogeneous Fact
25. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
Shortcut Bar
Level Prompts
Configuration Wizard
3-Tier Architecture
26. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Desktop Architec
To qualify a Metric in a Set Qualification
Schema Objects
Report Objects
27. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Shortcut in MSTR Desktop
Attribute Elements
Cannot create project objects
Limitations of the Attribute Creation Wizard
28. Direct: 2-tier - Server: 3-tier
Compound Metric
2 ways you can configure the Project Source to connect to the Metadata database
Factors to consider when designing a logical data model
Project Creation Wizard
29. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
Very high; part of ETL process
2 types of Table Keys
Lookup Table structure of a completely normalized schema
5 steps to creating a logical data model
30. Using the Prompt Generation Wizard - Inside the Report Editor
Sorting
MSTR Connectivity Wizard
4 properties you must know in order to create attributes using the Attribute Editor
To create a Report Prompt
31. The actual column name for a fact. Every fact must have at least 1 expression.
Attribute Elements
To edit the appearance of a Graph in a report
Components of Compound Metrics
Fact Expression
32. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked
Very high; part of ETL process
To qualify a Metric in a Set Qualification
Schema
Sorting
33. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Object Prompts
MSTR OLAP Services
Application Objects
Characteristics of a Simple Table Key
34. A condition data must meet in order to be included in a report. Does affect the SQL.
Report Filter
Page-by
Notes
Value Prompts
35. A subset of a report that users can manipulate without altering the SQL
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
36. One that uses 2 or more columns as its ID
Compound Attribute
Attribute Elements
Desktop Analyst
Report Objects
37. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
Schema Object Editor
To "drill down" on a report
Search Object
Short-term (2 - 6 months)
38. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Report Subscription
Very high; part of ETL process
Object Prompts
File types are allowed for exporting a Report
39. A feature that enables users to delivers reports to the history list - cache or mobile
Thresholding
Default Project folder structure
Highest-level attributes
Report Subscription
40. How users can share comments for reports to other users
2 types of Facts
3 Sections of the MSTR Desktop interface
ETL process
Notes
41. Enables you to rearrange the columns and rows in a report.
Data Pivoting
Attribute Forms
Methods are there to creating Attributes
MSTR Desktop Architect
42. To see data at completely different levels - other than that of the original Grid or Graph
Required on the report for Outline Model to work
Drilling
Types of analysis you can perform with OLAP Services
Schema
43. Level of OLTP integration
MSTR applications
Minimal or none
Report Template
Types of analysis you can perform with OLAP Services
44. Enables you to select and display subsets of a report as separate pages.
Page-by
Value Prompts
Gigabytes (GB)
Search-based prompts
45. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Different methods for creating Page-by fields
To create the Project connectivity
Objects you are allowed to Page-by
4 properties you must know in order to create attributes using the Attribute Editor
46. Create the Project Source - Create the Database Instance
2 types of Facts
To create the Project connectivity
Report Template
Project Creation Wizard
47. A method of organizing the appearance of report results in a Grid report based on a criteria
2 types of Table Keys
Banding
Report Objects
Homogeneous Attribute
48. Used to limit a possibly overwhelming set of potential prompt answers
Minimal or none
Search-based prompts
4 parts of the Project Design Process
2 ways you can configure the Project Source to connect to the Metadata database
49. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
MSTR Desktop
Outline Mode
Page-by
Components of a Derived Metric
50. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
ETL process
Very high; part of ETL process
Attribute Forms
Highest-level attributes