Certification Questions

Which method should you use to group query filters together to form one AND statement?

A. Select the filters, then click the Group Filters button on the toolbar

B. Select the filters, right-click and select Group

C. Drag the queries together

D. Drag the query filters to the Group panel

You are archiving a Security Log for later analysis in a spreadsheet. Which file type should you assign to the log when you save it?

Your network consists of a single Active Directory domain. All network servers run Windows Server 2003 Service Pack 2 (SP2). You share a folder named Research. A user named User1 reports that he cannot access files in the Research share. You confirm that the Domain Users group is granted the Change permission for the Research share. You run the Cacls command as shown in the exhibit:

You need to ensure that User1 can modify files in the Research share. You must prevent User1 from modifying permissions for the Research folder. To which group should you add User1?

Can’t update primary table’s primary key if row being modified has related rows in secondary table once referential integrity is enforced

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an
application. The application connects to a Microsoft SQL Server database. The application has two DataTable objects that reference the Customers and Orders tables in the database. The application contains the following code segment. (Line numbers are included for reference only.)

01DataSet customerOrders = new DataSet();
02customerOrders.EnforceConstraints = true;
03ForeignKeyConstraint ordersFK = new ForeignKeyConstraint("ordersFK",
04customerOrders.Tables["Customers"].Columns["CustomerID"],
05customerOrders.Tables["Orders"].Columns["CustomerID"]);
06
07customerOrders.Tables["Orders"].Constraints.Add(ordersFK);

You need to ensure that an exception is thrown when you attempt to delete Customer records that have related Order records. Which code segment should you insert at line 06?

Multiple users can share a local temporary table

Management by projects views aspects of ongoing operations as projects in order to apply Project Management techniques to them. This can be used to describe an oranizational approach to the management of ongoing operations. Why would a company want to utilize this methodology on nonprojects?

What is the primary purpose of having multi-dimensional data models?

A. To deliver structured information that the business user can easily navigate by using any possible combination of business terms to show the KPIs.

B. To make it easier for developers to build applications, that will be helpful for the business users.

C. To make it easier to store data in the database and avoid redundancy.

D. All the above