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. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Terabytes (TB)
Unlimited
2 ways you can configure the Project Source to connect to the Metadata database
Project Source
2. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns
3 Schema types
Value Prompts
Level Prompts
Components of the Logical Data Model
3. The actual column name for a fact. Every fact must have at least 1 expression.
Fact Expression
Search-based prompts
3 types of Attributes
Schema Objects
4. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Desktop Analyst
Lookup Tables
Schema
Desktop Administrative Functions
5. You can _____________ in the Architect Graphical Interface.
MSTR Connectivity Wizard
Rollback your changes
Warehouse Catalog
Heterogeneous Fact
6. A development environment to create BI applications - allowing users to edit the Metadata database
Components of Compound Metrics
Desktop Analyst
4 types of Report Filters
Desktop Architec
7. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Lookup Table structure of a moderately denormalized schema
MSTR Desktop
'View of a Report'
Project
8. Schema Objects - Application Objects - Configuration Objects
Object Prompts
Report Subscription
3 Types of Objects in MSTR Desktop
3 Schema types
9. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
OLTP
Object Prompts
Limitations of the Attribute Creation Wizard
Lookup Tables
10. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
Attribute Relationships
To create a Report Prompt
4 tasks of the Attribute Creation Wizard
2 types of Fact Expressions
11. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Compound Metric
Reports
Application Objects
User Hierarchies
12. All report-level options overwrite ___________.
Nested Metrics
Report Filter
Project-level options/settings
Lookup Tables
13. 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 functions of Attribute Forms
Lookup Table structure of a completely denormalized schema
User Hierarchies
Fact Expression
14. Using the Prompt Generation Wizard - Inside the Report Editor
4 parts of the Project Design Process
Homogeneous Attribute
To create a Report Prompt
MSTR OLAP Services
15. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
The System
4 properties you must know in order to create attributes using the Attribute Editor
Limitations of the Attribute Creation Wizard
4 parts of the Project Design Process
16. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Fact Tables
4 types of Prompts
OLAP
Metrics
17. Used to dynamically alter the contents of a report. With prompts - you can determine at run-time the objects you want to retreive for a report and filtering conditions.
Search-based prompts
Report Prompts
Project-level options/settings
Lookup Table structure of a moderately denormalized schema
18. Used to modify a Report
3 components of a Report
Report Editor
Logical Data Model
'View of a Report'
19. Facts associated to the same column name in 1 or more tables
Report Definitions
Homogeneous Fact
Attribute Relationships
Schema
20. The unique values of an attribute obtained from the data-warehouse
Reports
Report Prompts
Sorting
Attribute Elements
21. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
Short-term (2 - 6 months)
Value Prompts
5 steps to creating a logical data model
Attribute Forms
22. A method of organizing the appearance of report results in a Grid report based on a criteria
Tasks when defining a User Hierarchy
Attribute or its relationship(s)
View Filter
Banding
23. Less storage - Simple SQL - Complex ETL
Lookup Table structure of a moderately denormalized schema
Objects you are allowed to Page-by
Characteristics of a Simple Table Key
Highest-level attributes
24. It contains links to specific folders in the Folder List
Shortcut Bar
To create the Project connectivity
2 types of Facts
Different methods for creating Page-by fields
25. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Filter Definition Prompts
Source system characteristics
Stored
Nested Metrics
26. What tool do you use to create the Metadata DSN connection?
MSTR Connectivity Wizard
Nested Metrics
Minimal or none
Data Pivoting
27. Grid View - Graph View - Grid/Graph View - SQL View
Display views you can Print by
ID form
Schema Object Editor
3 column types of a Physical Schema
28. Allow you to interact with the BI system - logically organize data to analyze complex relationships
Data Pivoting
To create the Project connectivity
Report Editor
MSTR applications
29. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Stored
Desktop Designer
4 parts of the Project Design Process
2 methods to creating Facts
30. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Search-based prompts
Simple Attribute Expression
Report Template
Types of analysis you can perform with OLAP Services
31. Enables you to select which tables from the data-warehouse to store in the Metadata database
Subtotals
Warehouse Catalog
Logical Data Model
User Hierarchies
32. Compound - Homogeneous - Heterogeneous
Configuration Wizard
The 3 MSTR Tools
3 types of Attributes
Lookup Table structure of a completely denormalized schema
33. More storage - Complex SQL - Simple ETL
Characteristics of a Compound Table Key
3 column types of a Physical Schema
2 types of Attribute Expression
Heterogeneous Attribute
34. View Filters are saved with the _____________.
Report Filter operators
To qualify a Metric in a Set Qualification
Report Definitions
4 types of Report Filters
35. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Highest-level attributes
Search Object
To create the Project connectivity
Attributes
36. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Configuration Wizard
Value Prompts
Components of a Derived Metric
Attribute Forms
37. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h
Source system characteristics
Default Project folder structure
5 steps to creating a logical data model
Highest-level attributes
38. Subtotals reflect accumulations at selected attribute levels
Long-term (2 - 5 years)
4 tasks of the Attribute Creation Wizard
Subtotals
To "drill down" on a report
39. The default entry-points.
Desktop Designer
Highest-level attributes
Using a Search Object
Simple Metrics
40. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Reports
New SQL
2 components of a Physical Schema
Components of Compound Metrics
41. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
3 types of Attributes
Using a Search Object
Required on the report for Outline Model to work
2 methods to creating Facts
42. Specifies what info to retrieve from a data-warehouse - and how to display it
Report Template
Characteristics of a Compound Table Key
View Filter
4 types of Metrics
43. Specifies a condition data must meet in order to be included in a report
Report Filter
MSTR applications
Data warehouse characteristics
Components of a Metric
44. 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
45. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
Unlimited
Project Source
MSTR OLAP Services
Data warehouse characteristics
46. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Sample Metrics commonly performed on Facts
Sorting
Derived Metrics
Lookup Table structure of a moderately denormalized schema
47. Used for - Initially populating the Metadata - Creating schema objects
Desktop Architec
Desktop Administrative Functions
MSTR Desktop Architect
Derived Metrics
48. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Objects you are allowed to Page-by
Level Prompts
Required on the report for Outline Model to work
Tasks when defining a User Hierarchy
49. AND - OR - OR NOT - AND NOT
ETL
Report Filter operators
Hierarchies
2 components of a Physical Schema
50. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form
2 types of Attribute Expression
Architect Graphical Interface
3 functions of Attribute Forms
Lookup Tables
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