Search This Blog

Lets go..

Saturday

SQL exam 70-461 questions and answers part 7



MS-SQL exam 70-461 questions and answers dumps find all part
QUESTION 81
You administer several Microsoft SQL Server 2012 database servers.
Merge replication has been configured for an application that is distributed across offices throughout a wide area network (WAN).
Many of the tables involved in replication use the XML and varchar (max) data types. Occasionally, merge replication fails due to timeout errors.
You need to reduce the occurrence of these timeout errors.
What should you do?
A. Set the Merge agent on the problem subscribers to use the slow link agent profile.
B. Create a snapshot publication, and reconfigure the problem subscribers to use the snapshot publication.
C. Change the Merge agent on the problem subscribers to run continuously.
D. Set the Remote Connection Timeout on the Publisher to 0.

  Ans: A

QUESTION 82
You administer a Microsoft SQL Server 2012 database that has Trustworthy set to on. You create a stored procedure that returns database-level information from Dynamic Management Views. You grant User1 access to execute the stored procedure.
You need to ensure that the stored procedure returns the required information when User1 executes the stored procedure. You need to achieve this goal by granting the minimum permissions required.
What should you do? (Each correct answer presents a complete solution. Choose all that apply.)
A. Create a SQL Server login that has VIEW SERVER STATE permissions. Create an application role and a secured password for the role.
B. Modify the stored procedure to include the EXECUTE AS OWNER statement. Grant VIEW SERVER STATE permissions to the owner of the stored procedure.
C. Create a SQL Server login that has VIEW SERVER STATE permissions. Modify the stored procedure to include the EXECUTE AS {newlogin} statement.
D. Grant the db_owner role on the database to User1.
E. Grant the sysadmin role on the database to User1.
Answer: BC



QUESTION 83
You use Microsoft SQL Server 2012 to develop a database application.
You need to implement a computed column that references a lookup table by using an INNER JOIN against another table.
What should you do?
A. Reference a user-defined function within the computed column.
B. Create a BEFORE trigger that maintains the state of the computed column.
C. Add a default constraint to the computed column that implements hard-coded values.
D. Add a default constraint to the computed column that implements hard-coded CASE statements.
Answer: A

QUESTION 84
You administer a Microsoft SQL Server 2012 server.
You plan to deploy new features to an application. You need to evaluate existing and potential clustered and non-clustered indexes that will improve performance.
What should you do?


A. Query the sys.dm_db_index_usage_stats DMV.
B. Query the sys.dm_db_missing_index_details DMV.
C. Use the Database Engine Tuning Advisor.
D. Query the sys.dm_db_missing_index_columns DMV.


Answer: C

QUESTION 84
You administer a Microsoft SQL Server database named Sales.
The database is 3 terabytes in size.
The Sales database is configured as shown in the following table. You discover that Sales_2.ndf is corrupt.
You need to recover the corrupted data in the minimum amount of time.
What should you do?

A. Perform a file restore.
B. Perform a transaction log restore.
C. Perform a restore from a full backup.
D. Perform a filegroup restore.
A



QUESTION 85
What is the difference between the simple CASE expression and the searched CASE expression?
A. The simple CASE expression is used when the database recovery model is simple, and the searched CASE expression is used when it's full or bulk logged.
B. The simple CASE expression compares an input expression to multiple possible expressions in the WHEN clauses, and the searched CASE expression uses independent predicates in the WHEN clauses.
C. The simple CASE expression can be used anywhere in a query, and the searched CASE expression can be used only in the WHERE clause.
D. The simple CASE expression can be used anywhere in a query, and the searched CASE expression can be used only in query filters (ON, WHERE, HAVING).
Answer: B

QUESTION 86
Why is it important to use standard SQL code when possible and know what is standard and what isn't? (Choose all that apply.)
A. It is not important to code using standard SQL.
B. Standard SQL code is more portable between platforms.
C. Standard SQL code is more efficient.
D. Knowing what standard SQL code is makes your knowledge more portable.

Answer: BD


QUESTION 87
Which of the following is not a violation of the relational model?

A. Using ordinal positions for columns
B. Returning duplicate rows
C. Not defining a key in a table
D. Ensuring that all attributes in the result of a query have names

Answer: D

QUESTION 88
You are maintaining a Microsoft SQL Server database that stores order information for an online store
website. The database contains a table that is defined by the following Transact-SQL statement:
You need to ensure that purchase order numbers are used only for a single order.
What should you do?

A. Create a new CLUSTERED constraint on the PurchaseOrderNumber column.
B. Create a new UNIQUE constraint on the PurchaseOrderNumber column.
C. Create a new PRIMARY constraint on the PurchaseOrderNumber column.
D. Create a new FOREIGN KEY constraint on the PurchaseOrderNumber column.


Correct Answer: B

QUESTION 89
You are developing a database in SQL Server 2012 to store information about current employee project assignments.
You are creating a view that uses data from the project assignment table. You need to ensure that the view does not become invalid if the schema of the project assignment table changes.
What should you do?

A. Create the view by using an account in the sysadmin role.
B. Add a DDL trigger to the project assignment table to re-create the view after any schema change.
C. Create the view in a new schema.
D. Add a DDL trigger to the view to block any changes.

