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. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Characteristics of a Simple Table Key
'View of a Report'
Simple Metrics
Desktop Administrative Functions
2. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
Report Objects
2 types of Attribute Relationships
Table Keys
Aggregate a Metric
3. More storage - Complex SQL - Simple ETL
Facts
3 types of Attributes
2 ways you can configure the Project Source to connect to the Metadata database
Characteristics of a Compound Table Key
4. Used to limit a possibly overwhelming set of potential prompt answers
Advantage of a completely denormalized schema
Search-based prompts
Short-term (2 - 6 months)
Column Aliases
5. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
Shortcut Bar
Project Source
4 properties you must know in order to create attributes using the Attribute Editor
Fact Tables
6. All Attributes must have an _______.
Subtotals
4 properties you must know in order to create attributes using the Attribute Editor
Desktop Analyst
ID form
7. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
By default
Types of analysis you can perform with OLAP Services
4 properties you must know in order to create attributes using the Attribute Editor
Outline Mode
8. Enables you to rearrange the columns and rows in a report.
Lookup Tables
Data Pivoting
3 types of Attributes
Homogeneous Fact
9. View Filters are saved with the _____________.
Report Definitions
Report Editor
Drilling
Banding
10. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Shortcut Bar
4 types of Report Filters
Desktop Designer
Physical Schema
11. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
4 parts of the Project Design Process
Display views you can Print by
Metrics
Object Prompts
12. Tables - Facts - Attributes - Hierarchies
Compound Metric
4 basic Schema objects
Simple Attribute Expression
Hierarchies
13. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
2 types of Table Keys
Process for creating the Project Metadata
Desktop Architec
Using a Search Object
14. It contains links to specific folders in the Folder List
Attribute Relationships
Facts
2 components of a Physical Schema
Shortcut Bar
15. 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.
3 project creation interfaces
View Filters
File > Email Reports As
Notes
16. The Attribute Form Expression that maps to a single column - no matter the number of tables
Attributes
Sorting
Simple Attribute Expression
To edit the appearance of a Graph in a report
17. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Facts
Default Project folder structure
Types of analysis you can perform with OLAP Services
2-Tier Architecture
18. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
2 components of a Physical Schema
2-Tier Architecture
Report Filter
Search Object
19. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Components of a MSTR architecture
Schema
2 types of Attribute Relationships
Facts
20. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Characteristics of a Compound Table Key
Compound Metric
Attribute Forms
3 column types of a Physical Schema
21. All report-level options overwrite ___________.
Project-level options/settings
MSTR applications
Data Pivoting
Unlimited
22. Specifies a condition data must meet in order to be included in a report
Report Filter
2 types of Attribute Expression
4 types of Metrics
Reports
23. 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
Filter Definition Prompts
Project Creation Wizard
Attribute Creation Wizard good for
4 types of Report Filters
24. You can e-mail reports by going to _____
Unlimited
Short-term (2 - 6 months)
File > Email Reports As
Data warehouse characteristics
25. User reporting requirements - Query performance - Data volume - DB Maintenance
4 factors to consider when designing a data-warehouse schema
Heterogeneous Fact
Display views you can Print by
Column Aliases
26. Grid View - Graph View - Grid/Graph View - SQL View
OLAP
Display views you can Print by
4 basic Schema objects
Components of Compound Metrics
27. Metrics you create within a report using only those objects in the report.
File types are allowed for exporting a Report
Search Object
Report Definitions
Derived Metrics
28. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Objects you are allowed to Page-by
Derived Metrics
Logical Data Model
Project Source
29. Create the Project Source - Create the Database Instance
Report Editor
Tasks when defining a User Hierarchy
Components of a MSTR architecture
To create the Project connectivity
30. Used to modify a Report
Report Editor
2 components of a Physical Schema
Outline Mode
4 tasks of the Attribute Creation Wizard
31. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
Nested Metrics
Desktop Designer
To edit the appearance of a Graph in a report
The 3 MSTR Tools
32. Facts - Attributes - Hierarchies
Schema Objects
Fact Tables
Limitations of the Attribute Creation Wizard
Components of the Logical Data Model
33. Folder List - Object Viewer - Shortcut Bar
Very high; part of ETL process
Report Filter operators
Limitations of the Attribute Creation Wizard
3 Sections of the MSTR Desktop interface
34. Descriptive data that provides context for Facts.
Cannot create project objects
Attribute Forms
Components of a Derived Metric
3 components of a Report
35. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
Gigabytes (GB)
Drilling
View Filter
2 options for Sorting
36. How users can share comments for reports to other users
Attributes
2 types of Attribute Relationships
Notes
Warehouse Catalog
37. A user interface for creating and maintaining a BI environment
Compound Attribute
Facts
Application Objects
MSTR Desktop
38. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Stored
Report Objects
Limitations of the Attribute Creation Wizard
Search-based prompts
39. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Short-term (2 - 6 months)
3 Types of Objects in MSTR Desktop
Different methods for creating Page-by fields
Drilling
40. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
Subtotals
File types are allowed for exporting a Report
Components of Compound Metrics
Default Project folder structure
41. Less storage - Simple SQL - Complex ETL
Objects you are allowed to Page-by
Using a Search Object
Schema
Characteristics of a Simple Table Key
42. The default entry-points.
New SQL
Lookup Table structure of a completely normalized schema
Relationship Tables
Highest-level attributes
43. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
The System
Limitations of the Attribute Creation Wizard
MSTR Connectivity Wizard
Attribute Creation Wizard good for
44. Formula - Level (Dimensionality) - Conditionality - Transformation
Components of a Metric
Physical Schema
Gigabytes (GB)
4 properties you must know in order to create attributes using the Attribute Editor
45. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.
3 Methods of MSTR Desktop navigation
User Hierarchies
To create a Report Prompt
Homogeneous Fact
46. Level of OLAP integration
MSTR Desktop Architect
Report Definitions
Very high; part of ETL process
Methods are there to creating Attributes
47. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Desktop Designer
Facts
Default Project folder structure
Cannot create project objects
48. 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
Characteristics of Nested Metrics
3-Tier Architecture
Tasks when defining a User Hierarchy
Notes
49. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
5 Report display views
3 functions of Attribute Forms
Project
Reports
50. A method of organizing the appearance of report results in a Grid report based on a criteria
Banding
Tasks when defining a User Hierarchy
Derived Metrics
To edit the appearance of a Graph in a report
Sorry!:) No result found.
Can you answer 50 questions in 15 minutes?
Let me suggest you:
Browse all subjects
Browse all tests
Most popular tests
Major Subjects
Tests & Exams
AP
CLEP
DSST
GRE
SAT
GMAT
Certifications
CISSP go to https://www.isc2.org/
PMP
ITIL
RHCE
MCTS
More...
IT Skills
Android Programming
Data Modeling
Objective C Programming
Basic Python Programming
Adobe Illustrator
More...
Business Skills
Advertising Techniques
Business Accounting Basics
Business Strategy
Human Resource Management
Marketing Basics
More...
Soft Skills
Body Language
People Skills
Public Speaking
Persuasion
Job Hunting And Resumes
More...
Vocabulary
GRE Vocab
SAT Vocab
TOEFL Essential Vocab
Basic English Words For All
Global Words You Should Know
Business English
More...
Languages
AP German Vocab
AP Latin Vocab
SAT Subject Test: French
Italian Survival
Norwegian Survival
More...
Engineering
Audio Engineering
Computer Science Engineering
Aerospace Engineering
Chemical Engineering
Structural Engineering
More...
Health Sciences
Basic Nursing Skills
Health Science Language Fundamentals
Veterinary Technology Medical Language
Cardiology
Clinical Surgery
More...
English
Grammar Fundamentals
Literary And Rhetorical Vocab
Elements Of Style Vocab
Introduction To English Major
Complete Advanced Sentences
Literature
Homonyms
More...
Math
Algebra Formulas
Basic Arithmetic: Measurements
Metric Conversions
Geometric Properties
Important Math Facts
Number Sense Vocab
Business Math
More...
Other Major Subjects
Science
Economics
History
Law
Performing-arts
Cooking
Logic & Reasoning
Trivia
Browse all subjects
Browse all tests
Most popular tests