000-719 Questions And Answers

QUESTION 1
What are two reasons for a combination of database and front-end tool based analytic architectures in a data warehouse implementation? (Choose two.)

A. Less data is moved across the network, making queries run faster.
B. The database can provide consistent analytic calculations and query speed for common queries.
C. The combination of architectures will ensure fast query performance.
D. Multidimensional queries cannot be processed in SQL by the database engine so it must be done using a front-end tool.
E. The front-end tool allows for additional and more complex algorithms specific to applications that use that tool.

Answer: BE


QUESTION 2
After deploying an application, you might need to update it by making changes to one or more data flows. Deploying changes to an existing application is called delta deployment. How do you package changes using delta deployment?

A. Package only the operator or property that has changed.
B. Package the data flow that has changed.
C. Package the control flow.
D. Package all the items that were originally packaged and use the same profile that was used.

Answer: C


QUESTION 3
You are implementing a DB2 Workload Manager (WLM) schema to limit the number of load utilities that can execute concurrently. Which WLM object would be used to accomplish this?

A. work class with an associated work action and an appropriate threshold
B. workload with an associated service class and an appropriate threshold
C. work class with an associated service class and an appropriate threshold
D. workload with an associated work action and an appropriate threshold

Answer: A