Correct Answer: B

QUESTION 90
You are maintaining a Microsoft SQL Server database. You run the following query:
---
You need to ensure that the query performs returns the results as quickly as possible.
Which action should you perform?

A. Add a new index to the ID column of the Person table.
B. Add a new index to the EndDate column of the History table.
C. Create a materialized view that is based on joining data from the ActiveEmployee and History tables.
D. Create a computed column that concatenates the GivenName and SurName columns.

Correct Answer: A


Tuesday

Measurement Plan Presentation

Concordia University


Software Project Management

SOEN 6841



Project Presentation

On

Project Measurement Plan


Hassan Khalid
27885490
Asad Iftikhar
27094906
Mohammad Tuaha
40026959
Dinraj Majumder
40039931
Eric Watat Lowe
27720270
Shubhangi Sheel
40004793
Shubham Singh
40004796
Concordia University

Slide-2


Project Description.

-Commonwealth Software Inc issues.

-Business Goal.

Description of each of the 7 steps.


Conclusion.

Slide-3

Brainstorming Additional Sub Goal Statements

  - The name suggests after team discussion we identified the main objective (goal)


Operationalize Goals

 - we chose two of the sub goals identified in step 1 to carry on the measurement activity.


Success Criteria and Indicators

 - The success criteria and indicators for the identified sub goals are mentioned focusing on improving testing processes.


Sub goals to Strategies and Activities

 - We listed the details on strategies and activities to be carried on to achieve our chosen sub-goal.


Worksheet: Analysis and Progress Indicators

 - We developed our analysis strategy and identified progress indicators ..


Identifying The Data Elements to Be Collected, Availability, and Source

 - Involved identifying the data elements that need to be collected to formulate our success criteria, further tracking the progress, and assessment of the same.


Planning Tasks

 -Finally, in seventh step we tried to highlight the processes that must be available for successful accomplishment of the plan.

Slide-4

Step 1 - Brainstorming Additional Sub Goal Statements

Questions related to Improve testing processes


Entities Managed by Project Manager

Developers

Testing team

Documentation

Project Plan

Test Plan and strategy

Pre-releases and source code.

Effort estimation and schedule estimation of software

Product Development

Software Process Testing

Risk Management

Customer can change requests (work in process)

Slide-5

Identified Sub-Goals

Define clear Service Level Agreements (SLA) / Estimated Time of Accomplishments (ETA) and comply with the same.
To have a ticketing system in place, so all incidents can be recorded, tracked and followed properly and to be resolved in timely manner.
Track the contributors of the module in question to have them look into the issue, encouraging them for better and timely patch / fix to the issue.
Testing processes to be more robust and thorough adhering to the standards.

Sub Goal 1: Track the contributors of the module in question to have them look into the issue, encouraging them for better and timely patch / fix to the issue.
Slide-6
Step 2 - Operationalize Goals
Perspective: Software development manager
Object of interest: Code
Purpose: In order to minimize SLA breaches, we aim to track contributor’s progress through status reporting which ensures that the task will be completed within defined timeline.
Quality focus and Perspective
Examine the Testability, Maintainability and Reusability from the perspective of the code.
Environment and Constraints
Technical reviews and status updates to be carried on by Software Developers, Testers and Project Manager. 

Slide-7

Step 2 - Operationalize Goals
Sub Goal 2: Testing processes to be more robust and thorough adhering to the standards.
Perspective: Software development manager
Object of interest: Test Scenarios / Test cases
Purpose: To improve the testing process in order to reduce defects in new software release and minimize user complaints.
Quality focus and Perspective
Examine the quality, Stability, and correctness of the code from the viewpoint of the testers/ users.
Environment and Constraints
User acceptance testing and Software testing to be conducted in order to ensure the code compliance with the requirements.
That’s all my part. Now I would to invite subhangi sheel to countinue


Slide-8
Step 3 - How do we define Success?
What is the number of defects propagation reduced in the last deliverable?
What is the total time increase for resolving failures by last deliverable?
How much planned, actual and actual ok per test cases increased?
What percentage of classes are in the zone of excellent, good and poor?


Slide-9

Step 4 - SubGoals to Strategy Activity
Strategy 1:
Aim to discover defects early in the development stage with Test-Driven Development (TDD) - In TDD, test cases are identified before development of the module.
Strategy 2:
Ensure that code added after each iteration does not break previews, tested and approved code to limit and track defects propagation. This could be supported by the use of automated tools.
Slide-10
Step 5 - Analysis and Progress Indicator
Strategy
Ensure that code added after each iteration    does not break    previews, tested and approved code to limit and track defects propagation. This could be supported by the use of automated tools.
Activity   definitions Regression Test and unit tests case, Debugging, progress reporting, Update the defects tracker.
Questions about the Activity
How much code is covered by the test cases?
What is the reduction rate of defects propagation?
What is the acceptable Testing progression rate? (test case/hours)
How much test cases must be successful?
How much time should it take to resolve a client request?

To be continue ….
Contact to author. Mohammad Tuaha