70-300 Analyzing Requirements And Defining Microsoft .net Solution Architectures Pt.7

Front 1

Which term is synonymous with response time?

Back 1

latency

Front 2

How do you prevent an application from saving the view state of a control across HTTP requests?

Back 2

Set the EnabledViewState property of the control to false. This will prevent a control's view state from being saved and will improve application performance.

Front 3

What is the preliminary goal of physical design?

Back 3

to transform the logical design into specifications for a set of components and identify the technologies required

Front 4

With .NET applications, why can you use XCOPY or FTP to distribute an application without requiring an installation?

Back 4

because .NET assemblies are self-describing and no registry entries are required

Front 5

Other than the authentication options of ASP.NET, how else might you choose to authenticate users of an XML Web service?

Back 5

Use SOAP-based security, passing the user's credentials in the header of the SOAP message.

Front 6

What is the primary tradeoff when choosing a multi-tier design?

Back 6

It usually requires more analysis and design effort, but will be much easier to maintain and scale.

Front 7

To which default event log would you write any warning messages about possible security violations or security configuration changes?

Back 7

security log

Front 8

How does the Trace object differ from the Debug object?

Back 8

Calls to the Debug object are removed for Release builds, while Trace object calls are not.

Front 9

What is DTS?

Back 9

Data Transformation Services(DTS) is a tool that supports the import, export, and transformation of data between OLE DB data sources.

Front 10

With the .NET Framework, which three methods of distributed component communication can you use?

Back 10

.NET Remoting, XML Web services, and DCOM

Front 11

To calculate the amount of disk space a table's data will occupy, which formula should you use?

Back 11

(Number of Attributes)x(Size of Each Attribute)=Total Bytes per Row 8060/Total Bytes per Row = Number of Rows per Page (round down to nearest whole number)
Number of Rows in Table / Number of Rows per Page = Number of Pages Required
Number of Pages Required * 8192 bytes = Number of Bytes Required

Front 12

Which two types of event logs might you use to record information from your application?

Back 12

the application log or a custom log

Front 13

What should you do to improve queries in a write-intensive database when most queries join two or three tables?

Back 13

Create indexes on the columns used in the join conditions where feasible.

Front 14

Which tool can you use with a Web service class's description file to generate a proxy class for the Web service?

Back 14

Wsdl.exe(Web Services Description Language Tool)

Front 15

On which operating systems are event logs available?

Back 15

Windows NT, Windows 2000, Windows Server 2003, and Windows XP

Front 16

Which type of replication should be used to update data on the remote server on a per-transaction basis?

Back 16

transactional replication

Front 17

The inclusion of a Window menu in an application indicates which type of interface?

Back 17

MDI(Multiple Document Interface)

Front 18

From where are items stored in the ASP.NET Application object available?

Back 18

from the global.asax file and from all the pages in the current application, even across other current sessions

Front 19

What is HTTP?

Back 19

