Data management Flashcards
How Is the data on Share Point protected?
“When it comes to data protection in SharePoint, Microsoft has implemented several measures to ensure the security of your data. Here are some key points:
Ownership of Data: When you store your data in SharePoint and OneDrive for Microsoft 365, you remain the owner of the data1. For more information about data ownership, you can refer to Microsoft 365 Privacy by Design.
Administration and Access Control: Microsoft engineers administer SharePoint and OneDrive using a PowerShell console that requires two-factor authentication1. They perform day-to-day tasks through workflows, ensuring rapid response to new situations. Check-ins to the service require code review and management approval. No engineer has standing access to the service. When engineers need access, they must request it, and eligibility is checked. If approved, access is granted for a limited time. In rare cases where Microsoft engineers need access to content (e.g., if you submit a support ticket because a user can’t access an important file that is believed to be damaged), they must follow a specific workflow that requires business justification and manager approval1.
Data Safeguarding: One of the most important things you can do to safeguard your data is to require two-factor authentication for your identities in Microsoft 3651. This prevents credentials from being used without a second factor and mitigates the impact of compromised passwords. Other recommended security measures include using Azure Active Directory device-based conditional access to block or limit access on unmanaged devices, creating policies to sign users out of Microsoft 365 web sessions after a period of inactivity, and evaluating the need for IP-based sessions1.
Data Loss Prevention (DLP): SharePoint Online provides a feature called Data Loss Prevention (DLP) that helps protect your data while it is stored or shared2. This feature helps prevent sensitive data from being accidentally or maliciously shared outside your organization.
Data Resiliency: SharePoint uses Append-Only storage, which means that Microsoft can only add new blobs and can never change old ones until they’re permanently deleted3. This process ensures that files can’t be changed or corrupted after an initial save, protecting against attackers who try to corrupt old versions.”
Talk me through how you create new libraries In Share Point and how these benefit the team.
“To create a new library in SharePoint, you can follow these steps:
Go to the team site where you want to create a new document library.
On the menu bar, select New, and then select Document library.
Enter a name for the new library.
Select Create.
You can add additional document and other libraries to a site as needed 1.
Document libraries in SharePoint are used to securely store files where you and your co-workers can find them easily, work on them together, and access them from any device at any time 1. They help teams collaborate more effectively by providing a central location for storing and sharing files. You can also set up versioning, check-in/check-out, and other features to help manage your documents 1.”
How does ‘Business Objects’ Interact with Uniform?
“Business Objects can interact with other databases by using various techniques. One approach is to create a universe in Business Objects that connects to multiple databases1. A universe is a semantic layer that allows users to interact with data from different databases as if it were a single source1. To design a universe that interacts with multiple databases, you can follow these steps:
Create database links or synonyms to establish connections between the databases1.
Use derived tables to call tables from other databases along with the table name and the database link name1.
Specify the desired schema and access permissions for accessing tables from different databases1.
By following these steps, you can design a universe in Business Objects that interacts with multiple databases and allows users to access data from different sources seamlessly.
Please note that this is just one approach, and there may be other techniques or tools available for integrating Business Objects with databases”
How do you keep the data extracted up to date?
it’s a one use report which is run periodically
What additional Items do you request when verifying data extracted for rent review comparables?
How have you used previous property transaction sheets during your rent reviews?
How have you assisted in the development of a property information system?
How have you inputted survey and valuation data?
we do not use uniform to store our valuation data, it double handles the information from spreadsheets to the management system.
How have you extracted and used survey and valuation data?
we do put EPC information on Uniform.
How have you searched for comparable evidence?
How have you used data searches for due diligence functions?
How have you advised on data storage system? How have you advised on business filling systems? How have you benchmarked from analysed historic data? How have you advised on the use of a computerised central project database? How have you advised on security of data? How have you advised colleagues on relevant data through completing returns and market survey data? How have you complied with client’s data security requirements? How have you incorporated data research into complex reasoned advice to clients? How have you presented conclusions to clients from data research and analysis?
Why is It Important to maintain data Integrity in the Uniform database?
“Data integrity is crucial in a database for several reasons. It ensures the accuracy, completeness, and reliability of data1. By maintaining data integrity, you can create relationships between disparate data elements, ensuring that the data transferred from one stage to another is accurate and error-free1.
Data integrity is different from data security and data quality. While data security focuses on protecting enterprise data from misuse, data integrity deals with the accuracy and completeness of data present in the database1. Data quality, on the other hand, ensures that the stored data complies with the organization’s standards and requirements1.
Maintaining data integrity is essential because it helps in creating a stable and reliable database. It ensures that your entire dataset can be recovered and searched whenever needed, strengthening the stability of your data1. Moreover, it allows you to gain reliable insights from your data model, enabling you to make informed business decisions1.
In summary, maintaining data integrity in a database is important because it:
Ensures accuracy, completeness, and reliability of data.
Facilitates accurate and error-free data transfer between stages.
Strengthens the stability of your data.
Enables reliable insights for informed decision-making.”
How do you ensure this happens?
Explain how you created a script to perge the system.