COG-625考題下載

hongsongzhu

<p align="left"><p align="left">最新COG-625考題分享</p></p><p align="left"><p align="left">Question: 1</p></p><p align="left"><p align="left">To reduce memory usage, what should be done when setting up dimension breaking for a</p></p><p align="left"><p align="left">fact build?</p></p><p align="left"><p align="left">A. Ensure that each data source is sorted by the same set of dimensions, in the same</p></p><p align="left"><p align="left">sequence.</p></p><p align="left"><p align="left">B. Specify at least one aggregate rule for each dimension element for which breaking is</p></p><p align="left"><p align="left">enabled.</p></p><p align="left"><p align="left">C. Disable the hash table and page pool for the fact build.</p></p><p align="left"><p align="left">D. Disable late arriving facts processing for the fact build.</p></p><p align="left"><p align="left">Answer: A</p></p><p align="left"><p align="left">Question: 2</p></p><p align="left"><p align="left">During execution, a fact build generated the following messages in the log file:What can be</p></p><p align="left"><p align="left">done to avoid seeing the last three lines when the build is executed again?</p></p><p align="left"><p align="left">A. Increase the initial size of the hash table.</p></p><p align="left"><p align="left">B. Decrease the size of the page pool.</p></p><p align="left"><p align="left">C. Disable audit logging.</p></p><p align="left"><p align="left">D. Increase the amount of working memory (in megabytes).</p></p><p align="left"><p align="left">Answer: A</p></p><p align="left"><p align="left">Question: 3</p></p><p align="left"><p align="left">What can be done to minimize memory consumption?</p></p><p align="left"><p align="left">A. Disable dimension breaking on the fact build.</p></p><p align="left"><p align="left">B. Disable fact build logging.</p></p><p align="left"><p align="left">C. Enable dimension breaking on the fact build.</p></p><p align="left"><p align="left">D. Enable auditing on the fact build.</p></p><p align="left"><p align="left">Answer: C</p></p><p align="left"><p align="left">Question: 4</p></p><p align="left"><p align="left">A dimension table tracks employee data. If an employee's work location changes, the</p></p><p align="left"><p align="left">previous work location needs to be kept and a new record needs to be created. What kind of</p></p><p align="left"><p align="left">change is this?</p></p><p align="left"><p align="left">A. Type 0</p></p><p align="left"><p align="left">B. Type 1</p></p><p align="left"><p align="left">C. Type 2</p></p><p align="left"><p align="left">D. Type 3</p></p><p align="left"><p align="left">Answer: C</p></p><p align="left"><p align="left">Question: 5</p></p><p align="left"><p align="left">A dimension table contains the following data:The incoming fact data is as follows:If late</p></p><p align="left"><p align="left">arriving fact processing is enabled, what will be the value of the surrogate key assigned to the</p></p><p align="left"><p align="left">last row of fact data?</p></p><p align="left"><p align="left">A. 11110</p></p><p align="left"><p align="left">B. 11111</p></p><p align="left"><p align="left">C. 11112</p></p><p align="left"><p align="left">D. 11113</p></p><p align="left"><p align="left">Answer: B</p></p>