当前位置:MCITP(70-447)题库

问题:

[单选]

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as the administrator of a SQL Server 2005 computer, and the computer is called SQL1. There are two databases on the SQL1, and the two databases are respectively named Production and DW. A new database named Staging is created. When the data are moving from the Production database into the DW database, the Staging database is utilized temporarily to store and manipulate data. Since you are the database administrator, you are required to make sure the points listed below. First, the tables should not be removed from the Staging database. Second, any attempts to have tables migrated should be logged. Third, your solution should not impact on other databases. 
Which action should be performed to achieve the goal?()

A . To achieve the goal, a DML trigger on each table should be created to prevent deletion of data.
B . To achieve the goal, a DDL trigger should be created, and that the ON DATABASE parameter is utilized by DDL trigger for the Staging database.
C . To achieve the goal, an event notification should be created to fire when the TRUNCATE TABLE Transact-SQL statement is submitted to the Staging database.
D . To achieve the goal, a DDL trigger should be created, and the ON ALL SERVER parameter is utilized by the DDL trigger.

you can perform an active database duplication when the database is in NOARCHIVELOG mode.()  True。  False。 噪音 A Business Partner storage specialist is proposing an IBM System Storage DS5000 solution to aninstalled EMC customer. Which IBM resource should the Business Partner engage to assist withcompetitive sales strategies against EMC?() Competeline 。 Executive Briefing Center 。 Competitive Benchmark Center 。 Field Technical Support Specialist (FTSS)。 You need to meet the business requirements of the packaging department. What should you do?() Add the ProductSize data table and the ProductSizeDescriptor column to the Product dimension. Set the order of the ProductSKU attribute to the ProductSizeDescriptor column.。 Add the ProductSize data table as a dimension and then add this dimension to the cube as a Referenced dimension. Set the order of the key attribute of the ProductSize dimension to the ProductSizeDescriptor column.。 Add the ProductSize data table and the ProductSizeDescriptor column to the Product dimension. Create a user-defined hierarchy that has ProductSKU as the top-level attribute and ProductSizeDescriptor as the bottom-level attribute.。 Add the ProductSize data table as a dimension and then add this dimension to the cube as a Referenced dimension. Create a user-defined hierarchy within the ProductSize dimension. Set the ProductSizeDescriptor attribute as the top-level attribute.。 假日,我和妻子去风景区游玩。天气预报说有雨,我们带了伞。那天果然下起了大雨。游人很多,有不少人没带伞,大雨瓢泼而下,他们立刻就被淋成了落汤鸡,一个个狼狈不堪。我和妻子安然无事,只是雨水打湿了一点裤腿,鞋子沾上了一点泥巴。那天妻子很快乐。过了一天,我们去另一个地方游玩。天气预报还是说有雨,我们照旧带了伞。可是那天却没有下雨,于是雨伞成了我们手中的累赘。看看别的游客没有带伞,两手空空十分轻松的样子,妻就开始后悔:不该带伞。这一天妻子不快乐。妻说:“昨天大雨把别人淋成落汤鸡没把我淋着,所以我快乐。今天别人手里没有累赘,我有累赘所以我不快乐。”于是我又明白了:为什么昨天我们会为有了一辆自行车而快乐得睡不着觉,今天有了轿车却烦心得吃不下饭?不是因为自己走得比过去慢了,而是因为过去你骑车比别人走得快,今天你的“捷达”却赶不上别人的“奔驰”。我明白了很多很多,但有一条不明白:干吗老是把眼睛盯住别人?自己觉得快乐,这还不够吗?有什么理由要自寻烦恼,让自己的快乐在跟别人的比较中变成不快乐呢? 根据这一案例,下面的结论哪种是不正确的?() 人的能力有大小,客观因素又很多,没必要总想着和别人争高低。 快乐与不快乐并不在于自己是不是过得好,而在于跟别人比较自己是不是过得好。。 人不能知足常乐,需要更多的东西来满足自己的欲望。 人有时应知足常乐,不要自寻烦恼。

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as the administrator of a SQL Server 2005 computer, and the computer is called SQL1. There are two databases on the SQL1, and the two databases are respectively named Production and DW. A new database named Staging is created. When the data are moving from the Production database into the DW database, the Staging database is utilized temporarily to store and manipulate data. Since you are the database administrator, you are required to make sure the points listed below. First, the tables should not be removed from the Staging database. Second, any attempts to have tables migrated should be logged. Third, your solution should not impact on other databases. 
Which action should be performed to achieve the goal?()

参考答案:

  参考解析

本题暂无解析

相关题目:

在线 客服