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. It contains the ID column of the parent attribute
Advantage of a completely denormalized schema
Characteristics of a Simple Table Key
Lookup Table structure of a completely normalized schema
Report Filter
2. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Metrics
5 Report display views
4 types of Prompts
Long-term (2 - 5 years)
3. User requirements - Existing source data - Technical and performance considerations
Cannot create project objects
2 types of Fact Expressions
Locking and Resizing
Factors to consider when designing a logical data model
4. A development environment to create BI applications - allowing users to edit the Metadata database
Sample Metrics commonly performed on Facts
MSTR Desktop
Desktop Architec
Project
5. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
View Filter
2 types of Attribute Relationships
MSTR applications
The System
6. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Warehouse Catalog
Facts
Attributes
Fact Tables
7. Enables you to select and display subsets of a report as separate pages.
Using a Search Object
Page-by
Long-term (2 - 5 years)
3 Methods of MSTR Desktop navigation
8. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
4 parts of the Project Design Process
Compound Metric
2 types of Fact Expressions
The System
9. Folder List - Object Viewer - Shortcut Bar
3 Sections of the MSTR Desktop interface
OLTP
Cannot create project objects
Sample Metrics commonly performed on Facts
10. OLAP Services does not add any ______ to the report query.
3 types of Attributes
2 types of Fact Expressions
New SQL
Required on the report for Outline Model to work
11. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Cannot create project objects
3-Tier Architecture
Attribute Relationships
Desktop Analyst
12. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Required on the report for Outline Model to work
Project-level options/settings
3 Schema types
Shortcut Bar
13. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Application Objects
Display views you can Print by
Simple Metrics
Default Project folder structure
14. Enables you to select which tables from the data-warehouse to store in the Metadata database
Warehouse Catalog
Desktop Designer
3 components of a Report
File > Email Reports As
15. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
Derived Metrics
5 steps to creating a logical data model
Components of a Derived Metric
OLTP
16. The Attribute Form Expression that maps to a single column - no matter the number of tables
To create a Report Prompt
Simple Attribute Expression
To save a Report Format
2 types of Attribute Expression
17. Extraction - transformation - loading
Lookup Tables
ETL
Logical Data Model
Default Project folder structure
18. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
View Filter
Objects you are allowed to Page-by
Sample Metrics commonly performed on Facts
Derived Metrics
19. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Heterogeneous Fact
By default
ETL process
Reports
20. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Fact Tables
Warehouse Catalog
Types of drilling
Project Creation Wizard
21. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Process for creating the Project Metadata
4 properties you must know in order to create attributes using the Attribute Editor
Attribute Forms
Schema
22. Facts - Attributes - Hierarchies
3 Sections of the MSTR Desktop interface
Compound Metric
Configuration Wizard
Components of the Logical Data Model
23. A feature that enables users to delivers reports to the history list - cache or mobile
Stored
Tasks when defining a User Hierarchy
Thresholding
Report Subscription
24. A condition data must meet in order to be included in a report. Does affect the SQL.
Report Subscription
Report Prompts
Report Filter
Project Source
25. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Facts
Unlimited
Page-by
Desktop Architec
26. Descriptive data that provides context for Facts.
2 ways you can configure the Project Source to connect to the Metadata database
To create the Project connectivity
Characteristics of a Simple Table Key
Attribute Forms
27. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
Limitations of the Attribute Creation Wizard
Attribute Elements
Report Editor
OLAP
28. More storage - Complex SQL - Simple ETL
Factors to consider when designing a logical data model
3 functions of Attribute Forms
Characteristics of a Compound Table Key
Data Pivoting
29. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
4 parts of the Project Design Process
Data warehouse characteristics
Aggregate a Metric
Facts
30. OLTP retains data ________
Filter Definition Prompts
Short-term (2 - 6 months)
Relationship Tables
Object Prompts
31. 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
32. Simple - Derived
2 types of Attribute Expression
Architect Graphical Interface
Types of analysis you can perform with OLAP Services
Fact Expression
33. An environment in which the MSTR Desktop connects directly to the Metadata database.
Subtotals
2-Tier Architecture
Very high; part of ETL process
Project
34. OLTP data storage measure
Gigabytes (GB)
Report Prompts
Report Template
Fact Tables
35. Direct: 2-tier - Server: 3-tier
Fact Expression
Unlimited
2 ways you can configure the Project Source to connect to the Metadata database
Components of Compound Metrics
36. Template - Filter - View of a Report
Relationship Tables
Types of analysis you can perform with OLAP Services
2 components of a Physical Schema
3 components of a Report
37. Must have a one-to-one relationship with all other forms.
Report Filter operators
Attribute Forms
MSTR Desktop Architect
Lookup Tables
38. Used to modify a Report
4 parts of the Project Design Process
Heterogeneous Fact
Report Editor
OLAP
39. How users can share comments for reports to other users
3 Methods of MSTR Desktop navigation
Notes
3 functions of Attribute Forms
Minimal or none
40. To define the level of aggregation for a specific metric - Used for qualifications
Using a Search Object
Attributes
OLAP
Attribute Relationships
41. OLAP retains data ________
Attribute or its relationship(s)
To create a Report Prompt
Report Template
Long-term (2 - 5 years)
42. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Lookup Table structure of a moderately denormalized schema
Types of analysis you can perform with OLAP Services
Data warehouse characteristics
3 Types of Objects in MSTR Desktop
43. Columns - Tables
Column Aliases
Cannot create project objects
2 components of a Physical Schema
Project Source
44. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
Relationship Tables
Minimal or none
To qualify a Metric in a Set Qualification
4 properties you must know in order to create attributes using the Attribute Editor
45. A method of organizing the appearance of report results in a Grid report based on a criteria
Banding
Derived Attribute Expression
Outline Mode
4 properties you must know in order to create attributes using the Attribute Editor
46. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
2 types of Table Keys
2 components of a Physical Schema
MSTR applications
Attribute Forms
47. Prompts to select a single value on which to qualify a date - number or text string.
Homogeneous Attribute
Attribute Relationships
Configuration Wizard
Value Prompts
48. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
5 Report display views
Attribute Relationships
Using a Search Object
Physical Schema
49. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations
Architect Graphical Interface
Characteristics of Nested Metrics
Report Template
Reference Report Objects
50. Used to "fine-tune" your Project
Architect Graphical Interface
Table Keys
2 types of Fact Expressions
Hierarchies