Discussion
Home ‣ Certification ‣ Microsoft Certification Comments
- Question
How many-shares of market value RS.25 each can be purchased for Rs.12750, brokerage being 2% ?
Options- A. Rs.450
- B. Rs.500
- C. Rs.550
- D. Rs.600
- Correct Answer
- Rs.500
ExplanationCP. of each share= Rs.(25 + 2% of 25) = Rs.25.50.
Number of shares= = 500
- 1. You have a computer named Computer1 that runs Windows 7. You need to ensure that Computer1 can connect to File Transfer Protocol (FTP) servers only while it is connected to a private network. What should you do?
Options- A. From Windows Firewall with Advanced Security, create a new rule.
- B. From the local Group Policy, modify the application control policies.
- C. From Windows Firewall, modify the Allowed Programs and Features list.
- D. From Network and Sharing Center, modify the Advanced Sharing settings. Discuss
- 2. You develop an inventory management application called XYZManagement that will call a Microsoft SQL Server stored procedure named sp_GetDailyXYZSales. The stored procedure will run a query that returns your daily sales total as an output parameter. This total will be displayed to users in a message box. Your application uses a SqlCommand object to run sp_GetDailyXYZSales. You write the following code to call sp_GetDailyXYZSales: SqlConnection cnn = new SqlConnection(myConnString); SqlCommand cmd = new SqlCommand(?sp_GetDaily XYZ Sales?, cnn); cmd.CommandType = CommandType.StoredProcedure; SqlParameter prm = cmd.Parameters.Add(?@ItemTotal?,SqlDbType.Int); prm.Direction = ParameterDirection.Output; cnn.Open(); cmd.ExecuteNonQuery(); Now you must write additional code to access the output parameter. Which code segment should you use?
Options- A. MessageBox.Show(?Total is: ? + cmd.Parameters[?@Output?].Value.ToString());
- B. MessageBox.Show(?Total is: ? + cmd.Parameters[?@Output?].ToString());
- C. MessageBox.Show(?Total is: ? + cmd.Parameters[?@ItemTotal?
- D. MessageBox.Show(?Total is: ? + cmd.Parameters[?@ItemTotal? Discuss
- 3. You develop an enterprise application, called XYZApplication that includes a Windows Form presentation layer, middle-tier components for business logic and data access, and a Microsoft SQL Server database. You are in the process of creating a middle-tier component that will execute the data access routines in your application. When data is passed to this component, the component will call several SQL Server stored procedures to perform database updates. All of these procedure calls run under the control of a single transaction. The code for the middle-tier component will implement the following objects: SqlConnection cn = new SqlConnection(); SqlTransaction tr; If two users try to update the same data concurrently, inconsistencies such as phantom reads will occur. You must now add code to your component to specify the highest possible level of protection against such inconsistencies. Which code segment should you use?
Options- A. tr = cn.BeginTransaction(?ReadCommitted?);
- B. tr = cn.BeginTransaction(IsolationLevel.ReadCommitted);
- C. tr = cn.BeginTransaction(IsolationLevel.Serializable);
- D. tr = cn.BeginTransaction(?Serializable?); Discuss
- 4. You use Visual Studio .NET to create an assembly, called XYZAssembly, that will be used by other applications, including a standard COM client application. You must deploy your assembly on the COM application to a client computer. You must ensure that the COM application can instantiate components within the assembly as COM components. What should you do?
Options- A. Create a strong name of the assembly by using the Strong Name tool (Sn.exe).
- B. Generate a type library for the assembly by using the Type Library Importer (Tlbimp.exe). Register the file on the client computer.
- C. Generate a registry file for the assembly by using the Assembly Registration tool (Regasm.exe) Register the file on the client computer.
- D. Deploy the assembly to the global assembly cache on the client computer. Add a reference to the assembly in the COM client application. Discuss
- 5. You create an assembly by using Visual Studio .NET. The assembly is responsible for writing and reading order entry information to and from an XML data file. The assembly also writes and reads values to and from the Windows registry while it is being consumed. The assembly will be distributed to client computers by using your company, XYZ, intranet. All client computers are configured to implement the default .NET security policy. You need to implement security in the assembly. What should you do?
Options- A. Implement declarative security and execute the permission demand to allow access to the file system and Windows registry.
- B. Implement declarative security and execute the minimum permission request to allow access to the file system and Windows registry.
- C. Implement imperative security and execute the permission demand to allow access to the file system and Windows registry.
- D. Implement imperative security and execute the minimum permission request to allow access to the file system and Windows registry. Discuss
- 6. You are the database administrator for a financial services company. Employees enter data 24 hours a day into a SQL Server 2000 database. These employees report slower response times when new account information is gathered from branch offices and added to the database. You currently use the following BULK INSERT statement to add the account information.BULK INSERT finance.dbo.customersFROM 'd:bulkaccts143_10142000.txt'WITH DATAFILETYPE = 'char', FIELDTERMINATOR = 't', ROWTERMINATOR = 'n', TABLOCK You want to ensure that response times do not slow when new account information is added to the database. What should you do?
Options- A. Add the BATCHSIZE option to the BULK INSERT statement, and then set the option equal to 10 percent of the number of rows to be loaded.
- B. Add the ROWS_PER_BATCH option to the BULK INSERT statement, and then set the option equal to 10 percent of the number of rows to be loaded.
- C. Drop the indexes for the Customers table before the data load, and then re-create the indexes after the data load is complete.
- D. Remove the TABLOCK option from the BULK INSERT statement. Discuss
- 7. You are the administrator of a SQL Server 2000 computer. The server contains a database named FinanceData that is used by a client/server application. Each employee has a SQL Server login that the application uses to access the server.Your company hires a new employee named Andrew. You create a SQL Server login named Andrew. You also create a database user named Andrew in the database and grant the database user full permissions in the database.Whenever Andrew runs the client/server application, he receives the following error message: "Invalid object name." Andrew also reports that he cannot access the database by using the application.You need to ensure that Andrew can use the application. Which Transact-SQL statement should you execute?
Options- A. EXEC sp_defaultdb 'Andrew','FinanceData'
- B. GRANT ALL ON FinanceData TO Andrew
- C. EXEC sp_addlogin 'Andrew'
- D. EXEC sp_grantdbaccess 'FinanceData','Andrew'GOsp_addrolemember 'db_datareader','Andrew' Discuss
- 8. You are the administrator of a Microsoft Windows NT Server 4.0 computer. The server is the PDC in your domain and also runs SQL Server 2000. The server has four processors and 1 GB of RAM.Your network consists of 500 client computers that are running Microsoft Windows Millennium Edition. Users report that when they log on in the morning their computers respond slowly and occasionally return error messages.You use System Monitor to monitor processor performance and RAM utilization. You discover that the % Total Time and % User Time counters average 90 percent and the % Privileged Time counter averages 20 percent. The Available Mbytes counter averages 800 MB. You need to improve server performance for user logons. What should you do?
Options- A. Increase the physical RAM on the computer to 2 GB.
- B. Increase the virtual RAM on the computer to 4 GB.
- C. Configure SQL Server to use only processors 0, 1, and 2.
- D. Configure SQL Server to use only processors 1, 2, and 3. Discuss
- 9. You are an administrator of a SQL Server 2000 computer. The server contains a database that stores inventory data. Another database administrator has created a number of scheduled jobs to maintain the inventory database. Each weeknight the following jobs occur. - A BULK INSERT job imports data at 10:00 P.M - Indexes are rebuilt at 10:15 P.M - Data integrity checks are performed at 10:30 P.M - A differential backup is performed at 10:45 P.M - A DBCC SHRINKDATABASE job runs at 11:00 P.M. You notice that the final job often fails and returns the following error message: "Server: Msg 3140, Level 16, State 3. Could not adjust the space allocation for file 'inventory_data'."You need to ensure that the final job runs without errors. What should you do?
Options- A. Modify the DBCC SHRINKDATABASE job so that it uses DBCC SHRINKFILE statement to shrink each file individually.
- B. Create a new DBCC SHRINKFILE job to shrink the inventory_data file. Schedule the new job to run at the same time as the DBCC SHRINKDATABASE job.
- C. Increase the time between the differential backup and the DBCC SHRINKDATABASE job.
- D. Increase the time between the data integrity checks and the differential backup. Discuss
- 10. You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.Because you have had power interruptions in the past, you want to protect the physical integrity of the Accounts database. You do not want to slow down server operations.What should you do?
Options- A. Create a database maintenance plan to check database integrity and make repairs each night.
- B. Enable the torn page detection database option for each database.
- C. Disablewrite caching on all disk controllers.
- D. Ensure that write caching disk controllers have battery backups. Discuss
Microsoft Certification problems
Search Results
Correct Answer: From Windows Firewall with Advanced Security, create a new rule.
Correct Answer: MessageBox.Show(?Total is: ? + cmd.Parameters[?@ItemTotal?
Explanation:
The @ItemTotal parameter is declared as an output parameter with SQL Server data type INT.We use the Value property of the SQLParameter class to retrieve the value of this parameter. We must also convert the INT value to a string value with the ToString method. We then supply this string to the MessageBox.Show method.
Incorrect Answers
Option A, B:
The @ItemTotal parameter is the output parameter. Using @Output this way is incorrect. Output is a keyword and no variable named @Output has been declared.
Option D:
We must use the Value method to retrieve the value of the parameter..
Correct Answer: tr = cn.BeginTransaction(IsolationLevel.Serializable);
Explanation:
Serializable is the highest isolation transaction level. It provide the highest possible level of protection against concurrent data errors. The correct syntax to begin a transaction with this transaction isolation level is: cn.BeginTransaction(IsolationLevel.Serializable)
Correct Answer: Generate a registry file for the assembly by using the Assembly Registration tool (Regasm.exe) Register the file on the client computer.
Explanation:
The Assembly Registration tool reads the metadata within an assembly and adds the necessary entries to the registry, which allows COM clients to create .NET Framework classes transparently. Once a class is registered, any COM client can use it as though the class were a COM class..
Incorrect Answers:
Option A:
The Strong Name tool helps sign assemblies with strong names.
Option B:
The Type Library Importer, tlbimp.exe, converts the type definitions found within a COM type library into equivalent definitions in a common language runtime assembly. It would not be useful in this scenario however.
Option D:
This would not allow the COM application to use the class.
Correct Answer: Implement declarative security and execute the minimum permission request to allow access to the file system and Windows registry.
Explanation:
You can use declarative code access security to request permissions for the entire assembly. SecurityAction flags that can be specified in an assembly-wide directive. When SecurityAction.RequestMinimum is specified, it makes a request to the common language runtime to be granted the requested permission. If the requested permission is not granted by the security policy, the assembly will not execute. A Security Action.RequestOptional is similar, but the assembly will still run even if the requested permission is not granted. Specifying security Action. RequestRefuse requests that the assembly be denied the specified permission.
You must use the Assembly (assembly) directive when specifying these actions as follows:
Option A:
There are only three Security actionAttributes targets for an assembly: RequestMinimumAssembly, RequestOptionalAssembly, and RequestRefuseAssembly.
Option C, D:
Imperative security does not work well to configure security for an entire assembly. In imperative security, permission to execute is demanded at run time.
Correct Answer: Remove the TABLOCK option from the BULK INSERT statement.
Explanation:
The TABLOCK hint increases the number of locks during the adding process. This is the reason why response time are slows down during this process. By removing the TABLOCK hint the default more granular row-level lock will be used. This would decrease the scope of the locks which would result in less waiting jobs and performance would improve.
Note: The BULK INSERT statement is used to copy a data file into a database table or view in a format specified by the user. The BULK INSERT statement accepts the TABLOCK hint, which allows the user to specify the locking behavior that the BULK INSERT statement should use. TABLOCK specifies that a bulk update table-level lock is taken for the duration of the bulk copy. If TABLOCK is not specified, the default uses row-level locks.
Correct Answer: EXEC sp_defaultdb 'Andrew','FinanceData'
Explanation:
Error 208 produces the message 'Invalid object name' and occurs when an object that does not exist in the current database is referenced. If the object exists in another database, we must use the USE statement to explicitly switch the context to the correct database or we must qualify the object name with the database name. A third option is to use the sp_defaultdb stored procedure. This stored procedure is used to change the default database for a login. When a client connects with SQL Server, the default database defined for its login becomes the current database without an explicit USE statement. The default database can be defined when the login is added with
sp_addlogin. When executing sp_addlogin the master database is the default database if a database is not specified. In this scenario a SQL Server 2000 login and a user account has been created for Andrew and he has been given database access and the required permissions.
Correct Answer: Configure SQL Server to use only processors 1, 2, and 3.
Explanation:
The system monitor clearly indicates that the processors are overloaded. We need to decide which processors we should use for SQL Server. Processor 0 is the default CPU for the I/O subsystem. Network Interface Cards (NIC) are assigned to the remaining CPUs, starting from the highest-numbered CPU. The NIC would get processor 3.
SQL Server would be using all four processors by default.
The Windows NT/2000/XP operating system use processor 0. In order to avoid the logon
problems we should not let SQL Server to use this processor. Instead SQL Server should be configured to use processor 1, 2, and 3.
Note 1: The Affinity mask is used to exclude a processor on a multiprocessor computer from processing SQL Server 2000 threads. Default is equal distribution of SQL Server 2000 processes across all processors.
Note 2: Monitoring the Processor and System object counters provides information about the CPU utilization and helps in determining whether or not a bottleneck exists. The %Total Processor Time is used on multiple CPU Severs to gauge the average activity of the processors and shows the percentage of elapsed time that a processor is busy executing a nonidle thread. Values around 100 percent on a Server computer that processes many client requests indicate that processes are queuing up, waiting for processor time, and causing a bottleneck. Such a sustained high level of processor usage is unacceptable for a server.
Correct Answer: Increase the time between the differential backup and the DBCC SHRINKDATABASE job.
Explanation:
The DBCC SHRINKDATABSE cannot be executed until the previous job step, the differential backup, has been completed. We should increase the time between these two job steps, or even better configure the last job step to run only after the differential backup has been completed.
Note: The DBCC SHRINKDATABASE statement shrinks data files on a per-file basis but shrinks log files as if all the log files existed in one contiguous log pool. The target size for the data and log files cannot be smaller than the minimum size of a file that was specified when the file was originally created, or the last explicit size set with a file size changing operation such as the ALTER DATABASE statement with the MODIFY FILE option or the DBCC SHRINKFILE statement.
Correct Answer: Ensure that write caching disk controllers have battery backups.
Explanation:
The scenario states that power interruptions have occurred in the past. By buying a battery backup solution for the disk controllers the power interruption problem would be prevented.
Comments
There are no comments.Programming
Copyright ©CuriousTab. All rights reserved.