布丁学网

You are the administrator of your company's network. A user

  • 下载次数:
  • 支持语言:
  • 1840
  • 中文简体
  • 文件类型:
  • 支持平台:
  • pdf文档
  • PC/手机
  • 【名词&注释】

    布丁学网发布"You are the administrator of your company's network. A user"考试试题下载及答案,更多微软认证的考试试题下载及答案考试题库请访问布丁学网计算机类考试频道。

  • [单选题]You are the administrator of your company's network. A user named Paul in the service department has a Windows 2000 Professional computer. Paul needs to access the files that are in a shared folder on his computer. A local group named Sales has permissions to access the data. Paul is a member of the Sales local group but he cannot access the file he needs.What should you do?

  • A. Grant Paul NTFS permission so that he can access any parent folder to files in the shared folder.
    B. Share the Sales folder and grant Paul shared folder permission to access the shared Sales folder.
    C. Remove Paul from any other group that has been explicitly denied access to the Sales folder.
    D. Delete the Sales local group and recreate it. Add individual user accounts from the Sales department back into Sales local group.

  • 查看答案&解析查看所有试题
  • 学习资料:
  • [单选题]You are the administrator of a SQL Server 2000 computer. You create a Data Transformation Services (DTS) package. The package is stored as a local package on the server. The package exports data from an online transaction processing (OLTP) database system to an online analytical processing (OLAP) database system that is located on a second SQL Server 2000 computer.You want the package to execute automatically each evening at 8:00 P.M. What should you do?
  • A. Use SQL Server Enterprise Manager to create a new job Create a CmdExec job step that runs the dtsrun utility Schedule the job to run each night at 8:00 P.M.
    B. Use SQL Server Enterprise Manager to create a new job Create a Transact-SQL job step to query data from the OLTP database Create a second Transact-SQL job step to launch the DTS package Schedule the job to run each night at 8:00 P.M.
    C. Create a batch file that runs the dtsrun utility Use the Microsoft Windows Task Scheduler to run the job each night at 8:00 P.M. Configure the Windows Task Scheduler to use the local system account
    D. Move the DTS package to the repository Configure the SQLServerAgent service on the OLAP database server to update the package each night at 8:00 P.M.

  • [多选题]You are the administrator of a SQL Server 2000 computer. The server contains a Data Transformation Services (DTS) package that queries multiple databases and writes the results to a text file. You run this package by using a Microsoft Windows batch file. The batch file uses the dtsrun utility to execute the DTS package.You want to ensure that connection properties, such as login names and passwords, cannot be read or modified by users. Which two actions should you take? (Each correct answer represents part of the solution. Choose two.)
  • A. Save the DTS package so that it has an owner password.
    B. Save the DTS package so that it has a user password.
    C. Encrypt the DTS package details in the command line of the dtsrun utility.
    D. Store the DTS package in the Meta. Data Services repository.
    E. Store the DTS package as a Microsoft Visual Basic file.

  • [单选题]You are the administrator of a SQL Server 2000 database named Articles. A large city newspaper uses this database to store its archived newspaper articles. Journalists query the database as part of their research. You have created full-text indexes so that users can query the articles quickly.A hardware failure forces you to restore the entire database from backup. After you restore the database, the journalists report that they can no longer run queries without receiving errors.
  • A. You want to ensure that the journalists can query the database. What should you do?
    B. Create a new full-text catalog for the Articles database
    C. Rebuild the full-text catalog for the Articles database
    D. Create a new full-text index on the table that holds the text for the articles
    E. Repopulate the full-text index on the table that holds the text for the articles

  • [单选题]You are the administrator of a SQL Server 2000 computer named SQL1. You want to perform. ad hoc distribution queries against a database that is stored on a SQL Server 2000 computer named SQL2. SQL2 contains several databases, and each of these databases uses a different collation.You want to ensure that comparisons in distributed queries are evaluated correctly. You also want to minimize administrative overhead.
  • A. How should you configure SQL1?
    B. Use the ALTER DATABASE statement to change the collation of the databases on SQL1.
    C. Add SQL2 as remote server.
    D. Add SQL2 as a linked server. Select the Use Remote Collation check box, and do not specify a collation name.
    E. Add SQL2 as a linked server. Select the Use Remote Collation check box, and specify a collation name. Repeat this process once for each database on SQL2.

  • 本文链接:https://www.51ksbd.net/show/9zyl76.html
  • 推荐阅读
    @2019-2025 布丁学网 www.51ksbd.net 蜀ICP备20012290号-1 川公网安备 51012202001362号