HTTP(Hypertext Transfer Protocol
0 is a stateless communications protocol used to transfer hypertext documents over the Web.

Front 20

What does a SqlConnection object represent?

Back 20

a connection to a unique session with a SQL Server data source

Front 21

Does .NET provide localization features that allow for automatic translation of text or currency values to different cultures?

Back 21

Yes

Front 22

Why might you implement the TraceSwitch class in your code?

Back 22

to provide conditional control of when or how tracing will occur

Front 23

As a best practice, which character encoding should you use to represent text when globalizing or localizing your application?

Back 23

Unicode

Front 24

Name four types of contextual help.

Back 24

Context-sensitive Help, ToolTips, Status bar messages, and Help command buttons

Front 25

When does a Windows service stop running?

Back 25

when the computer on which it is running shuts down or when a user explicitly stops the service

Front 26

Which .NET Framework component provides data access?

Back 26

ADO.NET

Front 27

When might you use a Windows Forms application instead of a Web application?

Back 27

when you need to take advantage of the processing power on the client desktop or when no Web server is available

Front 28

Are items stored in the ASP.NET Session object available to all sessions?

Back 28

No

Front 29

Which functionality does the .NET PerformanceCounter class provide?

Back 29

the ability to create custom performance counters to the Windows NT performance counters

Front 30

Which form of user assistance provides a sequence of dialog boxes that assist a user in performing a specific task?

Back 30

wizard

Front 31

Does a Windows service have a user interface?

Back 31

No

Front 32

What is role-based security?

Back 32

Role-based security is a type of security that is based on users' roles or functions. With role-based security, you can use code to verify the identity and role membership for an application user.

Front 33

What is the purpose of COM Interop?

Back 33

It provides a bridge between COM and .NET as a bidirectional service. It is used to generate RCWs for COM components can be used by .NET assemblies.

Front 34

How does static discovery differ from dynamic discovery?

Back 34

With static discovery, you explicitly specify the services you want clients to discover, and with dynamic discovery, locations are dynamically searched for Web services or other discovery files. You can explicitly specify locations that should not be searched during dynamic discovery.

Front 35

What two types of indexes does SQL Server support for a database table?

Back 35

clustered and nonclustered

Front 36

Code assess security policies can be defined at which four levels?

Back 36

enterprise, machine, user, and application domain

Front 37

To what does the term "code access security" refer?

Back 37

the process of verifying if a piece of code has the appropriate permissions to access a given resource, regardless of the permissions granted to the user

Front 38

What would be the maximum number of kilobytes transferred by an application in ten(10) seconds if the connection speed was 40 kilobits per second?

Back 38

40 kilobits per second/8=5 kilobytes per second
5 kilobytes per second * 10 seconds = 50 kilobytes

Front 39

What does the TcpListener class provide?

Back 39

the ability to create an object to listen for connections from TCP clients

Front 40

Why should you avoid using a status bar to display information that could not be obtained through another part of the application's interface?

Back 40

because users are typically allowed to hide the status bar if desired

Front 41

In the .NET environment to what does the term "Enterprise Services" refer?

Back 41

traditional COM+ services like distributed transactions, object pooling, and concurrency management

Front 42

What are the three default event logs?

Back 42

system, security, and application

Front 43

In a two-tier application, where would your ADO.NET code to access a data store be located?

Back 43

in the presentation, or user services, layer

Front 44

In which measurement is latency usually measured?

Back 44

in units of time, such as seconds or milliseconds

Front 45

What is XCOPY deployment?

Back 45

distributing an application using the DOS Xcopy command, or simply copying the program's directory structure and files from one location to another

Front 46

Should you use a TraceSwitch object to provide automatic monitoring in an application?

Back 46

No. Trace and TraceSwitch objects are great to provide debug and troubleshooting information when you are having problems with the system, but they should not be used as a normal place to output management information because tracing causes a considerable hit on performance.

Front 47

What is an XML Web service?

Back 47

a platform-neutral programming module that uses the HTTP, XML, and SOAP protocols

Front 48

What is contextual help?

Back 48

help, such as What's This help or ToolTips, that is available to the user without the user leaving the context in which he is working

Front 49

Do application tiers always correspond to physical locations on the network?

Back 49

No. For example, the business logic layer and the data services layer may physically reside on the same machine.

Front 50

Which type of replication should be used to obtain only the current copy of the data?

Back 50

snapshot replication

Front 51

How many clustered indexes are allowed per database table?

Back 51

only one because a clustered index controls the physical ordering of the data

Front 52

Which type of application usually runs as a compiled stand-alone executable without a UI and is run from the command line?

Back 52

console application

Front 53

What features does Host Integration Server provide?

Back 53

-Web-based access to applications for 3270 and 5250 clients
-Single user Log-on that allows users to be authenticated for the desktop and host system with one log on
-Secure connectivity via the Internet
-Data access to legacy data in flat files, VSAM files, and legacy databases
-Server-based 3270 and 5250 print emulation to allow for printing mainframe reports to a LAN printer
-Easy integration with MTS and COM+ and IBM's CICS or IMS envoronments
-Object-oriented programming support developers

Front 54

What is SSL?

Back 54

SSL(Secure Sockets Layer) is a protocol that provides for encrypted communications on the internet.

Front 55

When possible, which index type is automatically created by default when a PRIMARY KEY constraint is created?

Back 55

clustered

Front 56

When calculating response time, which latencies should be considered?

Back 56

Network latency(the time it takes data to travel from one location to another) and Application latency(the time it takes the application to process the data)

Front 57

Which project type is used primarily to deploy shared components?

Back 57

a Merge Module Setup project

Front 58

What is DCOM?

Back 58

DCOM(Distributed Component Object Model) is an object protocol that enables ActiveX components to communicate directly across a network

Front 59

Which type of deployment project would you use to package an ActiveX component for download from a Webserver using a Web browser?

Back 59

Cab project

Front 60

What is localization?

Back 60

the process of translating an application's resources into different localized versions for each supported culture

Front 61

What is COMTI?

Back 61

COMTI(COM Transcation Integrator) in a Microsoft product that uses Host Integration Server to allow interaction between COM and IBM CICS transactions on a mainframe.

Front 62

Which service must be running on all SQL Server computers involved in a distributed transaction?

Back 62

the Microsoft Distributed Transaction Coordinator(MSDTC) service

Front 63

Which six categories of security threats does the STRIDE model represent?

Back 63

1.Spoofing identity
2.Tampering
3.Repudiation
4.Information disclosure
5.Denial of service
6.Elevation of privilege

Front 64

What is an XML Web service proxy class?

Back 64

The class instance that the client uses to interact with an XML Web Service. When you add a reference to a Web service to your project, a proxy class is automatically created for you to use.

Front 65

What is Microsoft SQL Server 2000 Query Analyzer?

Back 65

a graphical tool provided with SQL Server that allows you to create and execute SQL scripts, use predefined script templates, easily manage database objects, execute and debug stored procedures, and debug performance problems with queries

Front 66

When using a Web Setup project, where are the files installed when the installation is run?

Back 66

into a virtual root directory on a Web server

Front 67

Does Microsoft SQL Server support encrypted database fields?

Back 67

No

Front 68

For what reason would you use Caspol.exe?

Back 68

to modify security policy for the machine policy level, the user policy level, and the enterprise policy level

Front 69

What is the purpose of horizontal filtering in replication?

Back 69

Horizontal filtering filters roes, not columns. It is based on a WHERE clause. Therefore, only certain rows will be replicated.

Front 70

If you are using Host Integration Server, how could you embed a legacy COBOL object in an HTML page?

Back 70

by including an HTML<OBJECT>tag and including a CODEBASE attribute that indicates the URL from which to download the component

Front 71

Can an XML Web service support asynchronous processing?

Back 71

Yes

Front 72

What is the industry standard maximum for response time?

Back 72

three seconds

Front 73

Which requires more development effort, an XML Web service or a .NET Remoting object?

Back 73

a .NET Remoting object

Front 74

What is an MDI interface?

Back 74

an interface that allows you to display multiple documents at the same time, with each document being displayed in its own window

Front 75

What type of application would you use to create a background executable that would run in its own Windows process?

Back 75

Windows service

Front 76

How is the .Licenses file created for a Visual Studio.NET project?

Back 76

Visual Studio.NET creates the file automatically, or the LC>exe utility can be used.

Front 77

How does an SDI application differ from an MDI application?

Back 77

An MDI application has a main window that contains one or more child windows(documents), while in an SDI application each document is independent of all the other windows.

Front 78

What are queued components?

Back 78

Queued components are COM+ components that are based on MSMQ(Microsoft Message Queuing Services) and use MSMQ to provide asynchronous execution.

Front 79

What is UDDI?

Back 79

Universal Description, Discovery, and Integration(UDDI) is a public collection of XML WEb services specifications to which you can publish your XML Web services. This allows others to locate your service.

Front 80

When would a two-tier application architecture be most appropriate?

Back 80

for small applications that have very few user interfaces or for quickly creating prototype applications

Front 81

What is HTTPS?

Back 81

HTTPS(Secure Hypertext Transfer Protocol) is a communications protocol designed to transfer encrypted information between computers over the Web. It is basically HTTP using SSL.

Front 82

What is a Windows installer package?

Back 82

a Microsoft Software Installation(MSI) file that contains data and logic needed by Windows Installer when installing a Windows application.

Front 83

What is GPO?

Back 83

A Group Policy Object(GPO) is a virtual collection of file system or Active Directory policy settings that affect a user or computer.

Front 84

For which purpose is Microsoft's BizTalk Server product most useful?

Back 84

integrating processes and applications betwen businesses

Front 85

Which three types of security are supported by XML Web services?

Back 85

Platform/transport-level(point-to-point), Application-level(custom), and Message-level(end-to-end)

Front 86

Which two methods are provided to share session state information across a Web garden or Web farm?

Back 86

You can share session state information across a Web garden or Web farm by storing the information in a State server or in a SQL Server database.

Front 87

Which term refers to attaching a digital signature(using a certificate from a CA) to a file to document the source and integrity of the file?

Back 87

signing

Front 88

By default, which protocol does ASP.NET use?

Back 88

HTML over HTTP

Front 89

In a Web page, what is the ALT attribute of an image commonly used for?

Back 89

The ALT attribute is commonly used to provide a textual representation of an image. This is reported to the accessibility aids for those users that are unable to see the images.

Front 90

Can the ASP.NET Session object be shared by machines?

Back 90

Yes, if Session state is maintained externally by a dedicated state server or SQL Server on which the state management script has been run.

Front 91

What functionality does Microsoft Host Integration Server provide?

Back 91

It allows data and application integration with host systems, such as IBM mainframes and AS/400 computers. Host Integration Server was previously known as Microsoft SNA Server.

Front 92

What does it mean for an application to be localizable?

Back 92

It means that the globalized application has been prepared for localization by having the application's code separated from the localizable user interface elements.

Front 93

For what purpose is a satellite assembly used?

Back 93

to deploy resource files for different locales

Front 94

What does Sn.exe do?

Back 94

Sn.exe(the Strong Name tool) is most commonly used to sign assemblies with strong names.

Front 95

Which default event log tracks events that occur on system components, such as drivers?

Back 95

system log

Front 96

What would be the easiest way to migrate a Microsoft Visual Basic 6.0 application that uses COM components to .NET?

Back 96

Create RCW's for the COM components and only rewrite the Microsoft Visual Basic 6.0 application, not the components.

Front 97

What are some of the guidelines for producing effective user interfaces?

Back 97

1.The design should be intuitive.
2.The design should use screen space efficiently.
3.The design should validate input and prevent inappropriate navigation.
4.The design should include online menus, toolbars, and other features that make navigation easier.
5.The design should provide online user assistance.
6.The interface should include appropriate error-handling.

Front 98

Which type of contextual help provides small pop-up windows that display a short description of a control?

Back 98

ToolTips

Front 99

Must a Web site implementing a Web service support discovery?

Back 99

No. A Web service can be private.

Front 100

Which file name extension does a dynamic discovery file have?

Back 100

.vsdisco

Front 101

To what does the term "throughput" refer?

Back 101

the number of client requests processed within a given amount of time (usually measured in requesrts/sec or pages/sec)

Front 102

What is the purpose of vertical filtering in replication?

Back 102

Vertical filtering filters columns, not rows. Therefore, only certain columns will be replicated.

Front 103

What does ASP.NET provide?

Back 103

the features necessary to build, deploy, and run Web applications and distributed applications with the .NET Framework

Front 104

Which term refers to the process required prior to accessing an XML Web service that includes locating the XML Web service's descriptions?

Back 104

discovery

Front 105

Which .NET Framework feature provides functionality similar to DCOM?

Back 105

.NET Remoting

Front 106

Why is it often more efficient to call a stored procedure to execute a set of SQL statements, than to directly call the SQL statements?

Back 106

Because the stored procedure is already compiled on the database server, it requires less overhead to execute. Also, a stored procedure requires less network traffic between the client and server than does sending multiple SQL statements.

Front 107

Which mode of session state management uses a Windows service to store session data?

Back 107

StateServer

Front 108

What is a serviced component?

Back 108

a class that can be hosted in a COM+ application and can act as a COM+ client

Front 109

Why is it recommended that you deploy your .NET projects by using an automated installation procedure rather than using XCOPY?

Back 109

When you use deployment projects, you can automatically configure IIS directory settings during the install. In addition, XCOPY does not verify the location of assemblies and could overwrite files that would cause problems with other applications.

Front 110

Which tool can you use to generate an XML schema from either XDR, XML, and XSD files or from classes in a run-time assembly?

Back 110

Xsd.exe (XML Schema Definition tool)

Front 111

Name five methods of providing online user assistance.

Back 111

1.Online Help
2.ToolTips
3.Wizards
4.Status bars
5.Accessibility aids

Front 112

To what does the term "response time" refer?

Back 112

the time that a user must wait for results after making a request, including the time it takes for the request to travel over communication links and the time it takes a system to process the request

Front 113

Which .NET object can you use to read from or write to Windows event logs or custom event logs that you define?

Back 113

EventLog

Front 114

Why might you use Microsoft SQL Server Analysis Services?

Back 114

to perform analytical processing (OLAP) or data mining

Front 115

What is CSS?

Back 115

CSS(Cascading style sheets) contain code that a browser can interpret and apply to a Web page or elements on a Web page. This usually includes the appearance or positioning of the page or elements.

Front 116

What functionality does the .NET TextWriterTraceListener class provide?

Back 116

It allows you to direct tracing or debugging output to the console or to a file.

Front 117

Which SQL Server wizard accepts SQL trace data and provides recommendations for indexes?

Back 117

Index Tuning Wizard

Front 118

Which action would you take to specify that a single page should maintain its view state?

Back 118

Set the EnableViewState property of the page's @Page directive to true.

Front 119

Which command-line tool allows you to import data only from a text file into a SQL Server database?

Back 119

the bcp utility

Front 120

Which default event log records events specific to a particular user program?

Back 120

application

Front 121

With regard to a database, to what does the term "partitioning" refer?

Back 121

the process of splitting the data into smaller segments, usually to improve the performance of queries or processing

Front 122

Which type of deployment project would you use for a stand-alone Windows-based application that used Windows installer technology?

Back 122

Setup project

Front 123

Why would you store ViewState information?

Back 123

because doing so saves all the state information and user input of the control in a hidden field on the Web Form, preserving the control's appearance and contents between calls (postbacks) to the server

Front 124

What are the advantages of installing assemblies into the global assembly cache?

Back 124

The GAC provides a shared location that is installed within the Windows directory. This provides increased security because the Windows directories have access restrictions by default. The GAC allows you to have multiple copies of assemblies with the same name but different version numbers and multiple applications accessing the same copy of the assembly simultaneously.

Front 125

Which .NET Framework class can you use to create client connections for TCP network services?

Back 125

TcpClient

Front 126

In a multi-tier, or n-tier, application, what is the presentation layer?

Back 126

The presentation layer, also called the user services layer, is the layer of the application that contains user interface components.

Front 127

Which two tools can you use to view the contents of your application's event log?

Back 127

You can use Server Explorer from Visual Studio.NET or use the Event Viewer of MMC.