Testinside Sas a00-204
Posted September 26th, 2008 by PassGuide.com-Free Braindumps Bootcampsas warehouse architect concepts : A00-204 Exam
Exam Number/Code: A00-204
Exam Name: sas warehouse architect concepts
Questions and Answers: 65 Q&As
Price: $125.00
Update Time: 2008-6-24
QUESTION 24
Which of the following is the process of determining and evaluating the distance or
variance between two items’ properties?
A. matrix method
B. correlation coefficient
C. gap analysis
D. quadrant analysis
Answer: C
QUESTION 25
The source data for a warehouse is a UNIX system. Assume that preprocessing of the
extract will be performed on the source system. Which of the following provides the best
view of the system capacity available?
A. vmstat
B. sar
C. ps
D. iostat
Answer: B
Actualtests.com – The Power of Knowing
QUESTION 26
A business process has been selected from a single operational system and has been
modeled as part of a data mart. According to “The Data Warehouse Toolkit” by Ralph
Kimball, which of the following is the suggested next step in the design of the
dimensional model?
A. completing the entity-relationship model
B. choosing the dimensions that will be required
C. profiling the source system tables to determine the data suitability
D. determining the granularity of the data in the fact table
Answer: D
QUESTION 27
A retail group has two subsidiary companies. Each company maintains a different
operational system. A data warehouse is being developed that uses data from both
systems. The warehouse design specifies a conformed customer dimension. Which of the
following defines the process of combining the customer data from both systems?
A. business rules
B. cleansing
C. validation
D. de-duplication
Answer: A
QUESTION 28
A star schema data model has been adopted for a data warehouse. A customer dimension
includes a date-of-birth column that is frequently used for analysis. Which of the
following techniques improves the performance of a query based on date-of-birth?
A. modifying the date-of-birth column to four bytes
B. generating an age column derived from the date-of-birth
C. adding an index to the date-of-birth column
D. creating a composite index on the customer key and date-of-birth columns
Answer: C
QUESTION 29
Assume that a test fails in acceptance testing. The root cause analysis indicates an
incorrectly implemented business rule that is dependent on a single source table. Which
of the following is an appropriate resolution?
A. Correct the problem and rerun the acceptance test.
B. Create a new unit test for the problem, correct the problem, and rerun the acceptance
test.
C. Create a new system test for the problem, correct the problem, and rerun the
acceptance test.
D. Create a new integration test for the problem, correct the problem, and rerun the
Actualtests.com – The Power of Knowing
acceptance test.
Answer: B
QUESTION 30
A medical insurance company has developed a data warehouse containing confidential
data about its customers. Power users require OLAP functionality with reach-through to
the detail data. Which of the following supports the users’ requirements while protecting
customer privacy?
A. suppressing personal details from summarized reports
B. securing sensitive data within the detail schema
C. providing only aggregated statistics
D. securing the data within the OLAP application
Answer: B
QUESTION 31
A global company has developed an enterprise-wide data warehouse for use by analysts
located in many countries. Replication services for the warehouse have been proposed.
Which of the following requirements may be supported with this strategy?
I.disaster recovery
II.improved response time
III.improved hardware maintainability
IV.availability 24 hours a day, 7 days a week
A. I and III only
B. II, III, and IV only
C. I, II, III, and IV
D. III and IV only
Answer: C
Actualtests.com – The Power of Knowing
QUESTION 33
Which of the following guidelines should be followed to increase the success of a Joint
Application Development (JAD) session?
I.Plan a detailed agenda and stick to it.
II.Set clear, defined, and obtainable goals.
III.Encourage use of technical language to save time.
IV.Obtain executive sponsor’s commitment and support.
A. I, II, and IV only
B. I, II, and III only
C. I, II, III, and IV
D. II, III, and IV only
Answer: A
QUESTION 35
A supermarket has the following requirements:
analyze recent product line promotions
analyze annual and seasonal revenue trends.
Which of the following strategies satisfies the requirements while managing disk space
and query performance?
A. maintaining the most recent six months of detail data
B. archiving detail data after six months
C. retaining aggregate data for 24 months and detail data for three months
D. maintaining a detail snapshot of the current month
Answer: C
QUESTION 36
A telecommunications company wishes to develop customer retention models from data
in its enterprise data warehouse. The warehouse stores large volumes of detail data in a
snowflake schema. Which of the following is the most appropriate data structure for data
mining?
A. an extract from the billing system
B. a denormalized table
C. a fact table
D. a star schema
Answer: B
QUESTION 37
A SAS reporting application is used by 100 users within a company. The user base is
equally divided between power, intermediate, and novice users. All users are currently
sharing the same temporary space when executing queries to produce reports.
Examination of the user logs indicates I/O contention when using the temporary space.
Which of the following would improve I/O performance?
A. prioritizing execution of all jobs by user level
B. assigning all 100 users their individual temporary space
C. using logical partitioning of the temporary space by user group
D. forcing all users to execute queries using permanent space
Answer: B
QUESTION 38
Actualtests.com – The Power of Knowing
According to “The Data Warehouse Lifecycle Toolkit” by Ralph Kimball, which of the
following statements are true regarding a Type II slowly changing dimension?
I.It maintains history as it occurred.
II.It requires the creation of a surrogate key.
III.It overwrites the values in the dimension row.
IV.It maintains the original value and writes the new value in a separate column.
A. I and II only
B. I and III only
C. II and IV only
D. III and IV only
Answer: A
QUESTION 39
A warehouse architect wishes to start a warehouse extract, transform and load (ETL)
process as soon as the operational system’s overnight batch run is complete.
Which of the following can be used to maximize the warehouse batch window?
I.monitoring database system flags
II.comparing the creation dates of files
III.scheduling job at a pre-determined time
IV.checking for the existence of necessary files
A. II, III, and IV only
B. II and IV only
C. I and III only
D. I, II, and IV only
Answer: B
QUESTION 40
According to the SAS Rapid Warehousing Methodology, which of the following
activities are recommended for a business-driven approach for warehousing projects?
I.Business managers act as project managers.
II.Business managers identify the business needs and benefits.
III.Information to measure business benefits is gathered in the early phases of the project.
IV.Emphasis is placed on reviewing the project to measure benefit and return on
investment.
A. II and III only
B. II, III, and IV only
C. I, II, III, and IV
D. III and IV only
Answer: B
“sas warehouse architect concepts”, also known as A00-204 exam, is a SAS Institute certification.
Preparing for the A00-204 exam? Searching A00-204 Test Questions, A00-204 Practice Exam, A00-204 Dumps?
Free A00-204 Demo Download
TestInside offers free demo for A00-204 exam ( sas warehouse architect concepts). You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only one site can offer demo for almost all products.
Related Posts
Related Posts
Tags: a00-204
One Response to “Testinside Sas a00-204”
September 26th, 2008 at 4:30 pm
[...] sas advanced programming exam Testinside a00-203 sas warehouse development specialist concepts exam Testinside a00-204 sas warehouse architect concepts Testinside a00-205 sas webaf server-side application development [...]
Leave a Reply