Which element should you add to the system.serviceModel section in the application configuration file?
You are moving a Windows Communication Foundation (WCF) service into production.
You need to be able to monitor the health of the service. You only want to enable all performance counter instances exposed by the ServiceModelService 4.0.0.0 counter group.
Which element should you add to the system.serviceModel section in the application configuration file?
What should you do?
You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKingA. Users regularly report that they receive error messages stating that the transaction log is full. When they get this message, their data changes fail. You notice that disk space on AIOTestKing A is limited. You need to configure AIOTestKing A to automatically prevent users’ data changes from failing due to full transaction logs. What should you do?
What should you do?
You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS)project.You create a
cube that has the following objects:
A dimension named ProductSubcategory that contains a table named DimProductSubcategory.A dimension named Product that contains a table named DimProduct.A fact table named FactInventory.
The relationship between the three tables is shown in the following exhibit. (Click the Exhibit button.)
You need to create a relationship on the Dimension Usage tab to browse through the data in theFactInventory table by using only the ProductSubcategory dimension.
What should you do?
Which element should you add to the system.serviceModel section in the application configuration file?
You are moving a Windows Communication Foundation (WCF) service into production.
You need to be able to monitor the health of the service. You only want to enable all performance counter instances exposed by the ServiceModelService 4.0.0.0 counter group.
Which element should you add to the system.serviceModel section in the application configuration file?
Which two actions should you perform?
You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKing A. All databases on AIOTestKing A have been created with the default auto file growth properties on one RAID 10 volume. All transaction logs on AIOTestKing A have been created without file growth enabled on a second RAID 10 volume. You need to ensure that you are notified when the databases are approaching disk capacity. You also need to prevent errors caused when any transaction log runs out of space. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
What should you do?
You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. The project has a fact table named FactOrders that contains columns named Order Amount, Country, and Order Date Key. You create the first partition for the fact table with the Source property set to “Select * from FactOrders where [Order Date Key]>354 or Country=’USA'”. You need to create the second partition for the fact table to ensure accurate results when queried. What should you do?
Which approach should you recommend?
You are planning a deployment process for a set of interrelated Web services.
You need to ensure maximum availability of the Web services in the event of a hardware or software failure.
Which approach should you recommend?
What should you do?
You are a database administrator for AIOTestKing.com. The company has a SQL Server 2005 computer that contains a single user database named DB1. All company employees connect to DB1. Company policy requires that the database be fault-tolerant and that failovers require no administrative effort. You need to provide fault tolerance for the database. Your solution must ensure that client computers can connect to the database, even if the SQL Server 2005 computer experiences a complete hardware failure, including a failure of all disks. What should you do?
Which MDX expression should you use?
You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project.
You create a cube with the following objects:
A time dimension named Time.
A fact table that contains two columns named Order Date Key and Numbers of Orders.
A Number of Orders measure added to a measure group named Measures.
The cube has a dimension usage named Order Date that links the Order Date Key column to the Time dimension.
You need to create a Multidimensional Expressions (MDX) calculation that displays the cumulative totals of the Number of Orders column for all hierarchies in the Order Date dimension.
Which MDX expression should you use?
Which approach should you recommend?
You need to design session state management for the rewritten Web application.
Which approach should you recommend?